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.
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
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.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at email@example.com
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).
View a complete list of O'Reilly MySQL Conference Contacts