What to use in Rails to organize a database, MongoDB or (pg, sqlite)?

Question

Ruby on Rails

We are developing an information portal, we need high performance. I heard a lot about NoSQL databases, I was very attracted to Monga, if anyone has experience in using and implementing projects, please share.

Answer 1

Simple version: take PostgreSQL.
Complex: Depends on the data. And then take PostgreSQL.

Answer 2

You can't go wrong with PostgreSQL.

• ActiveRecord is much easier to work with than Mongoid, plus better documentation and in general there are a lot more questions on Stackoverflow (16264 vs 940)
• Whatever they say about the advantages of schemaless, in the end, most databases have a structure, and in this case a relational database is more reliable, faster and easier to maintain
• If you still need to store schemaless data, then PostgreSQL supports hstore, json and jsonb data types with full indexes and internal content search

Answer 3

I want to do transportation in the city, please tell me which car to buy: a sedan or a truck?

Answer 4

For an information portal, it will obviously be faster than ordinary relationals. postgresql mysql

Answer 5

If you yourself cannot answer this question, then either the task is beyond your strength, or take what you own. In any case, from the start you will not guess all the possible problems of your particular portal, so you still have to redo something. Maybe you will even switch to exotics such as generating statics and returning it through Nginx. Then it will be purple, which database, at least sqlite