Talks

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