Skip to content

Instantly share code, notes, and snippets.

@Iltwats

Iltwats/sqldiff.md Secret

Last active August 23, 2021 14:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Iltwats/0082b1ea4435b3fbe87a53038529382b to your computer and use it in GitHub Desktop.
Save Iltwats/0082b1ea4435b3fbe87a53038529382b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqldiff.md
SQL Databases NoSQL Databases
Data Storage Model Tables with fixed rows and columns Document: JSON documents, Key-value: key-value pairs, Wide-column: tables with rows and dynamic columns, Graph: nodes and edges
Development History Developed in the 1970s with a focus on reducing data duplication Developed in the late 2000s with a focus on scaling and allowing for rapid application change driven by agile and DevOps practices.
Examples Oracle, MySQL, Microsoft SQL Server, and PostgreSQL Document: MongoDB and CouchDB, Key-value: Redis and DynamoDB, Wide-column: Cassandra and HBase, Graph: Neo4j and Amazon Neptune
Primary Purpose General purpose Document: general purpose, Key-value: large amounts of data with simple lookup queries, Wide-column: large amounts of data with predictable query patterns, Graph: analyzing and traversing relationships between connected data
Schemas Rigid Flexible
Multi-Record ACID Transactions Supported Most do not support multi-record ACID transactions. However, some—like MongoDB—do.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment