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
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
@davidak@chaos.social "Preview"?
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
@kim I already gave it so many cores though :( I was having load averages of 40+!
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
@tailscale@hachyderm.io That policy seems quite likely to get Hachyderm defederated from other instances, tbh, if it mixes in corporate with personal accounts.
And my concerns about corporate accounts exceed "what I personally wish to see" - it's about their effects on the broader community, and precisely that dangerous area of "corporations that act like they're a community member but ultimately always act in their own best interest". This is precisely how eg. corporate capture of FOSS happened.
Sven Slootweg (soft-deprecated)
boosted
re: galactica nonsense
@ct_bergstrom (specifically, 1. it doesn't expand on the "not always", 2. static typing doesn't *always* require explicit declaration, inference also exists, and 3. from a research perspective it's highly debatable whether it's true at all - ie. exactly the kind of errors I would expect a neural net to make)
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.
galactica nonsense
@ct_bergstrom lmfao, so few lines and yet it manages to be wrong in multiple ways, none of which would be easily detectable to a typical reader...
- 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
