Skip Navigation

InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)C

ColonelThirtyTwo

@ ColonelThirtyTwo @pawb.social

Posts
3
Comments
59
Joined
2 yr. ago

  • C rule

    Jump

  • It's mostly because C is notorious for not holding your hand and not telling you when you mess up. Write one past the array's length? Might do nothing, might crash, might mess up some other data, might crash later in somewhere completely different.

  • Please pick a password starting with ad and ending with min

    Jump

  • I use a keepass vault thrown in a syncthing directory but like literally any file sync will do. If you get conflicts, KeePassXC can merge them

  • Recommendation engine: Downvote any game you've heard of before

    Jump

  • X’s new AI image generator will make anything from Taylor Swift in lingerie to Kamala Harris with a gun

    Jump

  • Misinformation wants to be free

  • Does Donald Trump understand how the ocean works? Once again Monday night, he claimed that rising sea levels would create “more oceanfront property.”

    Jump

  • Well you see, the oceanfront properties we already sold will be underwater, so we can build new ones and sell them again!

  • Amerirule exceptionalism

    Jump

  • I thought it was: 1. The devil defeats Johnny, 2. Johnny defeats the devil but disappears after, and 3. Johnny defeats the devil and returns as a child to warn the Pope.

  • Loona rule

    Jump

  • Only if you're trans: P

  • Burger Ruler

    Jump

  • Oh boy 6AM!

  • Ruleclick

    Jump

  • Everyone in this thread needs to go watch Line Go Up at Folding Ideas

  • Ruleclick

    Jump

  • I don't think that's true. Bitcoins are fungible, NFTs aren't.

  • JSON Query Language

    Jump

  • My point is that SQL works with and returns data as a flat table, which is ill fitting for most websites, which involve many parent-child object relationships. It requires extra queries to fetch one-to-many relationships and postprocessing of the result set to match the parents to the children.

    I'm just sad that in the decades that SQL has been around, there hasn't been anything else to replace it. Most NoSQL databases throw out the good (ACID, transactions, indexes) with the bad.

  • JSON Query Language

    Jump

  • The fact that you'd need to keep this structure in SQL and make sure it's consistent and updated kinda proves my point.

    It's also not really relevant to my example, which involves a single level parent-child relationship of completely different models (posts and tags).

  • We Just Lived Through Two of the Hottest Days Ever. Does Anyone Care?

    Jump

  • "The planet is fine. The people are fucked."

  • JSON Query Language

    Jump

  • SQL blows for hierarchical data though.

    Want to fetch a page of posts AND their tags in normalized SQL? Either do a left join and repeat all the post values for every tag or do two round-trip queries and manually join them in code.

    If you have the tags in a JSON blob on the post object, you just fetch and decide that.

  • Hyprland is now fully independent!

    Jump

  • Damn why does all the software I want to use end up being developed by bigoted assholes. First nix now this.

  • Yummy rule

    Jump

  • Deep fried mozzarella

  • Accessibility Rule

    Jump

  • That's quite the turd(le) they dropped

  • Webp Discourse

    Jump

  • "Can't media format X run arbitrary code" is almost never an issue with the format itself and virtually always a bug with a particular decoder/player.