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.