Build the Next Generation of Data-Driven Applications.
Open protocols, a documented plan language and tests you can rerun. Connect with the PostgreSQL tools and drivers you already have, over the simple protocol or prepared statements.
$ PGPASSWORD=$TOKEN psql -h 127.0.0.1 -p 45432 -U app -d uf
uf=> CREATE TABLE orders (id bigint PRIMARY KEY, cust int NOT NULL,
status text, amount numeric(12,2), placed date);
uf=> INSERT INTO orders VALUES (1, 7, 'paid', 120.50, '2024-03-02');
uf=> SELECT status, count(*), sum(amount)
FROM orders GROUP BY status ORDER BY status;From Idea to a Verified
Query in Minutes.
The five steps below are exactly what the repository's end-to-end test does.
1Get a token
An RS256 token with your tenant, clearance and roles, sent as the PostgreSQL password.
PGPASSWORD=$TOKEN
2Connect
psql or pgx to the gateway; it verifies the token and so does the node.
psql -h 127.0.0.1 -p 45432 -U app -d uf
3Create & write
Tables need a primary key; columnar with WITH (storage = columnar).
INSERT INTO events VALUES (…)
4Query
Filters, joins, GROUP BY, ORDER BY, LIMIT. Every plan verified first.
SELECT … GROUP BY status
5Verify
Compare answers with your current engine; the e2e test compares with DuckDB.
answers equal
What to read
Nine pages, written from the repository, updated with each phase.
All documentationSQL and psql
Token login, the SQL that works today, SQLSTATEs for the rest.
Node protocol v0
Request kinds, codes 100–112, canonical encoding over the Unix socket.
Ultra IR
The plan language: types, operators, canonical form, fingerprints.
Security model
The guarantee, who is trusted, and the known gaps.
Storage engine
WAL, group commit, tables, compaction, recovery.
Architecture
Each layer, its job, and its status.
How we test
Crash campaigns, differential and isolation testing, proofs.
Status and roadmap
Phase gates and what each one measured.
Drivers and SDKs
Anything that speaks the PostgreSQL protocol connects now, with or without parameters. ORMs additionally need the pg_catalog tables, which are the next gateway item.
psql
Tested end to end.
BuiltGo pgx
Tested end to end, simple protocol and prepared statements.
BuiltPython, Node.js, Java, Rust
Their PostgreSQL drivers speak the protocols that are built; not yet in the test suite.
In progressNative SDKs and CLI
A management CLI and typed SDKs follow the managed service.
PlannedEarly access includes the test scripts.
Ask for a hosted database and the end-to-end suite to run against it.