Postgres (PostgreSQL) is a relational [[database]] and one of the most common choices for web apps.

It's SQL-first and very good at "boring but critical" things like transactions, constraints, and keeping data consistent when multiple users are hitting the system at once.

A few reasons I keep reaching for it:
- mature and stable
- great tooling
- strong performance for normal app workloads
- can still handle semi-structured data via JSON/JSONB when needed

Also shows up all over hosted platforms like [[Supabase]].
