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

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

From:
Sam Tregar
Date:
March 20, 2000 10:26
Subject:
Re: hook for qs// operator for embedded SQL?
Message ID:
Pine.LNX.4.21.0003201321220.11701-100000@zoltar.vm.com
On Mon, 20 Mar 2000, Joseph N. Hall wrote:

> (1) DBI is becoming one of the most popular applications for Perl.  My
>     requests for DBI included in Perl training have become incredibly
>     more frequent during the past year.

Part of the reason for that is that DBI is very well designed.  Its API is
consistent and full-featured in a way that very few others are.

> (2) DBI is convenient to use but Perl still lacks the near-total 
>     convenience of languages that support full embedded SQL.

No language I know of "really" has embedded SQL.   What they have is a
preprocessor that turns some ESQL syntax into real code.  If you like
that kind of thing, why not follow their lead?  I imagine that cooking up
an ESQL to DBI translator wouldn't be all that hard.

> DBI isn't exactly hard to use, but again, it isn't as stupid simple
> EASY as other languages that support real embedded SQL.

Highly debateable.  Most of my difficulty in learning to use DBI is
actually learning SQL.  Once I groked SQL, DBI was a snap.

> (I no longer receive p5p after having been bounced off the list during
> a DNS outage and not bothering to resubscribe, so please cc me any
> messages you think I should read.)

Unacceptable.  But, then, you probably knew that.  This is basic
netiquette in the clasic USENET sense.

-sam





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