MySQL Stored Procedures Programming
By: Guy Harrison with Steven Feuerstein
Published by O'Reilly
Developers who have worked with SQL Server and Oracle know the power of stored procedures. Their absence in MySQL has been a brick wall. With the release of MySQL 5.0, that last hurdle has been crossed: custom functions, triggers and stored procedures are now at your fingertips. What you need is a roadmap. MySQL's strength has been its large set of handy built-in functions. How to use them is covered in the new book from O'Reilly: MySQL Stored Procedures Programming by Guy Harrison with Steven Feuerstein. By : Mike DeWolfe The book begins with the standard fare: the evolution of MySQL, how it differs from the other engines and how it's a good engine. Then it jumps into the introduction to stored procedures. Stored procedures can be a learning curve. There is a divide between application code and database code: applications execute instructions including loops, conditions, variables and iterations. Database calls work to gather sets—lists-- filtered through conditions and joins. Stored procedures blur that line: they gather sets and execute instructions. That pops the top off what you can do: what would take a lot of back-and-forth between an application and its database can now be performed solely by the database. Throughout the remainder of the first six chapters on fundamentals, this book takes you school. It discusses block, iteration and conditional statements; using SQL inside of stored procedures; and some all-important material on error handling. The second section revolves around program construction: how to perform transactions; how to build functions and triggers. This is all good stuff, especially for those who are leapfrogging from MySQL 3+ to MySQL 5 wherein MySQL 4 InnoDB makes transactions possible. Section Three gets into the practicalities of using stored procedures. There are examples of how to integrate with PHP, Java, Perl, Python and C#/.NET. This stuff is great. While a book that solely focused on one language would have had deeper coverage, this book is likely to cater to most of the developers out there. Unfortunately, there is a bias displayed in that Python gets a complete application example and the others languages do not. With that said, many of the code examples throughout the book are rendered in PHP, Java and C#, so there is an honest effort to be cosmopolitian in code inclusion. Section Four, "Optimizing Stored Programs" is the money shot: program security; coding tuning; optimizing code; and best practices. I've known that IN statements are the sloppy cousins of JOINs. The authors show performance graphs to spell that out in argument stopping clarity. Given the quality of these last 160 pages, if you buy this book solely for that section, you will get your money's worth. How is it that so many books have come out and there has been so little coverage on the difference between what you can do and what you should do? This book is so good that I would argue there needs to be space on your MySQL shelf even if you aren't going to write stored procedures. As I go into my next project with a MySQL 5.0 engine in use, I am happy that this book exists. | DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
More Database Book Reviews Articles
More By Codewalkers  developerWorks - FREE Tools!
|
Learn field-tested SOA principles, methodology, technology and implementation from the global SOA market leader - in a new e-book by an IBM SOA expert. Written by IBM Certified SOA Solution Designer Bobby Woolf, "Exploring IBM SOA Technology & Practice" is the ultimate insider's guide to SOA - a PDF e-book packed cover to cover with IBM's specific advice on how to make your SOA implementation a success.
FREE! Go There Now!
| | | |
Learn how you can extend modern application lifecycle management to IBM System z through the IBM Rational Software Delivery Platform (SDP). The Did you say mainframe? e-kit includes podcasts, webcasts, tutorials, white and red papers, demos, and articles designed to help ease the challenges of modernizing your enterprise. This complimentary kit for mainframe developers is a practical, how-to guide for making the most of an existing development environment, including the skills and infrastructure already in place at an established enterprise.
FREE! Go There Now!
| | | |
As organizations have grown increasingly dependent on online software, the risk of malicious attacks has also become far more serious. Fortunately, well-governed organizations can protect their Web applications by injecting vulnerability assessments and ethical hacks into their software development and delivery processes. This paper describes 12 of the most common hacker attacks and provides basic rules that you can follow to help create more hack-resistant Web applications.
FREE! Go There Now!
| | | |
Learn how to do more with your reusable assets with the free Rational Asset Manager eKit. The eKit includes demos on how Rational Asset Manager tracks and audits your assets in order to utilize them for reuse. Plus you’ll find white papers and a Webcast that discuss the challenges of a Service Oriented Architecture and how Rational Asset Manager can provide quick and effective solutions.
FREE! Go There Now!
| | | |
Get a free trial download of the latest version of IBM Rational Performance Tester V7.0.1, a load and performance testing solution for teams concerned about the scalability of their Web-based applications. Combining multiple ease-of-use features with granular detail, Rational Performance Tester simplifies the test-creation, load-generation and data-collection processes that help teams ensure the ability of their applications to accommodate required user loads.
FREE! Go There Now!
| | | |
Regression testing -- in which code is thoroughly tested to ensure that changes have not produced unexpected results -- is an important part of any development process. But many testing environments neglect the terminal-based applications that still form the backbone of many industries. In this tutorial, you'll learn how the Rational Functional Tester Extension for Terminal-Based Applications works with other Rational Functional Tester to help test terminal-based applications quickly and easily.
FREE! Go There Now!
| | | |
IBM Enterprise Modernization solutions help organizations evolve core IT systems towards modern architectures and technologies—reducing the burden of maintenance and freeing up resources to develop new business requirements and capabilities. With the IBM Enterprise Modernization Sandbox for System z you can evaluate IBM Enterprise Modernization solutions focused on five key areas: Assets, Architectures, Skills, Processes and Infrastructures, and Investment. Each solution is based upon real customer experiences and offers a proven path to get you started with your modernization projects.
FREE! Go There Now!
| | | |
Get a free trial download of the latest version of IBM Rational Method Composer V7.2 which helps you deliver customized yet consistent process guidance to your project teams and IT organization, and includes the latest version of IBM Rational Unified Process (RUP), which has provided process guidance to teams since 1996.
FREE! Go There Now!
| | | |
Download the IBM WebSphere Portal V6.1 beta code and learn more about the rich features and enhancements in IBM WebSphere Portal V6.1. WebSphere Portal provides a composite application or business mashup framework and the advanced tooling needed to build flexible, SOA-based solutions, and scalability to meet the needs of any size organization.
FREE! Go There Now!
| | | |
As organizations integrate software into every aspect of business, they are constantly pressured to deliver faster, better, and cheaper results. Unfortunately, a “dis-integrated” software delivery approach reduces returns while increasing costs. This IBM Rational White Paper shows how Integrated Requirements Management aligns organizations around maximizing value and keeping pace with change.
FREE! Go There Now!
| | | |
All FREE IBM® developerWorks Tools!
| |
/ 5 
