Publisher: O'Reilly Media
Final Release Date: February 2000
Pages: 366
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.
|
-
Chapter 1 Introduction -
From Mainframes to Workstations -
Perl -
DBI in the Real World -
A Historical Interlude andStanding Stones -
Chapter 2 Basic Non-DBI Databases -
Storage Managers and Layers -
Query Languages and Data Functions -
Standing Stones and the Sample Database -
Flat-File Databases -
Putting Complex Data into Flat Files -
Concurrent Database Access and Locking -
DBM Files and the BerkeleyDatabase Manager -
The MLDBM Module -
Summary -
Chapter 3 SQL and Relational Databases -
The Relational Database Methodology -
Datatypes and NULL Values -
Querying Data -
Modifying Data Within Tables -
Creating and Destroying Tables -
Chapter 4 Programming with the DBI -
DBI Architecture -
Handles -
Data Source Names -
Connection and Disconnection -
Error Handling -
Utility Methods and Functions -
Chapter 5 Interacting with the Database -
Issuing Simple Queries -
Executing Non-SELECT Statements -
Binding Parameters to Statements -
Binding Output Columns -
do( ) Versus prepare( ) -
Atomic and Batch Fetching -
Chapter 6 Advanced DBI -
Handle Attributes and Metadata -
Handling LONG/LOB Data -
Transactions, Locking, and Isolation -
Chapter 7 ODBC and the DBI -
ODBC—Embraced and Extended -
DBI—Thrashed and Mutated -
The Nuts and Bolts of ODBC -
ODBC from Perl -
The Marriage of DBI and ODBC -
Questions and Choices -
Moving Between Win32::ODBC and the DBI -
And What About ADO? -
Chapter 8 DBI Shell and Database Proxying -
dbish—The DBI Shell -
Database Proxying -
Appendix DBI Specification -
Synopsis -
Description -
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 -
Authors -
Copyright -
Acknowledgments -
Translations -
Support/ Warranty -
Training -
Appendix Driver and Database Characteristics -
Acquiring the DBI and Drivers -
DBD::ADO -
DBD::CSV -
DBD::DB2 -
DBD::Empress and DBD::EmpressNet -
DBD::Informix -
DBD::Ingres -
DBD::InterBase -
DBD::mysql and DBD::mSQL -
DBD::ODBC -
DBD::Oracle -
DBD::Pg -
DBD::SearchServer -
DBD::Sybase—For Sybase and Microsoft SQL Server -
DBD::XBase -
Appendix ASLaN Sacred Site Charter -
Colophon |
- Title:
- Programming the Perl DBI
- By:
- Tim Bunce, Alligator Descartes
- Publisher:
- O'Reilly Media
- Formats:
-
- Print
- Ebook
- Safari Books Online
- Print:
- February 2000
- Ebook:
- July 2011
- Pages:
- 366
- Print ISBN:
- 978-1-56592-699-8
- | ISBN 10:
- 1-56592-699-4
- Ebook ISBN:
- 978-1-4493-8670-2
- | ISBN 10:
- 1-4493-8670-9
|
-
Tim Bunce 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. View Tim Bunce's full profile page. |
Colophon Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of Programming the Perl DBI is a cheetah (Acinonyx jubatus), one of the oldest big cats, dating back four million years.The cheetah is the fastest land animal in the world, reaching speeds up to 70 miles per hour, powered by its long legs and lean body. Its body is tan with black spots, and, at a distance, it's hard to tell males from females. A cheetah grows to be approximately two and a half feet tall at the shoulder; it measures around four feet long, with a tail about two feet long. An adult weighs 90-130 pounds. The life span of the cheetah is about ten years.A mother cheetah's litter includes four to five cubs, who stay with their mother for a year and a half. The young learn hunting and survival skills in that time. The cheetah hunts by stalking and chasing its prey, which includes antelope, gazelles, rabbits, and game birds.The cheetah is now considered to be an endangered species, with only 10,000-12,000 alive today, living almost exclusively in the grasslands of Africa. That number is much lower than the estimated 100,000 in 1900. In fact, it is extinct in more than twenty of the countries it originally inhabited. The cheetah suffers from loss of both habitat and food, plus poaching. Conservation groups are working to help preserve the cheetah in its natural habitat and keep it from extinction. Nicole Arigo was the production editor and copyeditor for this book. Madeleine Newell proofread the book. Melanie Wang, Sarah Jane Shangraw, and Jane Ellin provided quality control. Judy Hoer wrote the index.Hanna Dyer designed the cover of this book, based on a series design by Edie Freedman. The cover image is a 19th-century engraving from the Dover Pictorial Archive. Kathleen Wilson produced the cover layout with QuarkXPress 4.04 using Adobe's ITC Garamond font. Alicia Cech designed the interior layout based on a series design by Nancy Priest. Mike Sierra implemented the design in FrameMaker 5.5. The text and heading fonts are ITC Garamond Light and Garamond Book. The illustrations that appear in the book were produced by Robert Romano using Macromedia FreeHand 8 and Adobe Photoshop 5. This colophon was written by Nicole Arigo.Whenever possible, our books use RepKover™, a durable and flexible lay-flat binding. If the page count exceeds RepKover™'s limit, perfect binding is used. |
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
|
|
|
|
Recommended for You
|
Recently Viewed
|
|
|
By Randal L. Schwartz, Erik Olson, Tom Christiansen
August 1997
By Larry Wall, Tom Christiansen, Jon Orwant
July 2000
By James Tisdall
October 2001
Ebook
:
$31.99
Print & Ebook
:
$43.95
Print
:
$39.95
|
Customer Reviews
By KingNeziL from Undisclosed 7/13/2001 (1 of 1 customers found this review helpful) 5.0Programming the Perl DBI Review 2/16/2001 3.0Programming the Perl DBI Review By Russ Roberts from Undisclosed 10/30/2000 4.0Programming the Perl DBI Review By Hector Sandoval from Undisclosed 8/26/2000 4.0Programming the Perl DBI Review By Todd Derenne from Undisclosed 7/11/2000 5.0Programming the Perl DBI Review By Eric Lorenz from Undisclosed 5/31/2000 4.0Programming the Perl DBI Review By Bernardo Gonzalez from Undisclosed 5/15/2000 5.0Programming the Perl DBI Review By Cat LeDevic from Undisclosed |
|
|
