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

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)

looking more and more like I'll be making an alt on another instance then... :p

man "leaked private messages" is such a weak fucking excuse in the face of transphobia. @nutomic@lemmy.ml you realize you're just alienating a huge fucking number of comrades? not just trans people, but all those that rightfully stand with us too.

edit: nutomic you absolutely can come back from this if you don't double down. accept your shit, and work on it. and you know what that would be great to see, there's not enough of that in the world.

if not then @dessalines@lemmy.ml and other core devs, i think you have a tough decision to make. i absolutely do not envy you. though do keep in mind that handling this correctly will solidify even tighter community support behind the Lemmy project.

we need more good comrades behind ActivityPub development :p

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

* America poses the biggest danger to the world in 2024

fucking please let this be it. we need this win

is it just me or have these past few weeks just been one after another of announcements claiming people have given up on climate change? what gives?

Voyager (now as native app) 👨‍🍳😙👌