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

[hatkidchan]

Ah, I'm not digging into Go yet, but that script didn't even compile for me:

> go run sqlite2mysql.go -config ../migration-config.yaml
../utils/db.go:9:2: package log/slog is not in GOROOT (/usr/lib/go-1.19/src/log/slog)
../../../go/pkg/mod/github.com/getsentry/sentry-go@v0.31.1/interfaces.go:11:2: package slices is not in GOROOT (/usr/lib/go-1.19/src/slices)
> go version
go version go1.19.8 linux/amd64
> cat /etc/debian_version
12.9

[hatkidchan]

Alright, I just had to upgrade Go (thanks, Debian!), and on a second attempt it all worked fine, thank you!