Skip to content

Postgres

Set DATABASE_URL=postgres://... — that’s the entire migration from SQLite. The API, filter syntax, and rules are identical either way, verified by running the same integration test suite against both backends (crates/db/tests/). The one genuine capability upgrade: realtime becomes cross-node via LISTEN/NOTIFY, so a deployment behind a load balancer with more than one app instance stops silently dropping events for clients parked on a different instance than the one that handled a write. See Horizontal scaling for what that takes in practice: what’s stateless, the pg_notify mechanics, proxy config, migration races, and rolling deploys.