Table of Contents
Advanced DBI
Topical Topics
Wheels within Wheels
Under the hood
A picture is worth?
Setting the scene
Architecture of the DBI classes #1
Architecture of the DBI classes #2
Anatomy of a DBI handle
Method call walk-through
Watching the DBI in action
Our program for today...
Enabling Tracing
Trace level 1
Trace level 2 and above
Error Checking and Handling
The importance of error checking
Error checking - ways and means
Handling errors the smart way
Transactions
Transactions - What's it all about?
Transactions - Life Preserving
Transactions - How the DBI helps
Transactions - Example code
Transactions - Further comments
Speed Speed Speed!
Give me speed!
Partition for speed
Prepare for speed
The Best Laid Plans
Respect your server's SQL cache
Hot handles
Let the DBI cache your handles
Sling less for speed
Keep a handle on your databases
Portability
Portability in practice
The Power of the Proxy
DBD::Proxy & DBI::ProxyServer
A proxy picture
Thin clients and other buzz words
DBI for the Web
Web DBI - Connect speed
Web DBI - Too many connections
Web DBI - State-less-ness
Web DBI - Browsing pages of results
Web DBI - Concurrent editing
Web DBI - Tips for the novice
Handling LONG/BLOB data
DBI security tainting
Flexing the Multiplex
DBD::Multiplex
Reference Materials
The end.
|