====== 2.2 Konfiguracija baza podataka ======

Unaprijed konfigurirane veze na baze podataka (DSN).

===== Databases polje =====

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

===== 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:**
<code>
Server=hostname;Database=dbname;User Id=user;Password=pass;TrustServerCertificate=true
</code>

**SQLite:**
<code>
Data Source=%DATA_PATH%\database.db
</code>

**MySQL:**
<code>
Server=hostname;Database=dbname;User=user;Password=pass
</code>

**PostgreSQL:**
<code>
Host=hostname;Database=dbname;Username=user;Password=pass
</code>