ColonelThirtyTwo

joined 3 months ago
[–] ColonelThirtyTwo@pawb.social 2 points 2 days ago (1 children)

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.

[–] ColonelThirtyTwo@pawb.social 5 points 2 weeks ago

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

[–] ColonelThirtyTwo@pawb.social 18 points 2 weeks ago* (last edited 2 weeks ago)

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.

[–] ColonelThirtyTwo@pawb.social 10 points 2 weeks ago

FWIW It was recently on the steam front page for me

[–] ColonelThirtyTwo@pawb.social 9 points 3 weeks ago (1 children)

Misinformation wants to be free

[–] ColonelThirtyTwo@pawb.social 20 points 4 weeks ago

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

[–] ColonelThirtyTwo@pawb.social 7 points 1 month ago* (last edited 1 month ago)

Anything with enough access to block malicious programs has enough access to block any other program by mistake.

Security modules like this usually get very invasive with the OS, to be able to monitor everything and so that malicious programs don't have the ability to shut it off.

[–] ColonelThirtyTwo@pawb.social 7 points 1 month ago (1 children)

Low competition industries

Like most of them?

[–] ColonelThirtyTwo@pawb.social 1 points 1 month ago* (last edited 1 month ago) (1 children)

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.

[–] ColonelThirtyTwo@pawb.social 2 points 1 month ago (3 children)

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

[–] ColonelThirtyTwo@pawb.social 22 points 1 month ago

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

[–] ColonelThirtyTwo@pawb.social 19 points 1 month ago (13 children)

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.

 
view more: next ›