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.