दस्तावेज़ीकरण अभी केवल अंग्रेज़ी है। बाकी साइट आपकी भाषा का अनुसरण करती है।
Databases
PostgreSQL, MySQL 8+, and MariaDB 10.6+ — how to choose, connect, and migrate.
5 मिनट पढ़ा
You do not need to know SQL to run Justflows. Pick the database your host already offers, or use Postgres in Docker.
| Database | When to use it | URL scheme |
|---|---|---|
| PostgreSQL (default) | New installs. Bundled in the default Compose file. | postgres://… |
| MySQL 8+ | The host already provides MySQL. | mysql://… |
| MariaDB 10.6+ | The host already provides MariaDB. | mariadb://… |
Docker variants
# MySQL
docker compose -f docker/docker-compose.mysql.yml --env-file .env up
# MariaDB
docker compose -f docker/docker-compose.mariadb.yml --env-file .env upConnection settings
The wizard writes DB_DRIVER, DB_HOST, DB_PORT, DB_NAME, DB_USER, DB_PASSWORD, and the matching DATABASE_URL. The server routes use the discrete values; core-backed subsystems also require DATABASE_URL. TLS is controlled by DB_SSL and DB_SSL_REJECT_UNAUTHORIZED.
Migrations
SQL lives in migrations/, with matching PostgreSQL, MySQL, and MariaDB files from 0001_initial through 0009_audit_log_compat. Run them from the wizard, from Admin → Tools, via POST /api/db/migrate (administrator), or justflows db migrate.
Note
The @justflows/database package is the shared client for Postgres and MySQL/MariaDB (mysql2). Schema modules live there; the running admin uses the Express SQL routes in apps/server.
Migrations
Migrations 0001–0012 are consolidated into a single 0012_baseline file per dialect, cutting the shipped footprint from 36 files to 3. Fresh installs and existing sites run the same ordered schema changes; completed baselines are recorded in _migrations, and later schema changes continue at 0013. Run them from Admin → Health or justflows migrate.