[geeks] Databases

[Ken Hansen]

MySQL is about to get perl stored procedures, but I don't see the need/use
for such a thing - I've been on the DB sidelines since IBM DB/2 2.3 (8 or so
years ago)...

Back then dynamic SQL was a big thing, and all teh good databases had
triggers that could be written (to impose complex relationships, enforce
data integrity, etc.)...

Why would I want stored procedures - this is an honest question, not a
retorical one?

Ken
----- Original Message -----
From: "joshua d boyd" <jdboyd at cs.millersville.edu>
To: <geeks at sunhelp.org>
Sent: Friday, August 24, 2001 1:58 PM
Subject: Re: [geeks] Databases


> On Fri, Aug 24, 2001 at 01:16:39PM -0400, Mike Dombrowski wrote:
> > Actually, I've heard that MS SQL is pretty nice - people have referred
> > to it as MS's best software. It can scale much larger than most of the
> > free databases and it quite quick on nice hardware. I played around
> > with it for a bit and found it pretty nice also but I didn't do much
> > digging.
>
> Yeah, but extensibility is a crock, especially the "custom" datatypes
> (which are just constraints on regular fields, rather than news ways to
> understand and query data).  And the only way to write stuff in it is with
> SQL or calls to external DLLs, so no stored procedures in Perl, Python,
> Java, or C really.
>
> --
> Joshua D. Boyd
> _______________________________________________
> GEEKS:  http://www.sunhelp.org/mailman/listinfo/geeks


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com