Technology/Postgres.md

Postgres

Markdown

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.