On Thu, Sep 3, 2009 at 5:13 PM, Anthony Sorace <anothy@gmail.com> wrote:
i've not used matt's sql module itself (i should check it out) so i
can't comment on his implementation, but... SQL is really ugly. it's
not hard to construct something that provides the same functionality
in a much more palatable form. aesthetics aside, if you're dealing
with a database-heavy app, it can make the code much easier to read.


SQL in itself is actually pretty elegant for what it is intended, querying relational tables.

The problem with databases is more one of really bad design. A badly designed database makes SQL use awkward. Using a more general programming language allows you to create abstractions that hide the hideous database. It ends up as a veneer that usually grows and grows and grows trying to "fix" problems that actually exist at the database level itself.

The fact that using SQL against your database is a pain, should really signal alarm bells and make you investigate what may be wrong with its design.

Robby