Show newer

Frustration with cishet white men. Yes I know I'm yellibg into the void. 

Y'all need to learn a few key things, as a demographic.

1. Your good intentions don't matter for shit. Stop using "I didn't mean any harm" as an excuse for not taking responsibility for the effects of your choices.

2. Your ignorance has zero excuse. No, not even that excuse. Zero. It is not the job of everyone else on the planet to educate you. Shelve your sad little egos and put in some effort to learn under your own power. I know not having the universe handed to you for being you are feels scary and unfamiliar. I promise working on yourself won't kill you.

3. Your bubble of privilege gives you no right to invalidate the experiences of literally every other group of people on the planet. See also number 2. Not knowing something is part of being human. Willful ignorance is part of being a shitty person.

4. Quit whining when the rest of us have had enough of your childish bullshit and decide to dump your ass in the cold. Just because not all of us are fortunate enough to be able to escape from you doesn't mean anyone deserves to be subjected to you.

Sincerely,

~ Basically everyone else on Earth.

Babe, wake up, a new #JWST image just dropped.

Light from the protostar L1527 escapes above and below an edge-on protoplanetary disk (the dark line at the center of the image), creating an hourglass shape. This illuminates the cavities carved as ejected material from the star collides with the surrounding, dusty nebula.

Dust scatters shorter wavelengths of light, so blue areas are where the dust is thinner and orange areas are where the dust is more dense.

webbtelescope.org/contents/new

#astronomy

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.

Show thread

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."

arxiv.org/abs/2211.03622

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??

Show thread

So apparently removing the DISTINCT cuts the query time in half, but it's still very slow...

With DISTINCT: explain.depesz.com/s/cOeV
Without DISTINCT: explain.depesz.com/s/QAIM5

Show thread

pixie.town statistics:

:garfield: 42 users
:gnomed:​ one little gnome running through the internet pipes delivering all the toots

oh, actually only 4 minutes when the system isn't under load 🙃

Show thread

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...

Show thread

feeding my datasheet search engine database its favourite treat, a whole CPU core

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] github.com/hachyderm/community

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.

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
galactica.org/?prompt=wiki+art

Right: The actual wikipedia entry
en.wikipedia.org/wiki/Brandoli

Show thread

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.org

Show older
Pixietown

Small server part of the pixie.town infrastructure. Registration is closed.