O'Reilly Open Source Convention
oreilly.comO'Reilly Network
Conferences International Safari: Books Online

Arrow Home
Arrow Registration
Arrow Speakers
Arrow Keynotes
Arrow Tutorials
Arrow Sessions
Arrow At-a-Glance
Arrow BOFs
Arrow Events
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Press
Arrow Mail List
Kids World

From the Frontiers of Research to the Heart of the Enterprise
O'Reilly Open Source Convention
Sheraton San Diego Hotel and Marina
July 22-26, 2002 -- San Diego, CA



Advanced DBI
Tim Bunce, Data Plan Services

Track: Perl
Date: Tuesday, July 23
Time: 8:45am - 12:15pm
Location: Harbor Island III

Who Should Attend: Intermediate to advanced Perl programmers with an 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. This year Tim has updated his popular tutorial to include more of the new DBI features added since version 1.14.

Course Outline:

  • Speed, speed, speed: what helps, what doesn't; database design, application partitioning, network latency, stored procedures, caching etc.
  • Handling handles and binding values; your TYPE or mine?
  • Error checking, recovery, and transactions; PrintError, RaiseError, and HandleError; the importance of checking and the virtues of eval. How transactions and RaiseError work together.
  • Wheels within wheels: The architecture and how to see inside it using trace.
  • DBI for the Web: Connect speed, state-less-ness, browsing pages of results, concurrent editing and optimistic locking, security tainting.
  • Handling LONG/BLOB data.
  • Database and Platform Portability: Database and driver metadata, SQL dialects.
  • DBD::Proxy and DBD::Multiplex.
  • What's new (since the book) and what's planned.
  • DBI::PurePerl

oreilly.com Home | O'Reilly Bookstores | How to Order | O'Reilly Contacts
International | About O'Reilly | Affiliated Companies | Privacy Policy

© 2001, O'Reilly Media, Inc.