OriginChain vs Supabase. A Postgres-plus-platform and an AI-native database, side by side.

The honest split. Pick the one that matches your workload.

Supabase has done something genuinely useful for the industry: it took a relational primary engineers already trusted and bundled the boring-but-essential pieces — auth, file storage, realtime channels, edge functions — into one platform. For a relational-first application that occasionally needs an embedding, that bundle is hard to beat. The interesting question is whether the AI surface is a side feature on a relational app, or whether the AI surface is the application. The answer to that question decides the database.

Postgres with the boring parts already built.

Supabase's core insight is that most application teams do not just need a database — they need a database, an auth provider, a file store, a realtime channel, and a place to run a tiny piece of server-side logic. Stitching those together used to mean four vendors and a weekend. Supabase ships them as one platform, with Postgres as the source of truth and the rest exposed through APIs that respect row-level security. For a solo developer or small team, that bundle is the fastest path from idea to deployed application that the industry has yet produced.

The Postgres-native posture matters. Every ORM (Prisma, Drizzle, SQLAlchemy, ActiveRecord) talks to a Supabase database the same way it talks to RDS or a self-hosted Postgres. Migrations are plain SQL. Extensions install the way they always do. If you outgrow the platform or want to move, the data and schema are portable in a way that is genuinely rare among modern managed databases. The free tier is generous enough that hobbyists and side projects can ship without paying anything, and the Studio interface — table editor, SQL console, log explorer, auth viewer — is one of the best dashboards in the segment.

Vectors are a real capability via pgvector, which now supports HNSW indexes and is genuinely usable for retrieval workloads. Full-text via tsvector is respectable. Realtime subscriptions and Edge Functions plug straight into the same row-level-security model, so a feature like "stream new messages to anyone authorised to see this room" is a few lines of SQL and a JavaScript handler. For a relational-first application where the AI features are additive, Supabase is often the right call.

AI shapes are first-class. Not extensions you wire up.

OriginChain is built around a single hash-keyed key-value store. Rows, secondary indexes, vector embeddings, HNSW graphs, BM25 full-text postings, and graph edges all live in that store under different domain prefixes. The query engine compiles SQL, vector top-k, BM25 search, graph traversal, and natural-language questions to the same plan tree. There are no extensions to install or version-pin because the AI shapes are not extensions — they are the substrate. HNSW has two operating points worth naming: the default high_recall mode hits recall@10 = 0.96 at 100k vectors with p99 around 109 ms, and a fast mode runs p99 around 37 ms at recall@10 ≈ 0.69.

The consequence is atomicity that crosses shapes. A single insert writes the row, every secondary index entry, every forward and reverse edge, the BM25 postings, and the vector embedding in one batch. That batch lands as one WAL frame and hits one fsync. With Supabase, the same insert in pgvector + tsvector lives inside a Postgres transaction — which is excellent — but if you are also writing to ParadeDB indexes, Apache AGE edges, or any out-of-process derived state, you are back to writing your own consistency story. OriginChain folds the entire derived state into the one frame.

Tenancy is physical. Each customer gets a dedicated single-tenant database in a region of their choice — its own HTTPS endpoint, its own bearer token, its own write-ahead log, its own encrypted disk. Supabase pools many projects onto shared Postgres infrastructure, which is the right trade-off for the price point and the workloads they target; OriginChain's trade-off is the opposite. If a noisy neighbour cannot exist by construction is part of your compliance or performance budget, that matters.

Natural language is part of the same surface. /v1/ask compiles an English question to the same plan AST as a hand-written query — same cost model, same EXPLAIN output, same per-node statistics. The model emits a plan; the executor runs it. There is no LLM on the hot path, no token-priced query layer to budget for, and no second service to deploy alongside the database.

What "one INSERT, one WAL frame" actually buys you.

The standard architecture for an AI feature on Supabase is a Postgres transaction that touches a row, a tsvector column, and a pgvector column. Inside one transaction, that is genuinely atomic — Postgres's MVCC keeps the three writes consistent. The seam shows up when the AI surface grows. Add an Apache AGE edge for graph context, a ParadeDB index for richer full-text, a search-service mirror for typo-tolerant retrieval, or an out-of-process embedding worker, and the consistency story splits across services. Most teams paper over the gap with retry queues and reconciliation jobs.

OriginChain folds the entire derived state into the write path. The row, the embedding, the full-text postings, every edge update — all of them are part of the same write_batch, which lands as one WAL frame. A torn frame is dropped on recovery, so there is no half-written state to clean up. That property is verified at runtime: a panic-injection harness deliberately crashes the writer at four boundaries inside the WAL flush, and recovery is asserted to equal a prefix of the op stream every time. We run it for a million deterministic iterations on every CI build.

Reads compose the same way. A query can filter on structured columns, rank by vector similarity, intersect with a BM25 search, and join across a graph edge — in one round trip, against one consistent snapshot. With Supabase, a query that combines pgvector + tsvector + a recursive CTE for graph context is possible inside one Postgres statement; once a fourth shape (or a non-Postgres engine) enters the picture, you are stitching results in application code. OriginChain exists because that boundary is exactly where AI applications keep getting bitten.

The detailed comparison.

A capability-by-capability look. None of this is meant to score points against Supabase — it is meant to make the trade-off explicit so you can pick correctly for your workload.