kim (she/her)

we have more performance issues developing gotosocial with postgres than with sqlite. if we supported multinode deployments or horizontal scaling such that sqlite’s concurrency got harder to reason-about I’m sure postgres would shine, but for a single process sqlite has been generally much faster and it hasn’t required anywhere near as much prompting to get the query planner to behave as required.

i also think when people assume sqlite is better for simpler applications, they think smaller. but no, for the same 25+GB databases sqlite has mopped the floor with performance.

single-process multi-threaded sqlite is fantastic.

what’s your setup for this out of interest? are you running a Dev environment under tmux or something? 🤔

I disagree, the judge declared the sentence time hinged on the girl being the ringleader of the two and specifically targeting the victim (at least partially) out of transphobia. it was only the cops that said it wasn’t related to transphobia, and frankly the cops in this country have a shite reputation for being transphobic themselves so chances they’d look over that are high.

news aside, dear lord there are some serious american imperialism shills in this thread

damn, your mom was quite prophetic

* America poses the biggest danger to the world in 2024