Make your database work for you
Presented by Beth Skwarecki
Abstract
Some Perl programmers are SQL-phobic, and wrap database access so they don't have to look at it. But many of the common ways of doing this break the SQL up so it's hard to read, hard to maintain, and can't be optimized - and worse, they duplicate (sometimes badly) things the database can do itself, such as sorting rows, joining tables, or constraining data values.
In this talk we'll learn how to let the database do the work it's good at. As a result, your programs will run faster, they'll be easier to maintain and debug, and many of your grunt-work tasks will be done by the database no matter what program accesses it. (We'll accomplish this, in part, by triggers written in Perl that live in the database. Isn't that cool?)
We'll cover some common myths about getting down-and-dirty with the database (for example, that similar SQL must be repeated throughout the code) and bust them (for example, by making good use of views).
Then, after a tour of database features you never knew existed (and can't possibly live without) we'll look at a perl program that builds database searches by intersecting SQL sub-queries. This approach has advantages in both performance and code maintainability.
Details
- Time
- 9:45 AM
- Length
- 45 minutes
- Room
- Socialtext