Wow, until now I never knew about PL/Perl. I'm not a Postgres user, but now I might change my mind...
When I mainly worked in an Oracle environment, we did most of our business logic in Oracle PL/SQL, and none of the external languages ever issues SQL at all. It meant that we had a common data API for the Perl back-end and the MS VB front-end, and it also provided a security layer as no one had access to the raw tables. I found out about extproc_perl in "Perl for Oracle DBAs." It effectively allows you to call your Perl functions from SQL and PL/SQL, which is about as close to a PL/Perl-like environment as I'll get ever get with Oracle. Dan -----Original Message----- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Mark Stosberg Sent: Wednesday, 13 October 2004 1:24 a.m. To: [EMAIL PROTECTED] Subject: [cgiapp] Re: ANN: CGI::Application::Plugin::HtmlTemplate On 2004-10-12, Thilo Planz <[EMAIL PROTECTED]> wrote: > > I guess the runmode that automatically dispatches to your templates is > the main thing. So how about a name like: ::Plugin::AutoDispatch (or if you want to be consistent with ::ConfigAuto) ::Plugin::DispatchAuto Another names might be: ::LocateTmpl > Actually, I moved almost all of the functionality into stored > procedures of the database, > and the Perl part is really just a shell to call those procedures from > the web. Interesting, what DB and procedure language are you using? Postgres is my database of choice and I'm interested in playing more with Perl as a server side procedural language. I see in the 8.0 release notes that there are significant improvements in it recently: "A new version of the plperl server-side language now supports a persistent shared storage area, triggers, returning records and arrays of records, and SPI calls to access the database." Mark -- http://mark.stosberg.com/ --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[EMAIL PROTECTED]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[EMAIL PROTECTED]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
