@lyse@lyse.isobeef.org Yes, and that’s why I’m 100% convinced that we’ll see a massive brain drain in a couple of years. This will affect young people even more, because they don’t have all the “old” knowledge to fall back on.

It’s concerning, I’ve warned about it many times, nobody listens.

I think the best thing one can do is explicitly not use any AI tools but keep your actual skills intact. Might be out of a (good) job for a while, but once this bubble bursts, this is who is going to get hired again. (I think.)

And considering how insanely expensive all this is, I’m still (mostly) convinced that the bubble will actually burst. This stuff just isn’t sustainable.

… or I might be wrong. And if so, I see an even darker future that I don’t want to put into words right now.

@xuu@txt.sour.is, what’s going on with y’all up in the mountains? The mouse has been mighty quiet for a while!

@movq@www.uninformativ.de “out of morbid curiosity” LOL. That draw a laugh out of me, so easily! 🤭

@movq@www.uninformativ.de Yup, I’ve also seen the floating point conversion happening with (1 << 63) - 1 yesterday night. But instead of pausing to think about it for a second, somehow all I had in mind was “give me a better representation, ain’t gonna have time for this shit”, so I turned it to hex. Beyond my comprehension what I was thinking there. O_o That’s embarrassing, unbelievable. Well, I blame late o’clock where my brain had already quit on me and went to bed.

Very interesting data point you raise there. The fun part didn’t cross my mind yet or at least I couldn’t pinpoint it. In hindsight it’s totally obvious, though. Past experience also tells me the exact same. Dealing with a problem and researching something myself is a so much more better teacher. The longer I faced up with a topic, the higher the chance to really manifest in long- or at least mid-term memory. If I just get told something, the odds are that it’s completely erased from memory in a matter of days if not hours.

@lyse@lyse.isobeef.org AI result ahead, feel free to ignore.

I “asked” the AI at work the same question out of morbid curiousity. It “said” that SQLite converts that integer to floating point internally on overflows and then, when converting back, the x86 instruction cvttsd2si will turn it into 0x8000000000000000, even if the actual floating point value is outside of that range. So, yes, it allegedly actually saturates, as a side effect of the type conversion.

I couldn’t find anything about that automatic conversion in SQLite’s manual, yet, but an experiment looks like it might be true:

sqlite> select typeof(1 << 63);
╭─────────────────╮
│ typeof(1 << 63) │
╞═════════════════╡
│ integer         │
╰─────────────────╯

