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 ooooh interesting!!! i am a mysql liker because postgres syntax confuses me (i know its faster but whatever) but i will look into this…

@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. 😅

@bender@twtxt.net oh yeah i remember that part of the docs lol! honestly yeah i think sqlite is fine for the number of users i have which is like, 5 including me, and active users is just… me, but if i were to have more active users i could always spin up a separate instance as jank as that is