gruf

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.

i know of someone that used to work there and Lush through-and-through are as lib as they come, and treat their workers like shit due to shite C-suite members

this is cool as hell

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

i think the DPRK is the only on that list i don't hold positive opinions about, or really any at all. everything i "know" on it is typical western propaganda so i try to keep my opinions open

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

i can understand being dubious of WhatsApp given it's closed source and owned by Facebook. but Telegram and WeChat? Both closed source and with very questionable encryption? Signal is the only clear answer.

also side-note, WhatsApp audits and analyses have all come back confirming it's at least deploying the same end-to-end encryption as Signal, though stores a bit more metadata. so Facebook knows when / who you're messaging. Telegram / WeChat are much worse in this regard. as an anti western imperialist i'd still choose WhatsApp over Telegram / WeChat for comms. though ideally none of the above for anything important

oh i had no idea about this, yikes. and you're absolutely right re: mastodon

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

china is at least giving me hope on the climate change front