Move from SQLite to Postgres

Problem

You prototyped on SQLite and want to deploy on Postgres without rewriting queries.

rustango's ORM and migrations are tri-dialect. Point DATABASE_URL at Postgres, run migrations, and re-seed — the same code runs unchanged.

# .env
DATABASE_URL=postgres://user:pass@localhost:5432/app

cargo run -- migrate          # applies the same migration chain on PG
cargo run -- create-tenant …  # if multi-tenant

Seed with the ORM

Write data seeders against the ORM (not raw SQL) — they're dialect-agnostic, so the exact same seeder reconstructs your content on any backend.

← How-to guides