[jacqueline]

i moved us over to a real database engine. but the process was alarmingly manual. last time i tried a test post everything just broke!!! will it work this time?

[jacqueline]

fuck yeah!!!

[gkr]

MariaDB or postgresql now?

[jacqueline]

mariadb! i thought postgres was meant to be the cool one, but the group chat wisdom was that i would have an easier time with mariadb. i also thought that mariadb's 'seal' logo was the cuter of the two.

[emily]

Postgres is the cool one as long as someone else is doing admin for you.

If you must do your own admin, I recommend the Emily-approved Never Update Anything system.

[jacqueline]

i planned to never update, but it turns out mybb's usage of sqlite is really bad. the site kept throwing errors up whenever more than like 5 concurrent requests came in!

[emily]

see, you're just not nevering your updates enough

if you never update the db at all you can just cache all the pages as static html. new posts may be submitted via carrier pigeon

[buzzyrobin]

mariadb! i thought postgres was meant to be the cool one, but the group chat wisdom was that i would have an easier time with mariadb.

i insist my late objection be noted

If you must do your own admin, I recommend the Emily-approved Never Update Anything system.

i insist my agreement with this take be also noted

[gkr]

I don't find postgres admin that hard but I live in a shell.
May you never have to do admin again

[emily]

do they have in-place upgrades yet or is it still a painful "dump the entire database and load it into the new one" process

this is, of course, a non-issue if you Never Update Anything