MariaDB

Supported via database-sql-mariadb. The MariaDB JDBC driver ships on the platform classpath.

As the default database

DIRIGIBLE_DATASOURCE_DEFAULT_DRIVER=org.mariadb.jdbc.Driver
DIRIGIBLE_DATASOURCE_DEFAULT_URL=jdbc:mariadb://db.example.com:3306/dirigible
DIRIGIBLE_DATASOURCE_DEFAULT_USERNAME=dirigible
DIRIGIBLE_DATASOURCE_DEFAULT_PASSWORD=<secret>

As a named pool

{
    "name": "ReportsDB",
    "driver": "org.mariadb.jdbc.Driver",
    "url": "jdbc:mariadb://db:3306/reports",
    "username": "${env.REPORTS_USER}",
    "password": "${env.REPORTS_PASSWORD}"
}

Notes

• TLS is configured via the standard MariaDB URL parameters (useSsl=true, etc.).
• ID generation: IDENTITY (AUTO_INCREMENT) is the natural fit. Sequences exist in modern MariaDB.

See also

• Working with data
• Data source artefact