I was trying to optimize the SQL query used for the Compact FrontPage (anonymous view for Discovery when the Admin/Operator chooses “one twt per feed”).

Test

“O Governo Federal continua se enroscando mais e mais no WhatsApp.” :((

https://manualdousuario.net/whatsapp-anatel-celular-seguro/

@prologic@twtxt.net yes

@thecanine@twtxt.net Did you see my revelation earlier today? 🤔

@movq@www.uninformativ.de Pretty cool song I agree ☝️

@lyse@lyse.isobeef.org Just needed to update the version of the tool I packaged as an OCI image 🤣

AI problems, top to bottom:

1: Open AI nerds, believe fine tuning a language model algorithm, will eventually produce an AGI god.

2: Subpar artists and techbros who can’t code, convinced AI image bashing and vibe coding, will help convince the dumber parts of Internet, they are a real deal.

3: Parasites, using AI to scam people, because they just want passive income, selling crap, made by an automated process.

Side: Adobe&co, killing Flash/old web, pricing new artists and developers out, to face learning curves of free tools, or use AI, peddled as solution.

@lyse@lyse.isobeef.org Beep boop! That was nice 😃

This 8 bit trip is really cool! https://www.youtube.com/watch?v=pCm1fKZGvl47

@prologic@twtxt.net So, this flag isn’t doing exactly what you thought it does? Or is there a bug in the implementation itself?

@prologic@twtxt.net Ta! :-)

Add support for skipping backup if data is unchagned · 0cf9514e9e - backup-docker-volumes - Mills 👈 I just discovered today, when running backups, that this commit is why my backups stopped working for the last 4 months. It wasn’t that I was forgetting to do them every month, I broke the fucking tool 🤣 Fuck 🤦‍♂️

There are now two (recentish) quotes I really like these days:

The smartest person in the room is not the one with all the answers—it’s the one who’s brave enough to ask the dumb questions

and

The kindest person in the room is often the smartest

Full: Singapore PM’s Reality Check To Trump Amid Tariff War In Parliament: ‘Just The Beginning Of…’ - YouTube @bender@twtxt.net

Haha 😆

@prologic@twtxt.net this is bananas! Replies are precious, don’t waste them!

@prologic@twtxt.net woot, finally! 🥳🥳🥳

@prologic@twtxt.net I didn’t. Share a link? I would love to watch it!

“Encode #spatial data as #topology in #Python!

With #topojson it is possible to reduce the size of your spatial data. Mostly by orders of magnitude.”

https://mattijn.github.io/topojson/

#geopython #geospacial #GIS #computationalGeometry

Based on a recent study of the brains of mice I estimated the human brain to have 200B cells/neurons and 50,000T connections. We have several orders of magnitude to go before we reach that kind of scale with these fucking stupid Big LLMs 🤣 And the best part of all? 🧐 It is estimated that the human brain only consumes the equivalent of 5 Watts of power !!! 🤣🤣🤣

@bender@twtxt.net You will be pleased to know that yarnd now only consumes ~60-80MB of memory depending on load 🤣 And bugger all CPU 😅

And one more.

Reply?

Hmmm? Test?

@lyse@lyse.isobeef.org Nice sunset 😎

@bender@twtxt.net Did you see the Singaporian president’s speech on this whole nonsense?! 😂 (trade wards, tariffs, free markets, etc)

@bender@twtxt.net @ionores@twtxt.net Yep, it’s extremely seldom that a photo turns out looking better than reality. Very rarely does that happen. But basically never with sunsets. ;-) Maybe once a leap year I’m very surprised to wonder how that subject wasn’t better in person but actually on film.

@bender@twtxt.net Totally agree with you 100%. No photo could ever replace the experience of seeing it live on site!

I once saw a paper, then lost it, I wish I could find it again, that had kind of a satirical tone, it was about teaching and went something like “how to be liked by your students without teaching much”

I have nightmares about this. I hope my students like my classes and also learn stuff, but I’m really never sure. Some like the classes, some learn stuff, but, am I optimizing for them liking the classes while learning less?

“Critiquing #Computing Artifacts through Programming Satirical #Python Scripts” https://arxiv.org/html/2312.03090v1

Image

@lyse@lyse.isobeef.org now, that’s what I am talking about! Having been witness of similar sunsets, I would wholeheartedly agree that a photo (no matter how good!) is a poor replacement for not being able to spectate it in person.

“Optimists have more fun, but do
they learn better? On the influence
of emotional and social factors on
learning introductory computer science”

