Who Should Attend: Intermediate to advanced Perl programmers with understanding of the DBI and a desire to know more.

Learn how the DBI works and how to get the best out of it, including how to maximize speed, safety, reliability and portability.

Course Outline:

• Wheels within wheels: The architecture and how to see inside it using trace
• Error checking and recovery: The importance of checking and the virtues of eval
• Speed, speed, speed: what helps, what doesn't; database design, application partitioning, network latency, stored procedures, caching etc
• Safety and concurrency: locking and transactions
• Database portability and handling multiple databases, with comparison of driver and database behavior and capabilities
• DBI for the Web: From CGI to Apache mod_perl; the lack of state; security
• The power of the proxy
• Handling LONGs
• Dealing with common installation problems
• Outline of implementing a DBD driver in Perl or XS