NoSQL (MongoDB , Big Table) vs SQL (MySQL)

What are the pros of a NoSQL database

- Dynamic schema: As mentioned, this gives you flexibility to change your data schema without modifying any of your existing data. - Scalability: MongoDB is horizontally scalable, which helps reduce the workload and scale your business with ease. - Manageability: The database doesn't require a database administrator. Since it is fairly user-friendly in this way, it can be used by both developers and administrators. Speed: It's high-performing for simple queries. - Flexibility: You can add new columns or fields on MongoDB without affecting existing rows or application performance.

What are the Pros of a MySQL database

- Maturity: MySQL is an extremely established database, meaning that there's a huge community, extensive testing and quite a bit of stability. - Compatibility: MySQL is available for all major platforms, including Linux, Windows, Mac, BSD and Solaris. It also has connectors to languages like Node.js, Ruby, C#, C++, Java, Perl, Python and PHP, meaning that it's not limited to SQL query language. - Cost-effective: The database is open source and free. - Replicable: The MySQL database can be replicated across multiple nodes, meaning that the workload can be reduced and the scalability and availability of the application can be increased. - Sharding: While sharding cannot be done on most SQL databases, it can be done on MySQL servers. This is both cost-effective and good for business.

Detailed Differences between SQL and NoSQL

- NoSQL stand for No Only SQL (Structured Query Language) Queries: - NoSQL has basic support for SQL queries MySQL has full support for SQL queries - NoSQL has MapReduce (and Materialized View) MySQL has Aggregations - MySQL has joins NoSQL does not - MYSQL all in all has more advanced queries with no limitations Transactions (atomic operations): - NoSQL supports transactions thru Entity Groups - NoSQL supports cross entity group transactions but it doesn't scale very well Consistency: Most update date information is guaranteed. Scalability: -no provisioning -automatic load splitting and balancing Schema: - MySQL schema is strictly enforced. It is set at table creation - MYSQL has alter table but it locks up the table for the duration of the change and is a complex process - NoSQL has very flexible on the fly schema changes aka it has a dynamic schema

What can you expect from NoSQL databases

-You can create documents without having to first define their structure -Each document can have its own unique structure -The syntax can vary from database to database, and -You can add fields as you go.

How is data in a NoSQL database stored?

In many ways! it can be: - column-oriented - document-oriented - graph-based or - organized as a KeyValue store.

What are examples of NoSQL databases

MongoDB, BigTable, Redis, RavenDB, Cassandra

What are examples of SQL databases?

MySQL, Oracle, PostreSQL

Are NoSQL databases Horizontally or vertically scalable

NoSQL databases, on the other hand, are horizontally scalable. This means that you handle more traffic by sharding, or adding more servers in your NoSQL database

When are SQL databases a better option?

SQL databases are table-based. This makes relational SQL databases a better option for applications that require multi-row transactions EX: accounting system system that monitor inventory

Are SQL databases Horizontally or vertically scalable?

SQL databases are vertically scalable, which means that you can increase the load on a single server by increasing things like CPU, RAM or SSD

When is a NoSQL database a better option?

rapid growth, undefined or ever changing schema, this is often the case for mobile apps and real-time analytics systems.