Stored programs can be used for a variety of purposes, including the implementation of utility routines for MySQL DBAs and developers. However, the most important use of stored programs is within applications, as we describe in this part of the book. Stored programs allow us to move some of our application code into the database server itself; if we do this wisely, we may benefit from applications that are more secure, efficient, and maintainable. In Chapter 12 we consider the merits of, and best practices for, using stored programs inside modern—typically web-based—applications. In the subsequent chapters, Chapters 13 through 17, we show how to use stored procedures and functions from within the development languages most commonly used in conjunction with MySQL: PHP, Java, Perl, Python, and .NET languages such as C# and VB.NET.
Chapter 12, Using MySQL Stored Programs in Applications
Chapter 13, Using MySQL Stored Programs with PHP
Chapter 14, Using MySQL Stored Programs with Java
Chapter 15, Using MySQL Stored Programs with Perl
Chapter 16, Using MySQL Stored Programs with Python
Chapter 17, Using MySQL Stored Programs with .NET