Migrate to different database

Wakapi supports different database management systems (DBMS), including MySQL, Postgres and SQLite. You may have started out with SQLite for simplicity, but want to migrate to a standalone database as your instance grows (or vice versa.

The most convenient way (even though probably not necessarily the fastest) to accomplish this is dbmigrate.go.

First, you'll need to create a config file, e.g. migrate.yml:

with_key_values: true
with_users: true
with_leaderboard: false
with_language_mappings: true
with_aliases: true
with_summaries: false
with_durations: false
with_heartbeats: true
with_project_labels: true
users:
    # optional, if not set, all users will be migrated
    - user1
    - user2

Then, run (you'll need Go for this):

go run dbmigrate.go -config migrate.yml