DBI and DBD from an end-users perspective - Tux
Wednesday, The Camel Room, 1100, 90 mins
Why you need portable DBI scripts, and how to write them.
- DBI basics
- Connections, selections, updates
- DBI interaction with Perl scripts
- Database data and Perl hashes
- Fetching methods
- DBD differences
- Unify
- Oracle
- PostgreSQL
- MySQL
- Incompatabilities
- Table and Field names
- Quotation
- NULL values and blanks
- Encoding and Character sets
- Triggers and Store Procedures
- Transactions and AutoCommit
- Performance
- Fetch methods
- Miscelaneous
- Modularity
- PROCURA::DBD
- a generic singleton
- PROCURA::DBD_create
- a DDD interface
- Scripts
- vol
- describe
- qs & qs0
- dbload