Database

OpenPost uses SQLite by default when you run it yourself. Hosted installs can use Postgres by changing the database driver.

Default path

The backend code defaults to:

file:openpost.db?cache=shared&mode=rwc

For container deployments, prefer an explicit file path such as:

/data/db/openpost.db

Operational notes

• Persist the database on durable storage.
• Back up the database together with the media directory.
• Do not keep the database inside ephemeral container layers.
• SQLite is configured for a simple single-node deployment model.

Driver settings

OPENPOST_DATABASE_DRIVER=sqlite
OPENPOST_DATABASE_PATH=file:openpost.db?cache=shared&mode=rwc

For Postgres-backed deployments:

OPENPOST_DATABASE_DRIVER=postgres
OPENPOST_DATABASE_URL=postgres://openpost:secret@db.internal:5432/openpost?sslmode=require

Cloud mode

When OPENPOST_EDITION=cloud, OpenPost refuses to start unless:

• OPENPOST_DATABASE_DRIVER=postgres
• OPENPOST_DATABASE_URL is set

This stops a hosted server from starting with a local SQLite file by mistake. SQLite remains the recommended choice for a small self-hosted server.