Database

Configure and manage LNbits databases - SQLite for development, PostgreSQL for production.

LNbits supports SQLite (default) and PostgreSQL for data storage.

SQLite

The default database. Data is stored in the data/ directory.

bash

LNBITS_DATA_FOLDER=./data

Good for small instances and development. Not recommended for production with multiple concurrent users.

Recommended for production. See the PostgreSQL installation guide for setup instructions.

bash

LNBITS_DATABASE_URL=postgres://user:pass@localhost:5432/lnbits

LNbits runs database migrations automatically on startup. Each extension manages its own migrations.

bash

cp -r ./data ./data-backup-$(date +%Y%m%d)

bash

pg_dump -U lnbits lnbits > lnbits-backup-$(date +%Y%m%d).sql

TIP

Always back up before updating LNbits. Migrations cannot be reversed.