https://cs.au.dk/~mec/publications/journal/22–optimists.pdf

”…we found no correlation between
emotional health and social well-being on the one hand and success in computer science as indicated by course grades on the other”

:-S

@bender@twtxt.net Just like you, I change the wallpaper on my PC more often! However, @prologic@twtxt.net’s “Lake View” photo is perfect for my laptop, where I spend quite a bit of time.

A mate and I met at the scout yard to prepare an upcoming workshop. Boy did we have an amazing sunset when we left. The photos don’t reflect it, it was a hell lot more beautiful in person: https://lyse.isobeef.org/plaetzle-2025-04-11/

Image

MONO Live on #KEXP

https://yewtu.be/watch?v=1h5Ky5cBwA8

#music #invidious

@ionores@twtxt.net that ought to be some photo! I change mine at least once a month or so. It keeps me entertained.

@movq@www.uninformativ.de I still have a photo taken by @prologic@twtxt.net as wallpaper on my laptop (Linux)! 😀

ABC Australia is reporting of a potential market manipulation in the US. Potential? I would call it almost certain. For as much as I would like not to be dragged into politics, it is rather impossible these days.

@anth@a.9srv.net Hahaha, for a second I thought that you implemented word splitting according to Swiss (.ch) rules. :-D

Btw, both manpage links string(2) and getields(2) (it’s missing an f) point into nothingness: http://a.9srv.net/src/wordwrap.2.html

I can’t help but notice line 9: http://a.9srv.net/src/wordwrap.c

And I reckon your finger slipped one key to the right for quore: http://a.9srv.net/src/litclock.1.html

Cool stuff! :-)

Trying unsucessfully to reproduce this #leafmap example :(

https://leafmap.org/maplibre/globe_control/#import-library

https://www.youtube.com/watch?v=D2bdwLkU1KQ

UPDATE: Different computer… different result…

#Python #geopython #geospacial

Image

@bender@twtxt.net Fair enough 🧐

@bender@twtxt.net Technically no but we’ll talk more about this 👌

Yup, it is certainly something on the codebase here. /end of test

@bender@twtxt.neteapl.me let’s see how this mention comes out. I noticed that @kat@yarn.girlonthemoon.xyz’s pod doesn’t have this problem. That is, their mention to you works fine.

@prologic@twtxt.net so, the twtxt is “lost”? Don’t rush to reply, I think you deserve your sleep time! Have a nice weekend!

@prologic@twtxt.net in this case it isn’t vendor lock-in. I believe they do it because the carrier “eats” the costs (the interest part of the instalments). The phones are fully unlocked.

I will return the two we got for parents, and re-buy them again, this time on an instalment plan. Why pay $2,000 up front when you can split the cost in convenient monthly payments, all interest free, right?

@bender@twtxt.net No insertion.

@prologic@twtxt.net interesting. What would happen on a hash collision? 🤔

@bender@twtxt.net It’s a bug in the UI for sure. The hash is the primary key.

@prologic@twtxt.net is it twice on database, or simply rendering twice? If you manually expunge it, will it affect the yarn?

@bender@twtxt.net No, haven’t figured out the reproducer yet 🧐

@prologic@twtxt.net yay! One down! 😅 Have you figured out the single duplication issue?

@bender@twtxt.net I hate vendor lock-in too 🤣

Ordering issue is fixed 🥳

#Wilco #music #invidious
Impossible Germany
https://inv.nadeko.net/watch?v=Epbu2z3o28w

@aelaraji@aelaraji.com YAYYYYYYYY

@eapl.me@eapl.me YEAHHH THEY’RE SO CUTE i got them here! https://github.com/charmbracelet/confettysh

@bender@twtxt.net @movq@www.uninformativ.de Thanks! I’ll think about switching to higher resolution teasers in the future. The reasoning behind the thumbnails is to avoid wasting traffic. Maybe folks in the outback or on expensive mobile networks appreciate it. Yeah, they could disable images in general.

That’s a dang cool story from Apollo 11 where priority queues saved the day: https://www.nasa.gov/history/alsj/a11/a11.1201-fm.html

LOL, and the mention to the @bender@twtxt.netyarn_police@twtxt.net police broke!

I think this is a case for… (blow trumpets) “The @bender@twtxt.netyarn_police@twtxt.net”!

@lyse@lyse.isobeef.org 01.jpg could have been a Windows wallpaper. 😃

