Tuesday, August 26, 2014

DBA - choose right database for your project


NoSQL Database
  • RethinkDB (http://www.rethinkdb.com/)
  • MongoDB
  • RavenDB


When is NoSql database not a good choice?

  • If you need full ACID support or strong schema enforcement — in this case you are better off using a relational database such as MySQL or PostgreSQL.
  • If you are doing deep, computationally-intensive analytics you are better off using a system like Hadoop or a column-oriented store like Vertica.
  • If you absolutely need high write availability and do not mind dealing with conflicts, you may be better off with a Dynamo-style system like Riak.