PostgreSQL
The World's Most Advanced Open Source Relational Database
★ 4.8
The world's most advanced open-source relational database. Powers Supabase, Neon, and countless production systems. Known for reliability, feature richness, and extensibility.
free
Pricing
Yes
Self-Hostable
Features
- ✓ ACID compliant transactions
- ✓ Advanced SQL support (CTEs, window functions)
- ✓ JSON/JSONB for document storage
- ✓ Full-text search built-in
- ✓ Extensible (PostGIS, pgvector, etc.)
- ✓ Row-level security
- ✓ Logical and streaming replication
- ✓ Foreign data wrappers
Pros
- + Industry standard - massive ecosystem
- + Extremely reliable and battle-tested
- + Rich feature set (JSON, FTS, extensions)
- + Strong consistency and ACID compliance
- + Excellent documentation
Cons
- − Requires self-hosting or managed service
- − More complex than SQLite for simple apps
- − Connection pooling often needed
- − Steeper learning curve than MySQL