PostgreSQL
The default database. If Postgres can do it, we do it in Postgres.
PostgreSQL is a battle-tested open-source relational database with a reputation for correctness and extensibility. It handles more than most teams realise — full-text search, JSON, geospatial, row-level security, even vector similarity with pgvector.
Deliberate, not decorative.
Every system that needs a real database starts on Postgres, usually hosted on Supabase or a managed instance. We lean heavily on row-level security for multi-tenant systems and use pgvector for embedding storage so we rarely need a separate vector database.
- Core business data for client portals, CRMs, and internal tools
- Multi-tenant apps where row-level security keeps tenants isolated
- Embedding storage with pgvector for AI-powered semantic search
- Analytics extracts staged in Postgres before shipping to BigQuery
- Spreadsheet-based operations that break the moment two people edit at once
- NoSQL stores chosen for hype then regretted when joins become necessary
- Separate vector databases that double the operational burden
Official resources for PostgreSQL.
The team behind PostgreSQL runs the docs, pricing, and sign-up. Start there when you are ready to try it.
Want help putting PostgreSQL to work?
We design, build, and maintain systems around PostgreSQL every week. If you have a problem it could solve, let’s talk about what to build.