Databases SQL Databases

SQL Databases

The default choice for many products: strong correctness, powerful querying, and mature tooling.

Relational model

Tables, rows, and relations; great for multi-entity queries and constraints.

ACID transactions

Strong correctness guarantees for critical business invariants.

Indexes

Fast point/range lookups; cost extra writes and storage.

Scaling pattern

Scale reads via replicas; scale writes via sharding/partitioning or specialized systems.

Next steps

Which Database? (decision tree)PostgreSQL Documentation SQL vs NoSQL