Hmm, Yarnd is duplicating the rendering of /twt/5jlfuua. That’s quite odd.

@lyse@lyse.isobeef.org Well, yeah, that’s quite similar, isn’t it 😂

@lyse@lyse.isobeef.org that’s such a beautiful shot! If I were you I would use the full “original” one; it will do better justice to the shots. Oh, and I gladly take your 15°C! 😍

Hit by the arvo sun rays behind the window I was convinced that it is t-shirt weather. Deep blue sky, yeah, for sure! It turned out to be just 15°C and declining, though. So, I had to wear my jacket on today’s windy stroll. Pretty nice. Didn’t take many photos, but there you go: https://lyse.isobeef.org/waldspaziergang-2025-04-10/

Image

@movq@www.uninformativ.de Holy crap, that’s really crazy!

Hahaha, you got me. When I read your first sentence I thought you were going to tell about your Wayland experience in comparison to X11. :-D

@movq@www.uninformativ.de @ionores@twtxt.net Thank you! Nope, still a petting farm over here. The only dangerous (to humans) animals are boars and ticks. But I only ever encountered a wild hog once in my entire life so far. Luckily, it took off and didn’t attack me. Ticks, on the other hand, regularly attack me.

One was able to purchase iPhones on instalments (and interest free), whether they were associated with a carrier, or not. The only way to buy them on instalments now is if the are associated with a carrier; otherwise one gets charged the full amount up front.

So, yeah, going to return a couple of those this weekend.

@aelaraji@aelaraji.com oh yeah! You will feel in heaven, me thinks, because that new machine will go around the Pi a few laps. Have fun, mate!

@bender@twtxt.net just the hobbyist server wannabe thingy … kind of a drop-in replacement to the rpi but with a bit of more horse power than the latter. 🤞

you got me 😜, it was like a few Internet centuries ago

@bender@twtxt.neteapl.me@eapl.me test

@bender@twtxt.neteapl.me@eapl.me just testing this mention, to see which random nick will be picked. Related, I agree, those animations are truly awesome!

@prologic@twtxt.net sounds like a plan! No worries at all.

@bender@twtxt.net Let’s just optimize/fix those annoyances later on once I’ve finished pagination. Then I’ll merge this branch into main.

@bender@twtxt.net Same size they always were.

@prologic@twtxt.net, is it my idea, or the size of avatars have gotten smaller?

@prologic@twtxt.net me neither! Let’s put it on the “Greatest Mysteries of Yarn” list, and move on. 😅

@bender@twtxt.net Hmmm I can’t figure out how you did this 🤣

Or like this?

Like this? In the post box at the bottom?

@prologic@twtxt.net nope, I simply replied to the yarn, without mentioning anyone in specific.

@bender@twtxt.net Did you mean to mention me? 🧐

@prologic@twtxt.net sweet! Is it going to be your new all-around desktop, or the hobbyist server, or all of the above?

@aelaraji@aelaraji.com Cool! 😎

@bender@twtxt.neteapl.me@eapl.me A few years ago or decades ago? 🤣

The new toy has arrived and is ready to be cleansed of it’s pre-installed Win 10 pro (yuck!) …

Image

@bender@twtxt.net Well done 👍

I believe the bug has been fixed 🥳

@abucci@anthony.buc.ci Apologies, the basic summary is as follows:

• Decided to rewrite the cache backend.
  
• It will now be a SQLite backend going forward.
  
• I’m planning on no data migration.

Nice! Otherwise, still no presence of large predators in your area?

the Fireworks and Confetti animations are amazing. It reminds me a lot of my first code on QBasic a few years ago.

Finally lawn is mowed—well, the one at the front, the wild forest in the back will have to wait a bit longer. I haven’t clocked my 10,000 steps today, but what I didn’t walking, I did through full body “exercise”. Will call it a day. 😅

@movq@www.uninformativ.de no no it’s ok i say it because it’s true also it’s funny to me hahah! don’t be sorry

@kat@yarn.girlonthemoon.xyz Ouch. 🥴 Alright, that’s not so great then, sorry. 🫣🥴

@movq@www.uninformativ.de i’m usually depressed so when i’m doing stuff like this i guarantee it’s fueled by coffee and adderall lmao

@bender@twtxt.net (Feels a bit like his “edit” function could be implemented as “delete and re-draft”, but I’m only guessing here.)

@lyse@lyse.isobeef.org Nice. I should catch up. Only walked 8km this month, so far. Oops.