Our Default Database
PostgreSQL is the most capable open-source relational database in existence. ACID-compliant, extensible with custom data types and functions, and battle-tested at Shopify, Instagram, and Discord — it handles everything from a 10-user startup to a 10-million-user platform without a schema change.
Advanced Features We Use in Production
- JSONB for hybrid relational/document storage
- Full-text search with tsvector and GIN indexes
- Row-level security for multi-tenant data isolation
- Logical replication for read replicas and event streaming
- pg_cron for scheduled jobs inside the database
- TimescaleDB extension for time-series data