Many database-oriented extensions to Perl have been written. Basically, these use the usub mechanism (see the usub/ subdirectory) in the source distribution) to link in a database library, allowing embedded calls to Informix, Ingres, Interbase, Oracle and Sybase.
Here are the authors of the various extensions:
What Target DB Who -------- ----------- ---------------------------------------- ?Infoperl Informix Kurt Andersen (email@example.com) Ingperl Ingres Tim Bunce (firstname.lastname@example.org) and Ted Lemon Interperl Interbase Buzz Moschetti (email@example.com) Isqlperl Informix William Hails firstname.lastname@example.org Oraperl Oracle Kevin Stock (kstock@Auspex.com) Pgperl Postgres Igor Metz (email@example.com) *Sqlperl Ingres Ted Lemon (firstname.lastname@example.org) Sybperl Sybase Michael Peppler (email@example.com) Uniperl Unify 5.0 Rick Wargo (firstname.lastname@example.org) ? Does this one still exist?
*Sqlperl appears to have been subsumed by Ingperl
Buzz Moschetti* has organized a project to create a higher level interface to allow you to write your queries in a database-independent fashion. If this type of project interests you, send mail to <email@example.com> and asked to be placed on the ``perldb-interest'' mailing lists.
Here's a bit of advertising from Buzz:
Perl is an interpreted language with powerful string, scalar, and array processing features developed by Larry Wall that ``nicely bridges the functionality gap between sh(1) and C.'' Since relational DB operations are typically textually oriented, perl is particularly well-suited to manage the data flows. The C source code, which is available free of charge and runs on many platforms, contains a user-defined function entry point that permits a developer to extend the basic function set of the language. The DBperl Group seeks to exploit this capability by creating a standardized set of perl function extensions (e.g. db_fetch(), db_attach()) based on the SQL model for manipulating a relational DB, thus providing a portable perl interface to a variety of popular RDMS engines including Sybase, Oracle, Ingres, Informix, and Interbase. In theory, any DB engine that implements a dynamic SQL interpreter in its HLI can be bolted onto the perl front end with predicatable results, although at this time backends exist only for the aforementioned five DB engines.
The official archive for DBperl extensions is ftp://ftp.demon.co.uk/pub/perl/db It's the home of the evolving DBperl API Specification. Here's an extract from the updated README there:
DBI/ The home of the DBI archive. To join the DBI mailing list send your request to perldb-interest-REQUEST@vix.com DBD/ Database Drivers for the DBI ... Oracle/ By Tim Bunce (not yet ready!) Ingres/ By Tim Bunce (not yet started!) mod/ Other Perl 5 Modules and Extensions ... Sybperl/ By Michael Peppler, firstname.lastname@example.org perl4/ Perl 4 extensions (using the usub C interface) oraperl/ ORACLE 6 & 7 By Kevin Stock, email@example.com sybperl/ SYBASE 4 By Michael Peppler, firstname.lastname@example.org ingperl/ INGRES By Tim Bunce email@example.com and Ted Lemon isqlperl/ INFORMIX By William Hails, firstname.lastname@example.org interperl/ INTERBASE By Buzz Moschetti, email@example.com oraperl/ ORACLE 6 & 7 By Kevin Stock (sadly no longer on the net) sybperl/ SYBASE 4 By Michael Peppler, firstname.lastname@example.org ingperl/ INGRES By Tim Bunce email@example.com and Ted Lemon isqlperl/ INFORMIX By William Hails, firstname.lastname@example.org interperl/ INTERBASE By Buzz Moschetti, email@example.com uniperl/ UNIFY 5.0 By Rick Wargo, firstname.lastname@example.org pgperl/ POSTGRES By Igor Metz, email@example.com btreeperl/ NDBM perl extensions. By John Conover, firstname.lastname@example.org ctreeperl/ C-Tree perl extensions. By John Conover, email@example.com duaperl/ X.500 Directory User Agent. By Eric Douglas. scripts/ Perl and shell scripts rdb/ RDB is a perl RDBMS for ASCII files. By Walt Hobbs, firstname.lastname@example.org shql/ SHQL is an interactive SQL database engine. Written as a shell script, SHQL interprets SQL commands and manipulates flat files based on those commands. By Bruce Momjian, email@example.com xbase/ Perl scripts for accessing xBase style files (dBase III) refinfo/ Reference information sqlsyntax/ Yacc and lex syntax and C source code for SQL1 and SQL2 from ftp.uu.net:/pub/uunet/published/oreilly/nutshell/yacclex, and a draft SQL3 syntax from Jeff Fried <firstname.lastname@example.org>+ formats/ Details of file formats such as Lotus 1-2-3 .WK1There are also a number of non SQL database interfaces for perl available from ftp.demon.co.uk. These include:
Directory Target System Authors and notes --------- ------------- ------------------------------------------- btreeperl NDBM extension John Conover (email@example.com) ctreeperl CTree extension John Conover (firstname.lastname@example.org) duaperl X.500 DUA Eric Douglas rdb RDBMS Walt Hobbs (email@example.com) shql SQL Engine Bruce Momjian (firstname.lastname@example.org)
Other resources at this site: