A relational database with a stronger feature set than MySQL for complex queries, JSON storage, and data integrity — the default choice when a project's data model gets more demanding.
Why I use it
Native JSON/JSONB support when part of the data model doesn't fit a rigid schema
Stronger constraint and transaction guarantees for financial or compliance-sensitive data
Excellent full-text search without a separate search service, for moderate scale
Where it fits
Applications with complex relational data or reporting needs
Projects already running on platforms (Supabase, most modern PaaS) that default to Postgres