How To Pick a Database?

Question

In this day and age, with a new NoSQL databases popping up every weekend..

Are there any good and up-to-date resources on how to pick a database(s) that will suit your web application needs?

score 1 · Answer 1 · edited May 23 '17 at 11:47

1

Cassandra vs MongoDB vs CouchDB vs Redis vs Riak vs HBase vs Membase vs Neo4j comparison

NoRAM DB => “If It Does Not Fit in RAM, I Will Quietly Die For You”

Although I would also advise considering a SQL data back end ( e.g. PostgreSQL, Drizzle ) with a cache layer, e.g. Redis on top of it. Unless you have an actual reason to use NoSQL. The reason can by the way be NoSQL is cool and I'd like to learn it, but if that is all, usually it may hurt at the end.

Does the problem have to do with money transactions? Are you going to have a distributed system?

edited May 23 '17 at 11:47

Community

1
1

answered Oct 11 '11 at 02:33

tolitius

22,149
6
70
81

Any comparisons with regular SQL DB's? – CamelCamelCamel Oct 11 '11 at 02:35
2

Do you have a specific problem to solve? Because that what should guide your decision the most. – tolitius Oct 11 '11 at 02:36
1

@Radagaisus, here is a good concise comparison of [SQL vs NoSQL Databases](http://stackoverflow.com/questions/4160732/nosql-vs-relational-database) – tolitius Oct 11 '11 at 02:57
I want to understand the differences between the databases from a developer point of view – CamelCamelCamel Oct 11 '11 at 02:58

score 1 · Accepted Answer · answered Oct 11 '11 at 02:43

If you're interested in trade-offs and feature comparisons Wikipedia tends to be updated more than others.

Relational Database Comparison: http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

NoSQL Feature Comparison: http://en.wikipedia.org/wiki/Comparison_of_structured_storage_software

If you want a more direct answer you can always post the requirements you have and you'll get a lot of helpful answers. It's a pretty broad subject and, other than feature comparison matrices like the ones above, you'll mainly get subjective answers unless you have an objective question (ie specific requirements).

How To Pick a Database?

2 Answers2