Inhaltsverzeichnis

2.2 Configurare Database

Connessioni database preconfigurate (DSN).

Array Databases

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

Parametri

Parametro Descrizione
Name Nome univoco (percorso URL)
Dialect Tipo di database
ConnectionString Stringa di connessione

Dialetti

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