Databases

Relational versus non-relational databases

SQL (relational) NoSQL (non-relational)
Tables / schema Humongous data, collections, documents, duplication of data
Structured Semi/no structure, flexible
Relations Less dependence on relations, quick reads
Atomic Eventually consistent
Monolithic Distributed

Scaling

Considerations

SQL -- "Structured Query Language"

Relational databases are "Excel on steroids"

PostgreSQL -- AKA Postgres

Examples

SELECT -- id, name, price -- FROM -- product
SELECT -- fields -- FROM -- table

Commands

Every new row has the same fields: schema.

NoSQL - Not only SQL

mongoDB

mongoDB comes form "humongous". Instead of tables we have collections which contain documents -- looks a bit like JSON. Each document can use a different structure (schema). Generally there are no relations.

Less relation merging therefore fast queries. At the expense of duplication of data.

Types of NoSQL database

ACID

References