DaleSwanson ( @DaleSwanson@kbin.social ) 16•10 months agohttps://avestura.dev/blog/explaining-the-postgres-meme
A good blog post explaining, at least a bit, everything in this image.
Ellvix ( @Ellvix@beehaw.org ) 14•10 months agoOmfgf 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 ( @etchinghillside@reddthat.com ) 3•10 months agoA poop emoji broke my ETL pipeline.
akari ( @akariii@lemmy.blahaj.zone ) 1•10 months agoelaborate
etchinghillside ( @etchinghillside@reddthat.com ) 2•10 months agoMySQL’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 ( @Gork@lemm.ee ) 6•10 months agoallballs sounds like a gay porno
- argv_minus_one ( @argv_minus_one@beehaw.org ) 6•10 months ago
What the heck is database cracking?
Franzia ( @Franzia@lemmy.blahaj.zone ) 4•10 months agoOmg 😱 wtf does it mean
akari ( @akariii@lemmy.blahaj.zone ) 1•10 months agoI want this but for haskell
quantenzitrone ( @quantenzitrone@feddit.de ) 0•10 months agoNULL
is top of the iceberg and deep sea at the same time akari ( @akariii@lemmy.blahaj.zone ) 1•10 months agothat is correct