From mboxrd@z Thu Jan 1 00:00:00 1970 MIME-Version: 1.0 In-Reply-To: <509071940909030913q24d0da62x13daa9c04494964f@mail.gmail.com> References: <4A9FA6B5.9020302@maht0x0r.net> <838f0f5ea30688aae8174b6c42844ef9@quanstro.net> <509071940909030913q24d0da62x13daa9c04494964f@mail.gmail.com> Date: Thu, 3 Sep 2009 17:34:16 +0100 Message-ID: <6a3ae47e0909030934w7a2533aaoaf74b9c8807ac252@mail.gmail.com> From: Robert Raschke To: Fans of the OS Plan 9 from Bell Labs <9fans@9fans.net> Content-Type: multipart/alternative; boundary=0003255563ae64af5b0472aef41e Subject: Re: [9fans] Interested in improving networking in Plan 9 Topicbox-Message-UUID: 61c3f0fc-ead5-11e9-9d60-3106f5b1d025 --0003255563ae64af5b0472aef41e Content-Type: text/plain; charset=UTF-8 On Thu, Sep 3, 2009 at 5:13 PM, Anthony Sorace 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 --0003255563ae64af5b0472aef41e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 databa= ses is more one of really bad design. A badly designed database makes SQL u= se awkward. Using a more general programming language allows you to create = abstractions that hide the hideous database. It ends up as a veneer that us= ually grows and grows and grows trying to "fix" problems that act= ually 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 desi= gn.

Robby

--0003255563ae64af5b0472aef41e--