An UPDATE without a WHERE, or something close to it

Re:An UPDATE without a WHERE, or something close to it by tehlike on Saturday October 30, 2021 @02:10AM (#29046410)

Sql is not the best language. As someone put it once "The entire database industry is hauling a massive SQL-shaped parachute behind them. This complexity creates a drag on everything downstream."

Linq is closest to the a more natural querying language we have come up with. Too bad it doesn't do update.

[ Parent | on HN ]

Re:An UPDATE without a WHERE, or something close to it by omegalulw on Saturday October 30, 2021 @02:38AM (#29046558)

I'm kinda bummed out with these recent SQL tropes. Plenty of people look down on SQL and try or try to make the new fancy thing only for it to fall flat on it's face and for people to realize that SQL is pretty good. It's not great for programmatic access but it's great for analytics and manual querying.

[ Parent | on HN ]

Re:An UPDATE without a WHERE, or something close to it by tehlike on Saturday November 06, 2021 @07:08PM (#29134712)

Sql was good for what it was doing.

But that doesn't mean it's ideal. It just has a large most that people wasn't able to disrupt.

Check out linq both the sql-like form and the lambda form. It feels much better for what it does.

[ Parent | on HN ]