You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
[question] Moving from SQLite to other database engine #746
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?
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.
Repository owner locked and limited conversation to collaborators on Feb 20, 2025
Activity
chore: update db migration tool (see #746) [skip ci]
muety commentedon Feb 20, 2025
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.