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.

man these AI fanatics are cringe

this is so insufferable i'm not sure i believe they're real

why on earth do font pack upgrades need to be part of full system updates.

i do not know where you get that impression. antisemitism, conspiracy theories and general racism are soooo common if you just browse one of the public feeds on primal, ditto etc. not to mention like 1 in 5 posts are just bitcoin posting.

we do have instances of fascist chuds on ActivityPub, but they're at least a little less easy to run into if you go to our equivalent of a public firehose like mastodon.social.

i will say there's parts of the nostr protocol i prefer over ActivtyPub, but you'll never catch me anywhere near that nazi bar

we made some recent changes to our S3 storage driver in v0.20.2, please do let us know how you get on with it and if there's anything more we can do to help!

gugal being a bit frugal with their releases

the funny thing is we've had that CoC for literally years https://codeberg.org/superseriousbusiness/gotosocial/pulls/2090

it only kicked-off as we kicked a user off our repo for trying to submit LLM-generated code, prompting the icecubes client dev to throw a shit-fit over it.

applications run under Termux will have direct access to the phone (though heavily locked down). the Linux terminal being introduced to android runs in a VM which is more secure, but which comes with a certain level of performance overhead

so this is a warning for the warning he's about to make

yeah i've had my eye on hexbear for a while. if Lemmy weren't so resource intensive i'd run a personal instance myself, but looks like hexbear is probably where i'll end up (assuming they accept me :p)