====== 2.2 Konfiguracija podatkovnih baz ======
Vnaprej konfigurirane povezave do podatkovnih baz (DSN).
===== Polje Databases =====
"Databases": [
{
"Name": "demo",
"Dialect": "sqlite",
"ConnectionString": "Data Source=demo.db"
},
{
"Name": "erp",
"Dialect": "mssql",
"ConnectionString": "Server=dbserver;Database=ERP;Trusted_Connection=true"
}
]
===== Parametri =====
^ Parameter ^ Opis ^
| Name | Edinstveno ime (URL pot) |
| Dialect | Tip podatkovne baze |
| ConnectionString | Povezovalni niz |
===== Dialekti =====
^ Dialect ^ Podatkovna baza ^
| ''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