sqlite> select typeof((1 << 63) - 1);
╭──────────────────────╮
│ typeof((1 << 63) ... │
╞══════════════════════╡
│ real                 │
╰──────────────────────╯

As for cvttsd2si, this source confirms the handling of 0x8000000000000000 on range errors: https://www.felixcloutier.com/x86/cvttsd2si

The following C program also confirms it (run through gdb to see cvttsd2si in action):

<a href="https://yarn.girlonthemoon.xyz/search?q=%23include">#include</a> <stdint.h>
<a href="https://yarn.girlonthemoon.xyz/search?q=%23include">#include</a> <stdio.h>

int
main()
{
    int64_t i;
    double d;

    /* -3000 instead of -1, because `double` can’t represent a
     * difference of -1 at this scale. */
    d = -9223372036854775808.0 - 3000;

    i = d;
    printf("%lf, 0x%lx, %ld\n", d, i, i);

    return 0;
}

(Remark about AI usage: Fine, I got an answer and maybe it’s even correct. But doing this completely ruined it for me. It would have been much more satisfying to figure this out myself. I actually suspected some floating point stuff going on here, but instead of verifying this myself I reached for the unethical tool and denied myself a little bit of fun at the weekend. Won’t do that again.)

@movq@www.uninformativ.de Now, it’s official, I AM an idiot. Yeah, thank you, that’s it! Apparently, I’ve quickly unlearned to use my brain with great success. :-(

@lyse@lyse.isobeef.org

Disclaimer: Can’t guarantee that I’m fully awake and I’m being trained at work not to use my brain anymore, so maybe this is complete bullshit. 😪🧟‍♀️

It says here that SQLite uses signed integers:

https://sqlite.org/datatype3.html

In pure bits, 1 << 63 would be 0x8000000000000000, but as a signed value, it gets interpreted as -9223372036854775808. Subtracting 1 yields -9223372036854775809 – but that doesn’t fit in 64 bits anymore. It’s possible that SQLite doesn’t want to wrap around but instead saturates? Haven’t checked. 🤔

With 62 bits, there is enough room.

With 1 << 64, I have no idea how SQLite wants to handle this, because this should immediately trigger a warning, because it doesn’t fit right away. Maybe it gets truncated to 0?

sqlite> select printf('0x%x', 2 * (1 << 64));
╭──────────────────────╮
│ printf('0x%x', 2 ... │
╞══════════════════════╡
│ 0x0                  │
╰──────────────────────╯
sqlite> select printf('0x%x', 0 - 1);
╭──────────────────────╮
│ printf('0x%x', 0 ... │
╞══════════════════════╡
│ 0xffffffffffffffff   │
╰──────────────────────╯
sqlite> select printf('0x%x', 0 - 2);
╭──────────────────────╮
│ printf('0x%x', 0 ... │
╞══════════════════════╡
│ 0xfffffffffffffffe   │
╰──────────────────────╯

@lyse@lyse.isobeef.org I don’t axtually k ow what the incline was we went up! Haha 😅 Honestly just guessing hmm must be documented somewhere 🧐

@prologic@twtxt.net Awwwwwwww! I love these stripes, very cool!

Oh, I bet these inclines are no joke. I also know one about 200 meters long terribly steep dirt path up a hill around here. Climbing that is super exhausting. I just looked it up on a map. And it’s just ~17° or ~30% incline. Okay, that’s absolutely nothing compared to your adventure. :-D

But you got your exercises for the day then. Which will make for an even greater sleep tonight. ;-)

@prologic@twtxt.net Oh, so that’s where you are! 😅 Great scenery. Enjoy!

@itsericwoodward@itsericwoodward.com yeah, it is mostly a curiosity and not something one will do often. I first came across it a while ago, checked it for a few seconds, and moved on. :-D

@bender@twtxt.net Ah, great, thanks!

@lyse@lyse.isobeef.org Thanks! Hers a few more!

@itsericwoordward@itsericwoodward.com Haha, that’s a nice one. I was alone, too.

@bender@twtxt.net Hahaha! :-D

Thank you, @prologic@twtxt.net, that looks really stunning! Seeing forests reaching beyond the horizon always amazes me. This does not exist around here. I also like those balancing rocks.

Keep ‘em coming. Looking forward to see more. But most importantly, enjoy your trip, mate! :-)

@kiwu@twtxt.net Oh, they absolutely do! There were waterfalls coming out of my nose. Luckily, it got much better over time. So, there might be chances for you, too.

TIL that SSH actually stands for Secure Snake Home, a massively multiplayer snake game playable via the SSH protocol: ssh snakes.run

Of course, no one else was online when I was playing, so…

https://itsericwoodward.com/images/047d28bb8c1ce8970ad2af0276cd3be58915a3cc69eb83c76f4a33954a9b623c.png

Just a couple of shots from our trip to Bald Rock—finally got reception so I can share them!

@lyse@lyse.isobeef.org 🥰🥰🥰🥰

@movq@www.uninformativ.de never too late! Drop that bass, and start training future astronaut!

Again, Azabache paid me a visit this evening. But also two sparrows and greenfinches in the arvo. Hitting record was just perfectly on time.

https://lyse.isobeef.org/sperling-gruenfink-amsel-2026-04-09/

@movq@www.uninformativ.de it is from here: https://www.flickr.com/photos/nasa2explore/, specifically: https://www.flickr.com/photos/nasa2explore/55187293546/in/dateposted/

@lyse@lyse.isobeef.org Yeah, I really don’t know anymore. 😅

By the way, why do so many of them wear glasses? As a kid, I’ve been told that people with glasses can’t become astronauts. So I gave up my dreams. Now it looks like that was a lie? ☹️

@bender@twtxt.net Good choices, thanks! ;-)

@movq@www.uninformativ.de Hahaha, nice. :-) I first thought, that this maybe comes from https://www.nasa.gov/gallery/lunar-flyby/, but it’s actually from another gallery.

Christina Koch looking at Earth is my new wallpaper:

https://movq.de/desktop/2026%2D04%2D09%2D%2Dkatriawm%2Dartemis2.jpg

https://movq.de/v/0ebc43df8c/artemis2-2026-christina-koch-looking-at-earth.webp (Sorry, forgot where I originally found the image. Some NASA photo collection.)

@lyse@lyse.isobeef.org 1, 3, and 22 are my picks on this very reduced set. Our bird is King/Queen, and that stop on the roof is their spot! 🥰

I called it quits a bit earlier and enjoyed the sunny 19°C blue sky in nature. I just sat an entire hour on a bench (12) near a habitat (07) and enjoyed the sun rays and singing birds around me. When I returned, the batteries were almost drained. The sunset finished them off, so that I could not record Azabache’s concert shortly after. However, I saw that amazing bird this morning and got him on film. Enjoy!

https://lyse.isobeef.org/waldspaziergang-2026-04-08/

@kiwu@twtxt.net ahh, I see, and now understand. My niece was homeschooled, and her breaks were always puzzling, but she had to adapt to my sister’s schedule. LOL.

@lyse@lyse.isobeef.org It’s impossible to avoid. Gotta wait a few years and then we’ll see. 🍵

@kiwu@twtxt.net that ought to be a super late spring break, wow! 🤯

@lyse@lyse.isobeef.org so adorable! Thank you for the video, I downloaded it. Azabache’s life is seemingly so pleasant, and the sing song, oh my! 🎶😍

I remembered to put the camera on my tripod. The neighbors yelling around messed up the audio a bit, though. I kinda saved most parts, but it could have been still better. When I was filming Azabache, a bluetit wanted to return to its nest somewhere next to me, I assume. It was shouting extremely loudly and immediately took off again to land on another roof ridge. It’s the one in 24. I had to turn down the volume in the audio. :-D

https://lyse.isobeef.org/waldspaziergang-2026-04-07/

Via https://github.com/newsboat/newsboat/issues/3220#issuecomment-4198066671 I came across this nice selection on why not to use AI: https://github.com/Vxrpenter/AIMania/blob/main/WHY.md#why

This then lead me to the slopware list: https://codeberg.org/small-hack/open-slopware

Holy shit, there’s even more than I thought. :-O In addition to Vim, the following affects me more or less daily (but hopefully not my ancient versions): curl, VLC, ImageMagick, rsync, Python, systemd and even the Linux Kernel itself. Oh fuck me dead. :‘-(

@lyse@lyse.isobeef.org beautiful! That’s what I would call a happy bird. I can imagine the sound, the sing song, in the air!

@firekeeper@b0nfire.xyz That looks nice! With all the things popping up in spring, the scenery turns even prettier. :-)

@bender@twtxt.net Hahaha!

The time has come again: https://lyse.isobeef.org/abendhimmel-2026-04-06/ Only five minutes earlier, and Azabache’s backdrop would have been blood red. But the violet isn’t terrible, I take it. Didn’t think of the video, though. I’ll try my luck tomorrow.

This about sums it up.

https://movq.de/v/7dbc8aa6e0/outlook.png

Source: https://mastodon.online/@astro_jcm/116358684548644607

@kiwu@twtxt.net what in the world?! Where? Long gone here (US).

@lyse@lyse.isobeef.org easy come, easy go. They grow so fast! :-) Also, Azabache allows to be seeing when ready for it, you know, just like Gandalf “*a wizard is never late, nor is he early, he arrives precisely when he means to*”. :-D

