====== 2.2 Configure Databases ======

Preconfigured database connections (DSN).

===== Databases Array =====

<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>

===== 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:**
<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>