// Database
PostgreSQL
Our default relational database for production applications.
8+ years
// Overview
How we use PostgreSQL
PostgreSQL is our default database for all applications with relational data — which is most of them. Its ACID guarantees, rich query language, JSON support, full-text search, and pgvector extension for AI workloads make it an exceptionally capable system.
// Use cases
- Transactional SaaS applications
- Multi-tenant data stores
- Financial data with ACID requirements
- AI applications with vector similarity search
- Complex reporting with window functions
// Why it matters
ACID transactions
Full transaction support with serialisable isolation — appropriate for any application where data integrity is non-negotiable.
JSON + relational
jsonb columns enable flexible schema sections within a structured relational model — no need to choose between relational and document stores.
pgvector for AI
Native vector similarity search via pgvector makes PostgreSQL the right choice for RAG applications without introducing a separate vector database.