O'Reilly Open Source Convention.
Books Safari Bookshelf Conferences O'Reilly Network
   


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


O'Reilly Open Source Convention
Hornbill.

Session

Making MySQL Do More
Brian Aker, MySQL AB

Track: MySQL
Date: Wednesday, July 09
Time: 11:30am - 12:15pm
Location: Salon B

Once we drop the notion that some things should never be done inside of a database, we need to look at what can be done and what limits your environment may place upon you and how to overcome them. Think of the often-considered heresy of storing images in your database. Would it be worth it if you could have the database resize or convert the images on the fly as your needs warranted? What if this shrunk the size of your client? Ever wondered if you could keep URL links in your database and have it fetch and update those pages on a single query? Would it be useful to have your database respond directly in XML from time to time? Why not use common scripting languages like Perl and PHP to rewrite and extend your queries? This talk will cover these questions and the following topics:

  • How the UDF API works
  • How to make use of languages like Perl and PHP inside of your database
  • Looking at your blob data through the eyes of a datablade
  • Having your database execute shell scripts for you
  • Strategies for creating globally (across multiple databases) unique identifiers
  • Extending full text queries
  • Turning single queries into complete applications


    Download presentation file


  • O'Reilly Home | Privacy Policy

    © 2003, O'Reilly Media, Inc.