SQL vs NoSQL: What’s The Best Database And When?


That can be explained with a simple flowchart:

databases flowchart.png
Full Size ImagePDF Version

 

See also:

 

Advertisements

2 thoughts on “SQL vs NoSQL: What’s The Best Database And When?

    • I mentioned CitusDB for PostGreSQL. Could mention Galera for MySQL.

      Basically, SQL cannot work on distributed systems. It breaks transactions, joins and a tons of stuff.

      These solutions that tries to plug sharding on top of SQL are a big hack. They usually end up with the database underneath barely recognizable and half of the SQL and features dropped. Not to mention they take a lot of dirty engineering and exploratory work to get working.

      If what you want is multi-master, use a database that is intended to do that out of the box. The most common being Cassandra. At least, it’s clear on it’s capabilities, you can get help from the official documentation and the internet and there is expertise available.

      Like

Post a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s