Re: Code in the database or middle tier (the CLR controversy)
From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 06 Jun 2005 23:13:11 -0700
Message-ID: <1118124804.308542_at_yasure>
>
>
>
> LOL
>
> I'm using SQL in PERL, am I a bad person now?
> I've used PL/SQL client side, and I found it to be tough, I was much
> more busy with the language elements than creating fast, optimized SQL.
> Perl is a really sloppy (not inefficient though) language, you don't
> have to think (about the language) while coding, put some nice SQL in it
> though.
>
> -R-
Date: Mon, 06 Jun 2005 23:13:11 -0700
Message-ID: <1118124804.308542_at_yasure>
Jurgen Haan wrote:
> DA Morgan wrote:
>
>> Serge Rielau wrote:
>
>
>>> Are programmers using PL/SQL on the app side any smarter w.r.t. >>> relational SQL than those using VB? Do they write better SQL because >>> they use PL/SQL? >> >> >> >> Yes. Yes. Yes. >>
>
> LOL
>
> I'm using SQL in PERL, am I a bad person now?
> I've used PL/SQL client side, and I found it to be tough, I was much
> more busy with the language elements than creating fast, optimized SQL.
> Perl is a really sloppy (not inefficient though) language, you don't
> have to think (about the language) while coding, put some nice SQL in it
> though.
>
> -R-
Post some of your complex SQL statements if you'd like to find out what others think.
But if you read my comments closely you would have noted that much of my concern was that these people would then blur the line into designing schemas, creating tables, indexes, and likely few if any constraints.
And yes I am painting with an extremely broad brush. A few will write good code: I think the vast majority will trash the environment in which they are working.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Tue Jun 07 2005 - 08:13:11 CEST