In September 1992, Buzz Moschetti, creator of interperl, observed that several bespoke compiled extensions of perl (at the time, perl version 4 or more commonly perl4) featuring connectivity to popular SQL-based databases had emerged, namely Interbase, Informix, Oracle, and Sybase. He engaged the authors of these bespoke versions [1] with the idea of creating a common interface layer to the databases separate from the specifics of the underlying implementations. Tim Bunce took the lead and began specifying what would become the DBI module in 1994 upon the release of perl5 which eliminated the need for bespoke compilation in favor of dynamic, invocation time loading of libraries (modules).[2] As of 2010[update] the Perl community maintains DBI as a CPAN module in accordance with the open-source model. DBD (DataBase Driver) modules serve as plug-ins to DBI, allowing programmers to use near-database-independent SQL code in their applications. Programmers can also use the DBI and DBD modules indirectly using one of the object-relational mappers available for Perl, such as DBIx::Class, for more database-independent code with no need to write SQL.
Featuresedit
The DBI and DBD Perl packages allow Perl programmers to access many database environments in a standard way. The system implements each supported database environment as a DBD driver, in much the same way that hardware devices from multiple vendors can operate with different CPU platforms. Prospective DBD users can download DBD implementations from the Internet. DBD implementations exist for proprietary products such as IBM Db2, Microsoft SQL Server, Oracle and for free-software databases such as SQLite, PostgreSQL, Firebird and MySQL.
perl, this, article, multiple, issues, please, help, improve, discuss, these, issues, talk, page, learn, when, remove, these, template, messages, this, article, relies, excessively, references, primary, sources, please, improve, this, article, adding, secondar. This article has multiple issues Please help improve it or discuss these issues on the talk page Learn how and when to remove these template messages This article relies excessively on references to primary sources Please improve this article by adding secondary or tertiary sources Find sources Perl DBI news newspapers books scholar JSTOR February 2012 Learn how and when to remove this message The topic of this article may not meet Wikipedia s notability guidelines for products and services Please help to demonstrate the notability of the topic by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond a mere trivial mention If notability cannot be shown the article is likely to be merged redirected or deleted Find sources Perl DBI news newspapers books scholar JSTOR February 2012 Learn how and when to remove this message Learn how and when to remove this message In computing the Perl DBI Perl Database Interface offers a standardized way for programmers using the Perl programming language to embed database communication within their programs The latest DBI module for Perl from CPAN can run on a range of operating systems Contents 1 History 2 Features 3 Similar projects 4 References 5 External linksHistory editIn September 1992 Buzz Moschetti creator of interperl observed that several bespoke compiled extensions of perl at the time perl version 4 or more commonly perl4 featuring connectivity to popular SQL based databases had emerged namely Interbase Informix Oracle and Sybase He engaged the authors of these bespoke versions 1 with the idea of creating a common interface layer to the databases separate from the specifics of the underlying implementations Tim Bunce took the lead and began specifying what would become the DBI module in 1994 upon the release of perl5 which eliminated the need for bespoke compilation in favor of dynamic invocation time loading of libraries modules 2 As of 2010 update the Perl community maintains DBI as a CPAN module in accordance with the open source model DBD DataBase Driver modules serve as plug ins to DBI allowing programmers to use near database independent SQL code in their applications Programmers can also use the DBI and DBD modules indirectly using one of the object relational mappers available for Perl such as DBIx Class for more database independent code with no need to write SQL Features editThe DBI and DBD Perl packages allow Perl programmers to access many database environments in a standard way The system implements each supported database environment as a DBD driver in much the same way that hardware devices from multiple vendors can operate with different CPU platforms Prospective DBD users can download DBD implementations from the Internet DBD implementations exist for proprietary products such as IBM Db2 Microsoft SQL Server Oracle and for free software databases such as SQLite PostgreSQL Firebird and MySQL Similar projects editPHP 5 has a similar interface called PHP Data Objects PDO 3 Java s Java Database Connectivity JDBC is also similar References edit Reflections on Perl and DBI from an Early Contributor 8 July 2010 DBI Changes List of significant changes to the DBI metacpan org Archived from the original on 2014 05 13 Retrieved 2014 05 09 PHP Introduction Manual External links editOfficial website DBI module documentation on MetaCPAN DBD drivers on MetaCPAN nbsp This free and open source software article is a stub You can help Wikipedia by expanding it vte Retrieved from https en wikipedia org w index php title Perl DBI amp oldid 1138623865, wikipedia, wiki, book, books, library,
