Playing with dynamically generated inline SVGs is a fun distraction, but I don't think I should be allowed anywhere near graphical design. Can't really say this is an improvement over the wall of numbers.

(CW: more suggestive images)

Show thread

I really ought to follow a course or two on statistics, I haven't a clue what I'm doing right now. :blobshrug:

My hobby: Writing 10+ variations of the same query to see what the PostgreSQL planner makes of it.

It's always fun to see completely different plans result in near-identical performance.

I prolly don't even need that USE="http", but too lazy to maintain another entry in package.use when this problem will likely solve itself given enough time. :blobshrug:

Show thread

subversion[http] depends on serf depends on scons[python2_7].

Another :gentoo: system not-quite-yet freed from Python 2.7.

Welp, was killed by podman overhead again.

I should stop being lazy with those weekly reboots.

So I actually just wrote a PostgreSQL extension in C.

And it actually works. :blobcatsurprised:

Show thread

I keep wanting to write a custom PostgreSQL base type. It'd be a pretty neat solution but I'm not sure the operational complexity is worth it.

Postgres in a development environment: "Hey, I know how to generate a good execution plan for this query!"

Same Postgres in production: "Uuuhm let's just do a full table scan." :blobcatfacepalm:

GnuPlot is great when you have the patience to figure out which magical incantations you need to get the graph you want, but it's bad for the quick "I have some data, make a good enough plot out of it" use case.

Unfortunately, I've yet to find an easier alternative. :blobcatoh:

Surprisingly appropriate way to end a hentai.

Graphviz is neat, but creating nice-looking graphs is still a challenge.

My latest attempt: dynamically generated relation graphs for producers:

Modfying an XML document using a streaming XML parser & formatter:
30 lines of code, 150ms.

A bunch of regexes:
6 lines, 5ms.

Ah, summer time.

That explains why the VNDB query database hasn't synchronized yet.

Current status: Just wasted 3 hours chasing some weird behaviour that turned out to be caused by an old bug in HTTP::Server::Simple. :blobcatdead:

Looks like the "DuckDuckGo HTML" search engine I installed in Firefox includes a region setting. Sigh.

Any alternatives?

Show thread

Is musl stable on :gentoo: yet?

Compiling glibc just takes soooo long. :blobcatnotlike:

Show more

A lonely little town in the wider world of the fediverse.