Skip to main content

MySQL

Appliku supports MySQL 8 as an alternative relational database engine. The provisioning workflow is identical to PostgreSQL, with connection URLs automatically injected into your application.

Supported Versions

VersionNotes
MySQL 8Current supported release

Provisioning a MySQL Database

  1. Open your application in the Appliku dashboard
  2. On the Application Overview page, scroll to the Databases block (bottom-right sidebar)
  3. Click Add Database
  4. Select MySQL 8 from the dropdown
  5. Select the server where the database should run
  6. Click Create

Appliku provisions a MySQL Docker container and generates connection credentials automatically.

Connection URL

Once provisioned, Appliku injects the connection URL as an environment variable:

mysql://user:password@host:port/dbname

Your application can read this variable to connect without any manual credential management.

Differences from PostgreSQL

If you are deciding between MySQL and PostgreSQL, consider the following:

AspectPostgreSQLMySQL
Specialized variantsPostGIS, pgvector, TimescaleDBNone
Built-in backup toolYes (via Appliku)Manual only
Version options12, 15, 16, 178
JSON supportAdvanced (JSONB)Basic (JSON)
note

Appliku's built-in backup scheduling currently supports PostgreSQL only. For MySQL databases, you will need to handle backups manually using mysqldump or a similar tool.

Using MySQL with Django

# settings.py
import dj_database_url

DATABASES = {
"default": dj_database_url.config(default="sqlite:///db.sqlite3")
}

Ensure mysqlclient is in your requirements.txt:

mysqlclient

Using MySQL with Other Frameworks

Most frameworks support reading a DATABASE_URL environment variable natively or through an adapter library. Refer to your framework's documentation for connection string parsing.

Next Steps