Ran into low-stakes, small-scale versions of this in Javascript "live collections." CSS-based (CSS-like?) query selectors return one of JS's many Array-like object types. Just... so many partially-implemented Array variations. Anyway: Array.from( document.querySelectorAll( 'whatever' ) ) turns the initial auto-updating set into a more static list of elements.

[–] Ellvix@beehaw.org 13 points 1 year ago (1 children)

Omfgf utf8mb4. That one in particular snagged me.

Want to use international languages? Sure, use utf8, it's easy and works everywhere and includes basically every character you could ever want, right? Well, except some popular databases like MySQL where utf8 doesn't actually have the full character set, and is some subset instead. Now in your app some languages will cause weird errors because the characters aren't supported and you won't know why until you dig in and find the issue and that this was considered and a character set that ACTUALLY includes the full set was created and it's called utf8mb4. And you can use it and your app works again but you scratch your head and wonder why a separate set was created when everyone knows the usual utf8 and no one would know to look further, and dig further because you're already this deep and it turns out the answer is sort of that it was convenient at the time. And if a database this popular can have such a strange seemingly broken behavior for no reason then what's going on and does anything really even work. But... then your own spaghetti code doesn't seem so bad.

[–] etchinghillside@reddthat.com 3 points 1 year ago (1 children)

A poop emoji broke my ETL pipeline.

[–] akariii@lemmy.blahaj.zone 1 points 1 year ago (1 children)

elaborate

[–] etchinghillside@reddthat.com 2 points 1 year ago

MySQL’s utf8 didn’t support the character – had to migrate to utf8mb4. It was just very fitting that the first time it occurred was with a poop emoji.

[–] Gork@lemm.ee 8 points 1 year ago

allballs sounds like a gay porno

[–] argv_minus_one@beehaw.org 5 points 1 year ago

What the heck is database cracking?

[–] Franzia@lemmy.blahaj.zone 4 points 1 year ago

Omg 😱 wtf does it mean

[–] akariii@lemmy.blahaj.zone 1 points 1 year ago

I want this but for haskell

[–] quantenzitrone@feddit.de 0 points 1 year ago (1 children)

NULL is top of the iceberg and deep sea at the same time

[–] akariii@lemmy.blahaj.zone 1 points 1 year ago

that is correct