ColonelThirtyTwo

@ColonelThirtyTwo@pawb.social
1 Post – 27 Comments
Joined 5 months ago

The "standalone version with the best mods" you made I assume

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.

1 more...

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.

12 more...

VVVVVV is awesome so it's cool

Copy Kitty: https://store.steampowered.com/app/349250/Copy_Kitty/ has a demo

Fun elimination platformer. If you wish Kirby did more with the power mixing from Kirby 64, you'll probably like it.

Deep fried mozzarella

FWIW It was recently on the steam front page for me

Fireworks are art. Art isn't inherently wasteful.

Misinformation wants to be free

To put it into perspective, the fine was 0.8% of that net income.

Oh boy 6AM!

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

They're still rambling about Hilary; they'll still ramble about Biden.

Unfortunately Nintendo's creativity also extends to their legal department

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

I have a chair, it's the orange thing on the left

There's a lamp post on the right

Re blue sky, is anyone actually federating with it? I don't know of any other instances besides the official one.

2 more...

Only if you're trans: P

3 more...

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

They both had a lot of issues at launch

1 more...

Both mentioned games are notorious for the scale of the issues at launch, and the resulting backlash. NMS for the lack of content and Cyberpunk for the huge amount of bugs.

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

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).

2 more...

And how is calling conservatives "weird" how you describe?

Compared to conservatives calling anything left of them "communist", calling a party backing a felon president and a vice president that can't even make small talk at a doughnut store "weird" is very fitting.

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.

That's quite the turd(le) they dropped