SQL vs noSQL

Jump to bottom

Melissa Stock edited this page May 21, 2019 · 1 revision

SQL vs noSQL

SQL

Relational db
Table based
Predefined schema
Vertically scaled
Uses SQL to manipulate data
Ex: MySQL, Oracle, Sqlite, Postgres, and MS-SQL

noSQL

distributed db
Document based (ie: KVP, graph, etc)
Dynamic schema
Horizontally scaled
Uses UnQL to manipulate data, which syntax varies from doc to doc
Ex: MongoDB, BigTable, Redis, RavenDB, Cassandra, Hbase, Neo4j, and CouchDB