Follow Us on Twitter
Facebook Page
LinkedIn Group
Sign up for the Bulletin
MySQL 2010 Video on YouTube
MySQLConf RSS Feed
MySQLConf Schedule
Speaker Slides & Videos
MySQLConf Attendee Directory
Engineering MySQL Subroutines for Integrity
Integrating MySQL subroutines starts with good database design. Good database design requires understanding the business problem and technology stack possibilities. Web 2.0 and AJAX raise the ante with more complex transaction control problems. This presentation addresses how to create MySQL stored programs to solve these problems.
Topics Include:
Merits of functions over procedures Merits of definer and invoker rights Merits of MySQL security-layers with stored programs Simplification of PHP when using stored programs Transaction control provided by stored programs Approaches for page and page-fragment refreshes
Michael McLaughlin
BYU - Idaho
I teach database technology and systems analysis in the Computer Information Technology Department at BYU – Idaho. I’ve worked as an application developer, DBA, and database designer for over twenty-five years with Oracle, MySQL, and DB2 databases. I’ve authored or co-authored books on PHP and Oracle programming.
Comments on this page are now closed.
Sponsorship Opportunities
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com
Media Partners Opportunities
For media partnerships, contact mediapartners@ oreilly.com
Press & Media
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
O'Reilly MySQL Conference Bulletin
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
Contact Us
View a complete list of O'Reilly MySQL Conference Contacts
©2011, O'Reilly Media, Inc.
(800) 889-8969 or (707) 827-7019
Monday-Friday 7:30am-5pm PT
All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.
conf-webmaster@oreilly.com
Comments
This presentation covered a lot of ground, and missed depth. It seemed like the presenter should have assumed a level of understanding of stored procedures by the attendees, and given specific examples of how to improve those. For example, covering JavaScript and CSS was mostly a waste of time.