Comment by rf15
10 hours ago
Or the use of AUTO_INCREMENT, a feature which is already a footgun if implemented badly (as it clearly was)
10 hours ago
Or the use of AUTO_INCREMENT, a feature which is already a footgun if implemented badly (as it clearly was)
Agreed, and SQL is as important to fully understand, as when, for example, writing C. An inept usage of it, can lead to complete and total disaster.
You wouldn't want a junior to write (unreviewed) an internet connected daemon. Or to try to meet a complex RFC spec. Yet SQL? Why not?!
I think one of the greatest disservices people have done, is to abstract away SQL in frameworks. It certainly lets juniors more safely work with databases, but it really has reduced the general SQL knowledge out there. I see many senior programmers, with almost no exposure. Never touched it.