Drone supports several relational databases. If you don’t have a strong preference, SQLite is a great starting point. Once you have configured your database, continue onward to Create and Run a Drone Container

SQLite

Drone uses an embedded SQLite as the default database with zero configuration required. In order to customize the SQLite database configuration you should specify the following environment variables:

DATABASE_DRIVER=sqlite3
DATABASE_CONFIG=/var/lib/drone/drone.sqlite

Postgres

Configure a Postgres database backend:

DATABASE_DRIVER=postgres
DATABASE_CONFIG=postgres://root:[email protected]:5432/postgres?sslmode=disable

See the official postgres connection string documentation for a complete set of configuration options and examples.

MySQL

Configure a Mysql database backend:

DATABASE_DRIVER="mysql"
DATABASE_CONFIG="root:[email protected](localhost:3306)/drone?parseTime=true"

See the driver documentation for a complete set of configuration options and examples.

Note that Drone does not automatically create the mysql database. You should use the mysql command line utility or your preferred management console to create the database:

mysql -P 3306 --protocol=tcp -u root -e 'create database if not exists drone;'