@kiwu@twtxt.net meh, wish I could say I had a great day. What is worse, tomorrow is back at work again. There isn’t a single day I think: did we evolved, and when through all those troubles, to end up like this?!

@movq@www.uninformativ.de LOL. Thank you!

@bender@twtxt.net Haven’t seen Azabache yesterday. But I was probably not checking enough at the correct times.

The problem is, they jump hosts all the time.

https://movq.de/v/f967b8cfb0/s.png

Maybe it’s time to add automated blocking after all … God, I’m too lazy for that. 😞

@bender@twtxt.net 🤔

https://movq.de/v/0d105a2a47/s.png

https://movq.de/v/374becda65/s.png

I’m so sorry. 🙈

@lyse@lyse.isobeef.org wow, quite a few good ones today! One thing about our friend, they are very, very consistent.

I just finished mowing the lawn, taking the trash out, and doing the dishes. Now tired, boss, dog tired.

@movq@www.uninformativ.de Yeah. Unfortunately. :-( I tried to bring up the subject of dependency upgrade reviews a few times, but nobody else cared. We finally experienced a supply chain attack (luckily, didn’t turn out too horrible for us, could have been worse) and this got the discussion slowly rolling again. So, publication of this article is perfect timing. Let’s see. Admittedly, I don’t have high hopes. And I bet someone suggests to use AI agents…

Thank you, @bender@twtxt.net!

My mate and I took advantage of the public holiday and went on a hike. At first, the 14°C and only slight wind weren’t all that terrible, especially since there were only a few clouds. Later, the sun got covered more and more and also the wind picked up. I was really glad that I brought my jacket along. In the beginning I was contemplating about leaving it at home, but then still wore it and stripped it a few minutes into the trip. It was very windy at the summit, so for our second lunch break wearing it was an absolute must. It was a very beautiful trip and I enjoyed my mate’s company.

Finally, Azabache showed up, too. I didn’t bother videoing with all the wind. Didn’t feel like fixing the audio. Maybe tomorrow.

https://lyse.isobeef.org/waldspaziergang-2026-04-03/

@lyse@lyse.isobeef.org the lone, defiant ranger, err, Azabache. I love this one!