News for hackers. Stuff that matters.

A comment on Things I wished more developers knew about databases. Parent comment

Re:Things I wished more developers knew about databases by EvanAnderson on Wednesday April 22, 2020 @12:05PM (#22947036)
Some of the most fun I've ever had coding has been creating "complex" SQL queries. The syntax is something that can only be overcome with memorization, but it becomes second-nature fairly quickly.

Until I started thinking about SQL as manipulating sets it never "clicked". Once it did, though, a whole world of applications filled with mismatched procedural thinking mapped on to SQL was revealed to me, and my own work became much easier.

[ Parent | on HN ]
Re:Things I wished more developers knew about databases by eropple on Wednesday April 22, 2020 @02:13PM (#22948503)
Despite our industry's habit of treating mathy whiteboard things as indicative of one's "programming talent", real application of type, set, and graph theory are not tested nearly as much as they end up being in practice, and I think that developers' reticence to get deep into SQL is symptomatic of the weaknesses there.
[ Parent | on HN ]
Re:Things I wished more developers knew about databases by resu_nimda on Wednesday April 22, 2020 @01:00PM (#22947676)
The first time I accidentally typed "select 8 from users..." and, instead of an error, it returned a column called "8" with a bunch of rows with the value "8", my mind was blown.
[ Parent | on HN ]