Database Drivers

Speedtest Tracker supports multiple database drivers including SQLite, MySQL and Postgres.

Since Speedtest Tracker is built on the Laravel Framework any of the framework's supported database drivers are also supported.

SQLite ships as the default driver but you can also use MySQL/MariaDB and Postgres. While SQL Server is supported by Laravel it hasn't been tested with Speedtest Tracker so no support will be provided for that driver.

Driver Options

SQLite (Default)

SQLite is a good option for simple installs and only not recommended because I think separating your application and the database into separate services is a better idea.

To use SQLite follow the steps below to create your database file:

Create a volume called speedtest-tracker or mount a directory to the container.
Create a file called database.sqlite, you can do this by running touch database.sqlite in the mounted volume or create it in the mounted directory.
Update your environment variables to only include the following environment variable in the table below.
On start-up the container will checked for the database on the file system, if it can find it errors will be thrown to the log.

Environment Variable

Value

MySQL/MariaDB

MariaDB ships as the default database that's included in the docker-compose.yml configuration, it's functionally the same as MySQL just an open-source earlier fork.

Environment Variable

Value

Postgres

PreviousUsing Unraid NextEnvironment Variables

Last updated 9 months ago