🗃️PostgreSQL
Also known as Postgres, psql
A free, open-source SQL database with lots of tools. Many teams pick it first.
Think of it like
Think of it like a big free toolbox. It has a tool for nearly every job.
Example
Lucy starts a new booking app and picks PostgreSQL. Its server listens on port 5432 by default.
Why it matters
PostgreSQL is a safe choice for most new apps. It grows with you from one user to millions.
Definition
Example code
console
$ psql -d shop -c "SELECT count(*) FROM orders;"
count
-------
1200
(1 row)Common mistake
Key takeaways
- 1Free and open. No licence fee.
- 2Careful. Strict about ACID and SQL.
- 3Many features. JSON, maps and text search too.