SQL vs NoSQL Database Differences
| SQL | NoSQL |
|---|---|
| called as Relational Databases (RDBMS) | called as non-relational or distributed database. |
| represent data in form of tables | are document based, key-value pairs, graph databases or wide-column stores. |
| have predefined schema | have dynamic schema for unstructured data. |
| are vertically scalable | are horizontally scalable |
| for defining and manipulating the data | queries are focused on collection of documents |
SQL Database Examples
- MySQL Community Edition MySQL database is very popular open-source database. It is generally been stacked with apache and PHP, although it can be also stacked with nginx and server side javascripting using Node js. The following are some of MySQL benefits and strengths:
Replication: By replicating MySQL database across multiple nodes the work load can be reduced heavily increasing the scalability and availability of business application Sharding: MySQL sharding os useful when there is large no of write operations in a high traffic website. By sharding MySQL servers, the application is partitioned into multiple servers dividing the database into small chunks. As low cost servers can be deployed for this purpose, this is cost effective. Memcached as a NoSQL API to MySQL: Memcached can be used to increase the performance of the data retrieval operations giving an advantage of NoSQL api to MySQL server. Maturity: This database has been around for a long time and tremendous community input and testing has gone into this database making it very stable. Wide range of Platforms and Languages: MySql is available for all major platforms like Linux, Windows, Mac, BSD and Solaris. It also has connectors to languages like Node.js, Ruby, C#, C++, C, Java, Perl, PHP and Python. Cost effectiveness: It is open source and free.