@gilbert189

this week’s database system practice post test: making the most spaghetti SQL queries:

-- no intersect =(
select distinct (
    select name
    from Lecturers
    where id=C1.lecturer_id
    limit 1
) as name
from Courses as C1
where
    exists(
        select 1
        from Courses as C2
        where
            C2.lecturer_id=C1.lecturer_id
            and C2.semester='Odd'
    )
    and exists(
        select 1
        from Courses as C2
        where
            C2.lecturer_id=C1.lecturer_id
            and C2.semester='Even'
    )
;

(we’re learning set operations and subqueries, so joins are not allowed)

I wonder what the huebird is doing right now after the ban

import operator as op
from functools import partial, reduce

@partial(reduce, op.add)
@op.call
def iterated():
    global ...
    ...

I feel like I’ve acquired some forbidden Python tech

So I drew some Baba is You characters on one of my uni’s lounge room yesterday

Seems like others have joined in

I just hinted Luddites without knowing it

I’m struggling to find a “simple website” for me to do PageRank on (as asked by the problem on my graph algorithm assignment) so I used the 2024 scrape of wasteof I made

I can say that the post with the highest PageRank is https://wasteof.money/posts/62739c27764628df27898724 with a PageRank of 0.015250907165356174… and it’s engagement bait. Greeeat.

some context for my previous post:

I smuggled Jack (my other laptop) to my boarding house so I can set up dual PC recording (after getting a subpar recording of my playthrough of the secret level in beatblock). I don’t have a capture card, but I can connect Jack and John through Ethernet, so my cunning plan is I would have John stream the screen using FFmpeg (since x11grab is cheap, or at least cheaper than encoding), and have Jack encode it to its hard drive.

Ideally I would just stream the raw video to Jack, but the Ethernet adapter I bought for John is only fast (100 Mbps), and I would need at least a 1 Gbps connection to stream raw video (and that’s with 8-bit color, if I want 24-bit that would raise it to 2.5 Gbps). Even if I got that sorted, I still have to put it on some container, and finding the right one is tricky (which is why I posted that post)

• With Matroska, I’m getting EBML header parsing failed; this seems to be a common problem with corrupted Matroska streams, which makes sense for a video stream that starts whenever John is transmitting right now.

• With NUT, the receiving end hangs, waiting for a “main startcode”, which I think is the NUT terminology of the ultimate file header.

• I could use MPEG-TS, but not all codecs are supported by that container. FFmpeg does still stream them as data streams, but good luck telling the receiving end what those data streams actually mean.

• There was a time once when I concatenated Ogg files and noticed that they join together. I thought that means Ogg files has no (ultimate) file header, but after some testing that turned out not to be the case.

In the end, I ended up having to use hardware-accelerated H.264 encoding (figuring that out is “fun”) with a ludicrous bitrate (to hopefully minimize the compression overhead) which I stream to Jack to re-encode. Now I really wish there’s something like NUT that you can stream.

• You can’t stream MKV

• You can’t stream NUT

• You can stream MPEG-TS, but it’s picky

• You can stream Ogg, but it’s picky

what else should I use =’(

my data structure teammates can’t understand that they have to commit and push often =’(

Sometimes, you see an image, a video, and then you thought “this would be a great image to be captioned”

TASTE MY BONES!

…WHY ISN’T THIS WORKING?

—Bitti. (2025). [DUB] The Stupidest Undertale Fangame. YouTube. https://youtu.be/a26w9LGNQB4

I bought a new air freshener can only to find out that it’s missing the spray head (=

edit: i found it, it fell on the supermarket floor

apparently windows 11 lost the :( in its bsod recently

Somehow I made this

Python 3.14.0 (main, Oct  7 2025, 00:00:00) [GCC 15.2.1 20250924 (Red Hat 15.2.1-2)] on linux
Enter "help" below or click "Help" above for more information.
>>> verbose
Verbose mode is turned on.
>>> not verbose
Verbose mode is turned off.
False

I love metaclasses

what if no sigma?