News for hackers. Stuff that matters.

A comment on Are We in the Middle of a Programming Bubble?. Parent comment

Re:Are We in the Middle of a Programming Bubble? by Animats on Monday January 21, 2019 @02:14PM (#18962726)
"any programming environment you can never stop someone from iterating by index over a binary searchable tree for a specific element in it."

SQL solved that problem a long time ago. You write SELECT, the query optimizer figures out how, using any available indices.

[ Parent | on HN ]
Re:Are We in the Middle of a Programming Bubble? by gldalmaso on Monday January 21, 2019 @03:05PM (#18963153)
I think that misses the point. SQL does not prevent a junior dev from selecting many more rows than he needs to and then proceed to iterate over them naively.
[ Parent | on HN ]