Programming the Perl DBI: Database programming with Perl [NOOK Book]


One of the greatest strengths of the Perl programming language is its ability to manipulate large amounts of data. Database programming is therefore a natural fit for Perl, not only for business applications but also for CGI-based web and intranet applications.

The primary interface for database programming in Perl is DBI. DBI is a database-independent package that provides a consistent set of routines regardless of what database product you use--Oracle, Sybase, Ingres, ...

See more details below
Programming the Perl DBI: Database programming with Perl

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$17.99 price
(Save 43%)$31.99 List Price


One of the greatest strengths of the Perl programming language is its ability to manipulate large amounts of data. Database programming is therefore a natural fit for Perl, not only for business applications but also for CGI-based web and intranet applications.

The primary interface for database programming in Perl is DBI. DBI is a database-independent package that provides a consistent set of routines regardless of what database product you use--Oracle, Sybase, Ingres, Informix, you name it. The design of DBI is to separate the actual database drivers (DBDs) from the programmer's API, so any DBI program can work with any database, or even with multiple databases by different vendors simultaneously.

Programming the Perl DBI is coauthored by Alligator Descartes, one of the most active members of the DBI community, and by Tim Bunce, the inventor of DBI. For the uninitiated, the book explains the architecture of DBI and shows you how to write DBI-based programs. For the experienced DBI dabbler, this book reveals DBI's nuances and the peculiarities of each individual DBD.

The book includes:

  • An introduction to DBI and its design
  • How to construct queries and bind parameters
  • Working with database, driver, and statement handles
  • Debugging techniques
  • Coverage of each existing DBD
  • A complete reference to DBI

This is the definitive book for database programming in Perl.

Read More Show Less

Product Details

  • ISBN-13: 9781449315368
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 2/4/2000
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 366
  • File size: 3 MB

Meet the Author

Tim Bunce has been a perl5 porter since 1994, contributing to the development of the Perl language and many of its core modules. He is the author and maintainer of the DBI, DBD::Oracle,and Oracle::OCI modules, and author and co-maintainer of The Perl Module List. Tim is the founder and CTO of Data-Plan Services, a perl, database, and performance consultancy with an international client base. Prior to that we was Technical Director (CTO) of IG in the UK where he was awarded by British Telecom for his role in the rapid development of their Call Management Information service, a system implemented in Perl. He is co-author, along with Alligator Descartes, of Programming the Perl DBI, the definitive book on DBI, published by O'Reilly & Associates in February 2000.

Read More Show Less

Table of Contents

Typographical Conventions;
How to Contact Us;
Code Examples;
Chapter 1: Introduction;
1.1 From Mainframes to Workstations;
1.2 Perl;
1.3 DBI in the Real World;
1.4 A Historical Interlude andStanding Stones;
Chapter 2: Basic Non-DBI Databases;
2.1 Storage Managers and Layers;
2.2 Query Languages and Data Functions;
2.3 Standing Stones and the Sample Database;
2.4 Flat-File Databases;
2.5 Putting Complex Data into Flat Files;
2.6 Concurrent Database Access and Locking;
2.7 DBM Files and the BerkeleyDatabase Manager;
2.8 The MLDBM Module;
2.9 Summary;
Chapter 3: SQL and Relational Databases;
3.1 The Relational Database Methodology;
3.2 Datatypes and NULL Values;
3.3 Querying Data;
3.4 Modifying Data Within Tables;
3.5 Creating and Destroying Tables;
Chapter 4: Programming with the DBI;
4.1 DBI Architecture;
4.2 Handles;
4.3 Data Source Names;
4.4 Connection and Disconnection;
4.5 Error Handling;
4.6 Utility Methods and Functions;
Chapter 5: Interacting with the Database;
5.1 Issuing Simple Queries;
5.2 Executing Non-SELECT Statements;
5.3 Binding Parameters to Statements;
5.4 Binding Output Columns;
5.5 do( ) Versus prepare( );
5.6 Atomic and Batch Fetching;
Chapter 6: Advanced DBI;
6.1 Handle Attributes and Metadata;
6.2 Handling LONG/LOB Data;
6.3 Transactions, Locking, and Isolation;
Chapter 7: ODBC and the DBI;
7.1 ODBC—Embraced and Extended;
7.2 DBI—Thrashed and Mutated;
7.3 The Nuts and Bolts of ODBC;
7.4 ODBC from Perl;
7.5 The Marriage of DBI and ODBC;
7.6 Questions and Choices;
7.7 Moving Between Win32::ODBC and the DBI;
7.8 And What About ADO?;
Chapter 8: DBI Shell and Database Proxying;
8.1 dbish—The DBI Shell;
8.2 Database Proxying;
DBI Specification;
The DBI Class;
Methods Common to All Handles;
Attributes Common to All Handles;
DBI Database Handle Objects;
DBI Statement Handle Objects;
Further Information;
See Also;
Support/ Warranty;
Driver and Database Characteristics;
Acquiring the DBI and Drivers;
DBD::Empress and DBD::EmpressNet;
DBD::mysql and DBD::mSQL;
DBD::Sybase—For Sybase and Microsoft SQL Server;
ASLaN Sacred Site Charter;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted September 5, 2003

    still a great reference book

    This book has been a valuable reference of mine for several years for web database programming projects. I bought the book soon after it was released and continue to use it - sometimes on a daily basis depending upon the project I am currently developing. I realized from the beginning that much of the material in this book came from the online documentation and have still found the book to be useful enough to stay on my A-list of reference materials. Applications like CGIScripter need to utilize up to half a dozen different databases so I have found the reference section on each database be the section I often turn to first. I have not found this info available anywhere in the online documentation. When you program and debug on multiple computers with multiple windows open simultaneously, having a reference book is often more manageable than opening another window on the computer. And for those times when I am struggling with an especially troublesome programming issue, I have found it very helpful to sit in my easy chair with a reference book like the Perl DBI book in order to research the problem. The only reason I am not giving the book 5 stars is that it hasn't been updated in a few years so it doesn't include info on some of the new DBI supported databases like SQLite.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted August 27, 2010

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)