Key technologyRelational store4 min
Relational SQL database, the safe default for transactional data.Core featuresACID transactionsJoins, constraints, foreign keysStrong consistencyExtensions: JSONB, PostGIS, full-textRead replicas via streaming replicationWhen to useMoney, orders, anything needing transactionsRelational data queried with joinsThe default until scale forces otherwiseWhether every reader sees the latest write, and how soon.Keeping data correct when many requests touch it at once.Keeping copies of data on several nodes for durability and read scale.Splitting data across machines so no single node holds it all.
PremiumPostgreSQL
The relational default: transactions, joins and constraints on one primary, until scale forces you off it.
Premium
This technology page is on the Premium plan
Readers with Lifetime Access read it in full. Already bought it? Sign in from the top bar.
What’s inside
- At a glance
- Key concepts and capabilities
- Use cases