logoalt Hacker News

rf15yesterday at 11:11 PM1 replyview on HN

Or the use of AUTO_INCREMENT, a feature which is already a footgun if implemented badly (as it clearly was)


Replies

b112yesterday at 11:41 PM

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.