Inhaltsverzeichnis

2.2 Konfiguracija baza podataka

Unaprijed konfigurirane veze na baze podataka (DSN).

Databases polje

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

Parametri

Parametar Opis
Name Jedinstveni naziv (URL putanja)
Dialect Tip baze podataka
ConnectionString Niz za povezivanje

Dijalekti

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

Connection Stringovi

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