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 runningtouch 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 |
---|---|
|
The |
| The FQDN or address to the database instance. |
|
|
| Name of the database you'll connect to. |
| User that'll be used to connect to the database. |
| Password for the user above. |
Postgres
Environment Variable | Value |
---|---|
|
|
| The FQDN or address to the database instance. |
|
|
| Name of the database you'll connect to. |
| User that'll be used to connect to the database. |
| Password for the user above. |
Last updated