Programming the Perl DBI
Programming the Perl DBI Database programming with Perl By Alligator Descartes, Tim Bunce
February 2000
Pages: 364

| Table of Contents | Index | Sample Chapter | Colophon

Table of Contents

  1. Chapter 1 Introduction

    1. From Mainframes to Workstations

    2. Perl

    3. DBI in the Real World

    4. A Historical Interlude andStanding Stones

  2. Chapter 2 Basic Non-DBI Databases

    1. Storage Managers and Layers

    2. Query Languages and Data Functions

    3. Standing Stones and the Sample Database

    4. Flat-File Databases

    5. Putting Complex Data into Flat Files

    6. Concurrent Database Access and Locking

    7. DBM Files and the BerkeleyDatabase Manager

    8. The MLDBM Module

    9. Summary

  3. Chapter 3 SQL and Relational Databases

    1. The Relational Database Methodology

    2. Datatypes and NULL Values

    3. Querying Data

    4. Modifying Data Within Tables

    5. Creating and Destroying Tables

  4. Chapter 4 Programming with the DBI

    1. DBI Architecture

    2. Handles

    3. Data Source Names

    4. Connection and Disconnection

    5. Error Handling

    6. Utility Methods and Functions

  5. Chapter 5 Interacting with the Database

    1. Issuing Simple Queries

    2. Executing Non-SELECT Statements

    3. Binding Parameters to Statements

    4. Binding Output Columns

    5. do( ) Versus prepare( )

    6. Atomic and Batch Fetching

  6. Chapter 6 Advanced DBI

    1. Handle Attributes and Metadata

    2. Handling LONG/LOB Data

    3. Transactions, Locking, and Isolation

  7. Chapter 7 ODBC and the DBI

    1. ODBC—Embraced and Extended

    2. DBI—Thrashed and Mutated

    3. The Nuts and Bolts of ODBC

    4. ODBC from Perl

    5. The Marriage of DBI and ODBC

    6. Questions and Choices

    7. Moving Between Win32::ODBC and the DBI

    8. And What About ADO?

  8. Chapter 8 DBI Shell and Database Proxying

    1. dbish—The DBI Shell

    2. Database Proxying

  1. Appendix A DBI Specification

    1. Synopsis

    2. Description

    3. The DBI Class

    4. Methods Common to All Handles

    5. Attributes Common to All Handles

    6. DBI Database Handle Objects

    7. DBI Statement Handle Objects

    8. Further Information

    9. See Also

    10. Authors

    11. Copyright

    12. Acknowledgments

    13. Translations

    14. Support/ Warranty

    15. Training

  2. Appendix B Driver and Database Characteristics

    1. Acquiring the DBI and Drivers

    2. DBD::ADO

    3. DBD::CSV

    4. DBD::DB2

    5. DBD::Empress and DBD::EmpressNet

    6. DBD::Informix

    7. DBD::Ingres

    8. DBD::InterBase

    9. DBD::mysql and DBD::mSQL

    10. DBD::ODBC

    11. DBD::Oracle

    12. DBD::Pg

    13. DBD::SearchServer

    14. DBD::Sybase—For Sybase and Microsoft SQL Server

    15. DBD::XBase

  3. Appendix C ASLaN Sacred Site Charter

  4. Colophon

Return to Programming the Perl DBI