Drone requires the use of a database backend for persistence. Drone uses an embedded sqlite database by default, which does not require any additional configuration. This article provides a basic overview of alternate database configurations.
Postgres
Drone supports postgres 9.6 and higher as the database engine. The below example demonstrates postgres database configuration. Please reference the official driver documentation for connection string configuration details.
DRONE_DATABASE_DRIVER=postgres
DRONE_DATABASE_DATASOURCE=postgres://root:password@1.2.3.4:5432/postgres?sslmode=disable
MySQL
We strongly recommend using postgres instead of mysql. The system has been optimized for features not found in mysql.
Drone supports mysql 5.6 and higher as the database engine. The below example demonstrates mysql database configuration. Please reference the official driver documentation for connection string configuration details.
DRONE_DATABASE_DRIVER=mysql
DRONE_DATABASE_DATASOURCE=root:password@tcp(1.2.3.4:3306)/drone?parseTime=true