Database URLs
What is a Database URL?
The Database URL is the connection string of a database.
By default in Mitto it is the local database (postgresql://localhost/analytics).
The structure of database connection strings is as follows:
<driver>://<username>:<password>@<server>:<port>/<database><?parameters>
Common database drivers and parameters:
DBMS | Driver |
|---|---|
| PostgreSQL | postgresql |
| SQL Server | mssql+turbodbc |
| SQL Server | mssql+pyodbc |
| MySQL | mysql+pymysql |
| MariaDB | mysql+pymysql |
| Amazon Redshift | redshift+psycopg2 |
DBMS | Parameter |
|---|---|
| SQL Server | ?driver=ODBC+Driver+17+for+SQL+Server |