Sven Slootweg (soft-deprecated) @joepie91@pixie.town
- Future new account
- @joepie91@slightly.tech
- Matrix
- @joepie91:pixie.town
- Pronouns
- they/them, he/him, whatever, it's not like I have any idea either 🙃
In the process of moving to @joepie91. This account will stay active for the foreseeable future! But please also follow the other one.
Technical debt collector and general hype-hater. Early 30s, non-binary, ND, poly, relationship anarchist, generally queer.
- No alt text (request) = no boost.
- Boosts OK for all boostable posts.
- DMs are open.
- Flirting welcome, but be explicit if you want something out of it!
- The devil doesn't need an advocate; no combative arguing in my mentions.
Sometimes horny on main (behind CW), very much into kink (bondage, freeuse, CNC, and other stuff), and believe it or not, very much a submissive bottom :p
My spoons are limited, so I may not always have the energy to respond to messages.
Strong views about abolishing oppression, hierarchy, agency, and self-governance - but I also trust people by default and give them room to grow, unless they give me reason not to. That all also applies to technology and how it's built.
Joined Aug 2019
Sven Slootweg (soft-deprecated)
boosted
LGTM is an ancient spell used to ward off bugs and edge-cases
Aha, forgot that UNION also does a uniqueness check. Changing it to UNION ALL fixed that.
Sven Slootweg (soft-deprecated)
boosted
This is... not entirely surprising
"Overall, we find that participants who had access to an AI assistant based on OpenAI's codex-davinci-002 model wrote significantly less secure code than those without access. Additionally, participants with access to an AI assistant were more likely to believe they wrote secure code than those without access to the AI assistant."
Sven Slootweg (soft-deprecated)
boosted
Anti-transmasculinity, transphobia, death, TERFs
On Aug 27 2022, a transgender activist named Malte C. was beaten to death for defending two lesbians against homophobic abuse. On cue, TERFs mocked him for dying and claimed that he would have been able to fight back had he been born male. The transandrophobia cult reflected the same sentiment. I won’t forget Malte’s sacrifice. What happened to him could have happened to anyone, but he is the one who chose to act. I think about this a lot.
Where on earth is this remaining sort operation coming from??
So apparently removing the DISTINCT cuts the query time in half, but it's still very slow...
With DISTINCT: https://explain.depesz.com/s/cOeV
Without DISTINCT: https://explain.depesz.com/s/QAIM5
Sven Slootweg (soft-deprecated)
boosted
pixie.town statistics:
42 users
one little gnome running through the internet pipes delivering all the toots
oh, actually only 4 minutes when the system isn't under load 🙃
now to wait for the 13 minute `EXPLAIN ANALYZE` query to complete
well crap, it knocked over the container and now I've lost three whole CPU cores...
feeding my datasheet search engine database its favourite treat, a whole CPU core
Sven Slootweg (soft-deprecated)
boosted
meta, hachyderm, corporate capture
Heads-up for any folks on hachyderm.io: I would recommend picking a different instance, as it seems likely that it'll get defederated from quite a few places at some point.
They seem to not only be happy with corporate accounts[1], but also apparently seek to "introduce trust with corporations" [and draw them to fedi?], which uhhhh yeah no.
This is a space for people, not for corporations. Let's not repeat the errors of the FOSS community (that eventually led to near-total corporate capture of FOSS) by inviting corporations into our spaces, not even "as long as they play nice".
[1] https://github.com/hachyderm/community/blob/main/accounts/corporate-accounts.md
Sven Slootweg (soft-deprecated)
boosted
Sven Slootweg (soft-deprecated)
boosted
Here's the kicker. It's not that Galactica picked the wrong law. It is that the Padua economist to whom Galactica attributes the law, Gianni Brandolini, DOES NOT EXIST.
Galactica's phrasing of the law itself? That does not exist either. No one has ever said that phrase online (rather a surprise, tbh).
Galactica doesn't let us "access and manipulate what we know about the universe." It generates *pure bullshit* — which, incidentally, will be orders of magnitude more difficult to clean up.
Sven Slootweg (soft-deprecated)
boosted
Let's take a look. Galactica can generate wikipedia articles, supposedly.
So let's see what they look like. Here's one for Brandolini's law, the principle that bullshit takes another of magnitude less effort create than to clean up.
Left: Galactica's attempt at creating a wikipedia entry
https://galactica.org/?prompt=wiki+article+on+brandolini%27s+law
Right: The actual wikipedia entry
https://en.wikipedia.org/wiki/Brandolini%27s_law
Sven Slootweg (soft-deprecated)
boosted
I've figured out what pisses me off so much about Facebook's Galactica demo.
It's not because people can use to to write bad essays for their homework. There are plenty of large language models that can do that. It's because Facebook is presenting it as something that it most definitely is not.
Facebook is selling it as a knowledge engine, a "new interface to access and manipulate what we know about the universe."
Actually it's just a random bullshit generator.
Sven Slootweg (soft-deprecated)
boosted
Please take a moment to drink in the 
absolute spectacle 
that is the Brands.town instance: https://brands.town/explore
Sven Slootweg (soft-deprecated)
boosted
TIL that Atari had an in-house FIG #Forth variant called Coin-Op Forth and that it has, in fact, leaked onto the internet, along with the manual. #retrogamedev
https://archive.org/details/AtariCoinOpFORTHAndSwarthmoreExtensions/page/n3/mode/2up
- Future new account
- @joepie91@slightly.tech
- Matrix
- @joepie91:pixie.town
- Pronouns
- they/them, he/him, whatever, it's not like I have any idea either 🙃
In the process of moving to @joepie91. This account will stay active for the foreseeable future! But please also follow the other one.
Technical debt collector and general hype-hater. Early 30s, non-binary, ND, poly, relationship anarchist, generally queer.
- No alt text (request) = no boost.
- Boosts OK for all boostable posts.
- DMs are open.
- Flirting welcome, but be explicit if you want something out of it!
- The devil doesn't need an advocate; no combative arguing in my mentions.
Sometimes horny on main (behind CW), very much into kink (bondage, freeuse, CNC, and other stuff), and believe it or not, very much a submissive bottom :p
My spoons are limited, so I may not always have the energy to respond to messages.
Strong views about abolishing oppression, hierarchy, agency, and self-governance - but I also trust people by default and give them room to grow, unless they give me reason not to. That all also applies to technology and how it's built.
Joined Aug 2019
