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.