Infrastructure
Supabase
Infrastructure
What it is
Supabase is a hosted platform built around Postgres. It adds authentication, auto-generated APIs, file storage, realtime subscriptions and edge functions, and supports the pgvector extension for embedding search. The core is open source and can be self-hosted.
How we use it
Postgres, auth and vector search for AI apps.
Real Postgres from day one
Projects start on a database that will still be the right answer later, with schema migrations in version control rather than clicked into a dashboard.
Row-level security as the authorisation model
Access rules sit in the database beside the data, so a new endpoint or client library cannot accidentally route around them.
Embeddings next to the records they describe
Vector search in the same database as the operational data keeps retrieval joins simple and keeps permissions consistent between the two.
Typical builds
- The backend for an internal tool with auth, roles and an audit table.
- A retrieval store for a knowledge assistant, holding documents and embeddings together.
- The operational database behind a client portal with row-level access rules.
- Scheduled jobs and edge functions handling webhook ingestion.
Where it stops fitting
Every platform has a point past which it is the wrong answer. Better to know it now.
Row-level security is powerful and easy to get subtly wrong. Policies need their own tests, because an over-permissive policy is invisible right up until it becomes a disclosure.
The conveniences are platform-specific even though Postgres is not. Auth, generated APIs and edge functions all have to be replaced if you leave, and self-hosting is a genuine exit but an operations commitment, not a fallback.
Connection limits and pooling behaviour bite serverless workloads first. A function that opens a connection per invocation will exhaust the pool under load, so that has to be designed up front rather than discovered during a traffic spike.
Services built on it
Supabase is a trademark of its respective owner. Scale Hardened builds on this platform and is not affiliated with, endorsed by, or a certified partner of its vendor. Platform capabilities, pricing and terms are set by the vendor and may change.
Building on Supabase?
Book a strategy call. We will look at the workflow first and tell you honestly whether this is the right platform for it.