develooper Front page | perl.perl5.porters | Postings from March 2000

Re: hook for qs// operator for embedded SQL?

From:
Joseph N. Hall
Date:
March 20, 2000 11:32
Subject:
Re: hook for qs// operator for embedded SQL?
Message ID:
MailDrop1.2d7j-PPC.1000320123243@perlfaq.com
* On Mon, 20 Mar 2000, Joseph N. Hall wrote:
*
* > Sure, as long as you don't use your RDBMS in the manner that most users do,
* > that is, via stored procedures.
*
* Well, you got me.  I use MySQL, and thus have no stored procedures at all!
*
* How does this invalidate my arguement - that you could do ESQL just like
* all the other ESQL implementations, using a preproceessor (or Filter?)?
*
* -sam

If I had my druthers I'd rather have something providing capability
more like PL/SQL than Pro*C, and that's more tightly coupled.  And as I
intimated in another post, life starts out simpler when you try to
write something as a filter, but then rapidly becomes more complicated.
To wit, Cfront vs. "all-in-one" C++ compilers.  Tracing run-time errors
and exceptions back to their source is a lot less fun.

Anyway, on the other topic, I've heard the "stored procedures" whinge 
in every single DBI class I've ever taught.  You can do it in DBI but
every DBD is different and some still basically don't support them.

I like MySQL a lot but you'll find many people who just giggle when
you put that 'R' in front of 'DBMS' in juxtaposition with MySQL.

  -joseph




nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About