哪个是 Rails 应用程序的最佳数据库? [英] Which is the Best database for Rails application?

问题描述

我正在开发一个 Rails 应用程序，该应用程序将访问大量 RSS 提要或抓取网站以获取数据(主要是新闻).它将类似于 Google 新闻，但采用不同的方法，因此我将存储大量新闻(或新闻摘要)，将它们分类为不同的类别，并使用排名和推荐技术.

I am developing a Rails application that will access a lot of RSS feeds or crawl sites for data (mostly news). It will be something like Google News but with a different approach, so I'll store a lot of news (or news summaries), classify them in different categories and use ranking and recommendation techniques.

• 我应该使用 MySQL 吗?

• Should I go with MySQL?

是否值得使用 IBM DB2purexml 来存储文件?还有 Ruby 搜索实现(雪貂、Ultrasphinx 等)是不需要 如果我选择 DB2.对吗?

Is it worthwhile using IBM DB2 purexml to store the doucuments? Also Ruby search implementations (Ferret, Ultrasphinx and others) are not needed If I choose DB2. Is that correct?

有什么优点PostreSQL 在这?

What are the advantages of PostreSQL in this?

在中使用 Couch DB 有意义吗?这种情况?

Does it makes sense to use Couch DB in this scenario?

我想选择最佳选项，但不会使解决方案过于复杂.所以我放弃了使用两种不同存储解决方案的想法(一种用于新闻文档，另一种用于其余数据).我也在考虑只免费".选项，所以我没有看 Oracle 或 MS SQL Server.

I'd like to choose the best option but without over-complicating the solution. So I discarded the idea to use two different storage solutions (one for the news documents and other for the rest of the data). I'm also considering only "free" options, so I didn't look at Oracle or MS SQL Server.

推荐答案

purexml 比 SQL 更重，所以你需要为 webserver 和 DB 之间的往返付出更多.如果你打算有很多用户，我会避免它，你最好让你的网络服务器缓存请求，从而避免每次都创建 xml(rss)，如果你正在考虑的话.

purexml is heavier than SQL, so you pay more for your roundtrip between webserver and DB. If you plan to have lots of users, I'd avoid it, your better off letting your webserver cache the requests, thus avoiding creating xml(rss) everytime, if that is what you are thinking about.

我会选择 MySQL，因为它非常擅长服务，而且完全免费，PostgreSQL 也是，但没有使用过，所以我不能说.

I'd go with MySQL because its really good at serving and its totally free, well PostgreSQL is too, but haven't used it so I can't say.

CouchDB 可能有意义，但如果您打算对数据进行 OLAP(离线分析)，那么普通的 RDBMS 会更好.

CouchDB could make sense, but not if you plan on doing OLAP (Offline Analysis) of your data, a normal RDBMS will be better at it.

这篇关于哪个是 Rails 应用程序的最佳数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！