[question] Moving from SQLite to other database engine

[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?

[muety]

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.