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 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!
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
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)
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
are you sure the volume the sqlite database file is in has the correct permissions? not just in the container, but on the host, does the appropriate docker user id have permission to see what's in the folder? i've been caught out myself on that before when files in the folder had correct permissions, but the containing folder for them couldn't be accessed :p
💯
also it's not worth doing outside of much larger scale projects otherwise the admin work will just swamp any actual development time, imo
i'm not against better governance models, but the biggest problem in open-source right now isn't control (imo), it's unpaid labour.
it's almost like a full marketing slide deck was conveniently handed to someone 🧐
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)
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
are you sure the volume the sqlite database file is in has the correct permissions? not just in the container, but on the host, does the appropriate docker user id have permission to see what's in the folder? i've been caught out myself on that before when files in the folder had correct permissions, but the containing folder for them couldn't be accessed :p
of course, we must keep supplying the source of their misery, how else can we then help them out of their misery?
what's your setup for this out of interest? are you running a Dev environment under tmux or something? 🤔
and that's bad why?