i’m pretty sure i’m running this all off sqlite so if i get too many users on here i might be cooked but oh well i can always try to migrate (<– has heard migrations from sqlite to mysql/postgres are hell)

@kat@yarn.girlonthemoon.xyz I think it is kind of impossible to switch from sqlite to Postgres. I have run GtS on sqlite from get go, no issues. Granted, single user instance, but still…

@kat@yarn.girlonthemoon.xyz @bender@twtxt.net We’ve used pgloader at work to migrate an old legacy application from MySQL to PostgreSQL. Their website says it also works with SQLite. 🤔

@movq@www.uninformativ.de I was referring to their documentation advice, mostly:

“GoToSocial supports both SQLite and Postgres as database drivers. Though it is possible in theory to swap your database from SQLite to Postgres or vice versa, we do not currently have tooling to support this, so you should consider your choice of database carefully when starting out.

SQLite is the default driver and it’s been shown to work brilliantly for instances in the range of 1-30 users (or maybe more).”

Though my use of words wasn’t the best, I would agree. It certainly is possible. 😅