Configure a custom app DB

In DataRamen, you control where your data is stored. By default, a SQLite database is created on the machine where DataRamen is running.

Caution

While the default SQLite database works fine when using the CLI tool, you should configure a custom database when self-hosting. This is because self-hosted services often run in ephemeral environments, where SQLite data will not persist between restarts.

To configure a database connection, set the following environment variables:

Variable name	Accepted values
APP_DB_TYPE	mysql or postgres
APP_DB_HOST	Database host URL
APP_DB_PORT	Database port
APP_DB_DATABASE	Database name
APP_DB_USERNAME	Database username
APP_DB_PASSWORD	Database user password
APP_DB_SCHEMA	Database schema (Postgres only)
APP_DB_LOGGING	Whether to log internal queries (queries DataRamen performs as part of its operations)

Caution

When connecting to a production database, it is strongly recommended to create a dedicated user with read-only access.

The Insert/Update feature is intended for development databases. Manually modifying data in production is not recommended and may cause issues.

Follow this guide on how to update environment variables.