Mina @meena@cathode.church

@dumpsterqueer yuuuuuupp.

@dumpsterqueer usually, i'd be offering myself up for this, because i hate being a DBA and i love SQLite, it's never failed me!

however, i hate writing go even more, and even if i didn't, i just started a new job, and I won't have childcare until the end of September, so time is not on my side

@dumpsterqueer it really is!

@dumpsterqueer oh, yeah

if you want ACL, you'd use another file (database), that gives you at least separation of concerns

if you have multiple processes, you can run those as different OS users, and then you can control access via Filesystem ACLs

@dumpsterqueer do you use PostgreSQL's native password encryption thing? rather than a go library?
maybe one that even makes it easy to roll a new cypher, if the current best suddenly goes out of fashion?, on account of being cracked

@christa i always harp on software needing to scale down, i usually mean this in a computer architecture sense, but it equally applies to that same software in service of (smol) communities

@baldur in my time as DevOps consultant I've regularly been in companies (insurances, and banks, mostly) with fleets of hundreds of admins, each responsible for one or two services, doing the same kind of work that I'm other companies was done by six people

so a lot of the willingness to automate, depends highly on the company culture

anyway, i personally don't think everybody needs to have a (bullshit) job

there's enough work that needs to be done, that will actually make us better and safer on this planet, rather than shortening our run

@baldur yeah, but this isn't due to ATMs, this is most likely due to Internet banking

@jalcine @siina does that federate somehow?

@tindall anyway, sorry for butting in with my half-knowledgeable.

i'm a total SQLite fangirl, cuz it means i can run a few things, reachable online! without having to be a DBA, or giving money to aws/GCP/Azure for somebody (or something there) to be my DBA.

n.b.: that does not mean I'm a fan of everything the SQLite lead developer does or says

@tindall usually, you'd do it, via, https://www.sqlite.org/appfunc.html from the "devouring application"

a phrase i just picked up from this, https://www.educba.com/sqlite-stored-procedures/
and now i really need to know which language this was translated from

@charlag @jalcine or for people who looked one too many times at the stop for pixelfed, and just can't get over actually attempting to install that thing

@tindall i mean what PostgreSQL extensions do you need for… X, that SQLite doesn't support yet?

@charlag @jalcine there's the glitch and hometown forks, but there's also gotosocial

and i think we should keep an eye on… all of these