Skip to content

[question] Moving from SQLite to other database engine #746

Closed

Description

@hatkidchan

Simple thing: I initially used SQLite as my database backend because it's easy and really lightweight, but I'm considering to move off of it to, say, MySQL or PostgreSQL.
So far I couldn't find anything regarding that on Wiki or readme, but process looks straightforward to me: dump SQLite database into .sql file, maybe adapt it a little bit, import to whatever database I'll end up with and then change corresponding settings in the Wakapi config. But..
Is there a better way to do this? Are there any plans on migration tools between databases? Will anything break if I go with my intuition? Of course, backups are necessary, yada-yada, but does all of that sound remotely right?

Activity

  1. added a commit that references this issue on Feb 20, 2025
  2. muety commented on Feb 20, 2025

    @muety
    Owner

    Hi @hatkidchan, yes, copying the database tables one by one should work. Also check out sqlite2mysql.go, which I created as a standalone tool for exactly that purpose. However, I haven't used it in a while, so might not be up to date anymore. Give it a try and report back.

  3. Repository owner locked and limited conversation to collaborators on Feb 20, 2025
  4. converted this issue into a discussion #747 on Feb 20, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions