Database setup
Pick where LedgerLeaf should store data. SQLite is the default; Postgres is recommended for Railway and team deployments.
Active configuration
Engine
SQLite (local file)
Connected
Filedata/ledgerleaf.db
Source
Default
SQLite
DefaultA single file under DATA_DIR/ledgerleaf.db. Zero config. Great for a personal install or a Railway volume.
- No external service to manage
- Persists on a Railway volume
- Backups are a single file copy
PostgreSQL
Recommended for RailwayProvide a connection URL or fill the fields below. LedgerLeaf creates the schema on first connect.
Where this is stored
- Environment variable DATABASE_URL — set in Railway. Always wins over the front-end choice.
- Front-end choice — saved to DATA_DIR/config.json on the server.
- Default — SQLite at DATA_DIR/ledgerleaf.db.