in reply to A Perl DBMS?

I seem to remember a few years ago, some of the mainstream RDBMS vendors (Oracle and Sybase) were extending their products so stored procs could be written in Java -- and a nice side effect was they did it in such a way that stored procs could be written in almost any language. Sybase's attempt was called ESP and there were some rumblings about perl being in the mix. I don't think the extensions (even Java) ever really took off. Maybe the core programmers doing stored proc development never had a vested interest in learning anything other than T-SQL or PL/SQL or maybe products like DBI, ODBC and JDBC scratch more than 80% of the itch.

-derby

Replies are listed 'Best First'.
Re^2: A Perl DBMS?
by mpeppler (Vicar) on Mar 09, 2007 at 11:23 UTC
    ESPs in Sybase are extended stored procs, usually written in C and executed via an external server (the XP server).

    Java stored procs/functions are available inside of the dataserver as part of the JVM that is included in the dataserver itself.

    I wrote a prototype that loaded a perl interpreter into the XP server and allowed the easy creation of RPCs written in perl, but it was rather clunky and the performance wasn't great...

    Michael

Re^2: A Perl DBMS?
by Moron (Curate) on Mar 07, 2007 at 16:00 UTC
    Not the itch I was thinking about - all that does is move the interface to the server rather than resolve the dissimilarity in data architecture.

    -M

    Free your mind