[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

[jacqueline]

i dumped the sqlite database, manually edited the resulting file to replace sqlite-isms with mysql-isms, then imported it. then just pointed mybb at the new database.

[emily]

I mean postgres. postgres has a very painful process for upgrading from postgres to newer postgres

[jacqueline]

oh sorry i didn't realise that's what you meant it's very surprisingly to me that you would ever upgrade anything to a newer version

[br_en_d_an_]

Seems to be working now! Can't wait for the next update!

[jacqueline]

There was also an encoding issue that prevented emojis from being posted. If I fixed it, then this post containing '😅' will be successful.

[jacqueline]

poggers

[br_en_d_an_]

poggers

had to look this one up