zepplenzap

joined 1 year ago
sorted by: new top controversial old
University of Chicago researchers release Nightshade to public, a tool that is intended to "poison" pictures in order to ruin generative models trained on them. in c/technology@lemmy.ml
[–] zepplenzap@lemmy.sdf.org 4 points 10 months ago (1 children)

If this technology is so great, why does the site not show any before / after examples? Let alone demonstrating that it does what he claims?

This comic was published less than ten years ago, and it's wild how obsolete it is in c/programming@programming.dev
What the electric car transition really means for autoworkers in c/technology@lemmy.world
[–] zepplenzap@lemmy.sdf.org 6 points 1 year ago (2 children)

Counterpoint to lightbulb planned obsolescence: https://youtu.be/zb7Bs98KmnY?si=h-i2U3Q8YE5tHW7G

Imagine trusting oracle in c/linux@lemmy.ml
[–] zepplenzap@lemmy.sdf.org 4 points 1 year ago (1 children)

You have chosen wisely

If incandescent lightbulbs have a vacuum inside, why do they get so hot on the outside? in c/nostupidquestions@lemmy.world
[–] zepplenzap@lemmy.sdf.org 6 points 1 year ago (3 children)

More then you ever thought you needed to know about lightbulbs! (Including the fact that inconsistent light bulbs are not vacuumes, they just have no oxygen, so they heat up via normal connection)

https://youtu.be/zb7Bs98KmnY

I Don't Need Your Query Language in c/programming@lemmy.ml
[–] zepplenzap@lemmy.sdf.org 0 points 1 year ago* (last edited 1 year ago) (1 children)

It has been years since I wrote any SQL, so I may just be missing something but:

Why is the "As it could be" example for the second example using sub selects?!

Especially the one in the where clause where they are selecting two tables that they already joined in the from clause?

And wouldn't it be quicker to join the review table and use a group by?