Inspect a point in time
Review rows and schema as they existed earlier.
Free database · restore any record to a previous value
A free cloud database
that can travel through time.
Under the hood, database.pizza is a custom SQL engine backed by PizzaKV, a fast key-value store written in Zig. It uses SQLite-style type affinity, speaks the PostgreSQL wire protocol, runs queries over HTTP, and includes custom permissions for each API key, live metrics, and usage data.
SQLite type affinity PostgreSQL wire HTTP API Scoped API keys Live metrics
production / commerce
LIVE
INSERT
ordersid=2048, status='paid'
UPDATE
inventorystock = stock - 1
ALTER
customersADD COLUMN tier TEXT
DELETE
sessionsexpired = true
WAL HISTORY
-15m-10m-5mnow
Restore this pointdata + schema + indexes
Built-in database history
Inspect an earlier state.
Restore when needed.
Writes and schema changes are recorded in WAL history. Drag, tap, or use the arrow keys to inspect the database at a point in time.
Interactive demoDrag the history tape
INIT Empty database — no tables yet
1/ 99
users 0 rows
| id | name | role | |
|---|---|---|---|
| — empty — | |||
products 0 rows
| id | name | price | stock |
|---|---|---|---|
| — empty — | |||
orders 0 rows
| id | user | product | status |
|---|---|---|---|
| — empty — | |||
Recover from mistakes
Restore the state before a bad migration or destructive query.
Review what changed
Use query activity and history to understand an incident.
The engine
A custom SQL stack.
PizzaSQL is not a PostgreSQL wrapper. It is a custom SQL engine that speaks the PostgreSQL wire protocol and uses PizzaKV, our Zig key-value store.
YOUR APPORM / psql / fetch()
->
DATABASE.PIZZAauth + tenant routing
->
CUSTOM ENGINEPizzaSQL + PizzaKVisolated process + WAL
01Engine
A custom SQL engine
PizzaSQL is our SQL engine, built specifically for database.pizza. Each organization runs its own PizzaSQL and PizzaKV processes.
02Access
PostgreSQL and HTTP
Connect with psql, existing drivers, and ORMs through the PostgreSQL wire protocol, or execute SQL over authenticated HTTP.
03Storage
History in the storage layer
PizzaSQL runs on PizzaKV, a custom Zig key-value store. Its WAL records data and schema changes for inspection and recovery.
04Console
Practical database controls
Browse schemas, run SQL, inspect query activity, manage API keys, and monitor WAL, CPU, and memory from the web console.
Supported interfaces
PostgreSQL or HTTP.
Use standard database tooling from a server, script, or application.
01 PostgreSQL wire
Bring your driver.
Connect with psql and PostgreSQL-compatible clients over the standard wire protocol.
$ psql \
-h db.database.pizza \
-d acme/production02 HTTP / JSON
Bring your fetch.
Execute parameterized SQL through a simple authenticated endpoint.
POST /acme/production/query
{
"sql": "SELECT * FROM orders"
}Web console
The details you need.
Browse schemas, edit rows, run SQL, inspect query activity, manage keys, review history, and monitor WAL, CPU, and memory.
benchmarkUsage
LiveWAL storage5.4 MB
Current RSS43.7 MB
CPU0.8%
SELECT
orders WHERE status = ?1.2 msINSERT
events (type, payload)0.8 msUPDATE
inventory SET stock = ?2.4 msFree plan
$0 to start.
No credit card. The free plan includes database history, both supported interfaces, isolated engines, and the web console.
FREE
$0/ month
- 3 databases
- 500K queries per week
- 100 MB WAL storage
- 100 PostgreSQL connections
- Full operational history