MySQL

The default database for Bugsink is SQLite. In cloud-based environments, MySQL may be a better fit. This page describes how to set up Bugsink with MySQL.

Dockerized Bugsink

When you run Bugsink in a Docker container, the MySQL database is configured using a single environment variable, in the following format:

"mysql://user:password@host:port/database_name"

The necessary Python package (mysqlclient) is automatically installed in the Docker container (it’s part of the standard image).

Python Virtual Environment Based Setups

When you install Bugsink in a Python virtual environment, you need to install the mysqlclient package manually (the default database is SQLite, which doesn’t require any additional packages). The package can be installed using the following command:

pip install mysqlclient

In this setup, your settings are in bugsink_conf.py; you may configure mysql like so:

DATABASES['default'] = {
    'ENGINE': 'django.db.backends.mysql',
    'NAME': "...",  # the name of your database
    "USER": "...",  # the user to connect as
    "PASSWORD": "...",  # the password to use
    "HOST": "...",  # the host to connect to
    "PORT": "...",  # the port to connect to (usually 3306)
}