Programming the Perl DBI /
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 pro...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Otros Autores: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Cambridge, MA :
O'Reilly,
2000.
|
Edición: | 1st ed. |
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Preface; Resources; Typographical Conventions; How to Contact Us; Code Examples; Acknowledgments; Introduction; From Mainframes to Workstations; Perl; DBI in the Real World; A Historical Interlude and Standing Stones; Basic Non-DBI Databases; Storage Managers and Layers; Query Languages and Data Functions; Standing Stones and the Sample Database; Flat-File Databases; Querying Data; Inserting Data; Updating Data; Deleting Data; Putting Complex Data into Flat Files; The Perl Data::Dumper Module; The Storable Module; Summary of Flat-File Databases. Concurrent Database Access and Locking DBM Files and the Berkeley Database Manager; Creating a New Database; Locking Strategies; Inserting and Retrieving Values; Localized storage and retrieval; Packing in Perl objects; Object accessor methods; Querying limitations of DBM files and hashtables; Chaining multiple values into a hash; Deleting Values; The MLDBM Module; Summary; SQL and Relational Databases; The Relational Database Methodology; Datatypes and NULL Values; Querying Data; Simple Queries; Queries and Condition Clauses; Queries over Multiple Tables; Grouping and Ordering Data. Ordering data Grouping data; Modifying Data Within Tables; Inserting Data; Using INSERT for data transfers; Deleting Data; Updating Data; Committing and Rolling Back Modifications; Creating and Destroying Tables; Programming with the DBI; DBI Architecture; Handles; Driver Handles; Database Handles; Statement Handles; Data Source Names; Connection and Disconnection; Connection; Disconnection; Error Handling; Automatic Versus Manual Error Checking; Manual error checking; Automatic error checking; Mixed error checking; Error Diagnostics; Utility Methods and Functions. Database-Specific Quote Handling Tracing DBI Execution; Neat and Tidy Formatting; Numeric Testing; Interacting with the Database; Issuing Simple Queries; Preparing SQL Statements; Constructing "on-the-fly" statements; Executing Select Statements; Fetching Data; A quick way to fetch and print; Finishing a Data Fetch Early; Deallocating Statement Handles; Executing Non-SELECT Statements; Binding Parameters to Statements; Bind Values Versus Interpolated Statements; Bind Values and Data Typing; Binding Input and Output Parameters; Binding Values Without bind_param(); Binding Output Columns. Do() Versus prepare()Atomic and Batch Fetching; Atomic Fetching; Batch Fetching; No arguments; Slice array reference argument; Slice hash reference argument; Advanced DBI; Handle Attributes and Metadata; Passing Attributes to DBI Methods; Connecting with Attributes; The Significance of Case; Common Attributes; Database Handle Attributes; Database Metadata; Statement Handle Attributes or Statement Metadata; Handling LONG/LOB Data; Inserting and Updating LONG/LOB Columns; Transactions, Locking, and Isolation; Automatic Transaction Handling; Forcing a Commit; Rolling Back Changes.