TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Friendly: NoSQL With MySQL in Ruby

83 点作者 edwardog超过 15 年前

6 条评论

antirez超过 15 年前
Even if NoSQL solutions are new, there are no data durability concerns in my opinion.<p>I can talk for Redis but my guess is that's the same for the other datastores. In Redis to have full durability enable append-only-file: it's a text-only file, you can check by hand what's written inside your database.<p>In addition even while running in append only file mode, you can still ask Redis to "BGSAVE" (crete a copy of the dataset into an .rdb file in background). It's a single file and you can save it everywhere.<p>With the append only file, it's trivial to write a script to export ALL YOUR DATA into MySQL every 24 hours for instance. So you have your data in:<p>a) compact .rdb file you can backup easily. b) the append only file c) MySQL, where you can perform query to check if the data is sane.<p>In addition in the next months Redis will get a JSON export feature built-in, so you can also d) save data into a JSON file.<p>This new products are still younger than MySQL, and there are more bugs probably, but it's just a matter of being a bit more careful to use this DBs in production without concerns, experiencing a huge performance gain.<p>p.s. since the release of Redis 1.0 no critical bugs were found.
评论 #1001300 未加载
riffraff超过 15 年前
just to point it out, postgres now has a builtin hash data type. This sees like it could be a better solution thatn serialized json <a href="http://www.postgresql.org/docs/8.4/static/hstore.html" rel="nofollow">http://www.postgresql.org/docs/8.4/static/hstore.html</a>
astine超过 15 年前
This reminds me of Elephant, a CL OODBMS that can use Postgres as a key/value store backend. OODBs, document stores, et al. are useful but using a complete RDBMS as a backend is both overkill and inefficient in my opinion.
评论 #1001340 未加载
aarongough超过 15 年前
Looks great! I remember seeing the article about FriendFeed's datbase setup and thinking how neat it was. Very nice to see a simple implementation of that idea become easily available.<p>Now I just have to find a project where I'll need to use it!
leej超过 15 年前
how is the cpu trade-off like in this type of setting? one more point is that i dont know ruby and i'm curious how can he add an index from that column?
Tompy超过 15 年前
If only this was written in python...<p>A port anyone?
评论 #1001807 未加载
评论 #1001721 未加载
评论 #1001570 未加载