News for hackers. Stuff that matters.
Re:Database development mistakes made by application developers by mcantor on Monday December 13, 2010 @12:32PM (#2001215)
By "lack of a good composition mechanism," are you referring to the trappings of writing and dealing with SQL syntax itself? As in, "Ugh. I decided to change this join into a subquery, and now my @#$#% parentheses are imbalanced!"?

If so, I agree strongly, but I feel like that problem could be solved by better error reporting on the part of the compiler. I dread SQL errors now, at least with Oracle (which I work with the most often), because they almost never tell me what I need to know. To a certain extent it's essential to the abstraction of data reporting itself, but certain errors are just comically vague.

Re:Database development mistakes made by application developers by contextfree on Monday December 13, 2010 @01:09PM (#2001380)
Not really, I'm referring more to the ability to factor out common patterns and compose them together to make queries, etc.