2.2 Configure Databases

Preconfigured database connections (DSN).

Databases Array

"Databases": [
  {
    "Name": "demo",
    "Dialect": "sqlite",
    "ConnectionString": "Data Source=demo.db"
  },
  {
    "Name": "erp",
    "Dialect": "mssql",
    "ConnectionString": "Server=dbserver;Database=ERP;Trusted_Connection=true"
  }
]

Parameters

Parameter Description
Name Unique name (URL path)
Dialect Database type
ConnectionString Connection string

Dialects

Dialect Database
mssql SQL Server, Azure SQL
sqlite SQLite
mysql MySQL, MariaDB
postgresql PostgreSQL

Connection Strings

SQL Server:

Server=hostname;Database=dbname;User Id=user;Password=pass;TrustServerCertificate=true

SQLite:

Data Source=%DATA_PATH%\database.db

MySQL:

Server=hostname;Database=dbname;User=user;Password=pass

PostgreSQL:

Host=hostname;Database=dbname;Username=user;Password=pass
Zuletzt geändert: on 2026/01/29 at 11:20 PM