MySQL Stored Procedure Programming
Building High-Performance Web Applications in MySQL
Publisher: O'Reilly Media
Final Release Date: March 2006
Pages: 640

The implementation of stored procedures in MySQL 5.0 a hugemilestone -- one that is expected to lead to widespread enterprise adoption ofthe already extremely popular MySQL database. If you are serious aboutbuilding the web-based database applications of the future, you need toget up to speed quickly on how stored procedures work -- and how tobuild them the right way. This book, destined to be the bible of storedprocedure development, is a resource that no real MySQL programmer canafford to do without.

In the decade since MySQL burst on the scene, it has become thedominant open source database, with capabilities and performancerivaling those of commercial RDBMS offerings like Oracle and SQLServer. Along with Linux and PHP, MySQL is at the heart of millions ofapplications. And now, with support for stored procedures, functions,and triggers in MySQL 5.0, MySQL offers the programming power neededfor true enterprise use.

MySQL's new procedural language has a straightforward syntax, making iteasy to write simple programs. But it's not so easy to write secure,easily maintained, high-performance, and bug-free programs. Few in theMySQL world have substantial experience yet with stored procedures, butGuy Harrison and Steven Feuerstein have decades of combined expertise.

In MySQL Stored Procedure Programming, they putthat hard-won experience to good use. Packed with code examples and coveringeverything from language basics to application building to advancedtuning and best practices, this highly readable book is the one-stopguide to MySQL development. It consists of four major sections:

  • MySQL stored programming fundamentals -- tutorial, basicstatements, SQL in stored programs, and error handling
  • Building MySQL stored programs -- transaction handling,built-in functions, stored functions, and triggers
  • MySQL stored programs in applications -- using storedprograms with PHP, Java, Perl, Python, and .NET (C# and VB.NET)
  • Optimizing MySQL stored programs -- security, basic andadvanced SQL tuning, optimizing stored program code, and programmingbest practices

A companion web site contains many thousands of lines of code, that youcan put to use immediately.

Guy Harrison is Chief Architect of Database Solutions at Quest Softwareand a frequent speaker and writer on MySQL topics. Steven Feuerstein isthe author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyMySQL Stored Procedure Programming
 
4.0

(based on 4 reviews)

Ratings Distribution

  • 5 Stars

     

    (3)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (1)

Reviewed by 4 customers

Sort by

Displaying reviews 1-4

Back to top

 
5.0

positive review

By well written

from california

Pros

  • Accurate

Cons

    Best Uses

    • Student

    Comments about oreilly MySQL Stored Procedure Programming:

    I had problems at first with some of the example code and found that after restarting mysql server that the provided example code actually does work great!! The text is difficult for me to read in some cases as the old mysql browser is no where to be found on the web.. I sure wish it was available to download with the example code!!

     
    1.0

    not so good

    By sorry for the bad review

    from california

    Pros

      Cons

      • Difficult to understand
      • Too many errors

      Best Uses

        Comments about oreilly MySQL Stored Procedure Programming:

        I find the text to be nearly impossible to read, and have thus far found that most example code provided does not even work properly. Chapter 2 is complete garbage if you try to use any of the example code most of them fail either by sourcing them in, or by pasting them in, nor do the written text examples work, plus the written text examples are very difficult to read

        (2 of 3 customers found this review helpful)

         
        5.0

        A book to own!

        By joshSVUG

        from Undisclosed

        Comments about oreilly MySQL Stored Procedure Programming:

        I found the book to be well written and balanced. The authors did a fine job breaking out the book into four major parts:

        1) Stored Programming Fundamentals, where Stored Programs equal Procedures, Functions and Triggers.

        2) Stored Program Construction, including a discussion about transaction management and MySQL built-in functions

        3) Using Stored Programs in Application, a major boon as most other books focus on raw DML

        4) Optimizing Stored Programs, as most of your stored programs will execute DML.

        If you are going to use stored programs in your application/environment, you should buy this book.

        (9 of 13 customers found this review helpful)

         
        5.0

        MySQL Stored Procedures, In Depth

        By Dave Walz-Burkett

        from Undisclosed

        Comments about oreilly MySQL Stored Procedure Programming:

        I have been working with MySQL for several years as a database back-end for Java, Ruby and C# programming projects. After upgrading to version 5, I have been meaning to look into MySQL's support for stored procedures.

        The MySQL Stored Procedure Programming book was my first read on the subject and I found it quite useful. It covers not only stored procedures, but also functions and triggers, collectively called 'stored programs' in the book. While there are many books on MySQL, this book is dedicated to the stored programs domain and provides a lengthy treatment of the subject.

        During the introduction, the authors provide a veritable laundry list of MySQL resources including many books and websites. The basic tools for creating stored programs in MySQL are visited and help set the groundwork for a 'read, type in the example and run it' feedback loop. Throughout the book, the examples are clear and easy to follow.

        The introduction is followed by a brief tutorial, highlighting stored procedures, functions and triggers. What follows is two sections of chapters, over 200 pages in length, diving into the details of the stored procedure language fundamentals, blocks, conditional statements, iterative programming, error handling, the creation and maintenance of stored programs, transaction management, MySQL built-in functions, stored functions and triggers.

        The next section of the book is of particular value to software developers that use MySQL in their applications. Over 150 pages showing you how to use MySQL stored programs from PHP, Java, Perl, Python and .NET. The Java section even shows the basics of using stored procedures with Hibernate and Spring.

        After that, you'll be greeted with a 110 page medley of options to help you optimize your MySQL stored programs. The subject of tuning your SQL is addressed over the course of three chapters, from basic through advanced tuning topics. Additional optimization techniques such as reducing network traffic with stored programs, optimizing loops, recursion, cursors, trigger overhead and more are found in the final chapter of this section.

        The book closes out with a chapter on best practices in MySQL stored program development. MySQL Stored Procedure Programming has earned a space on the MySQL shelf of my technical library. It's a fine book that will help you take your MySQL programming experience to another level.

        Displaying reviews 1-4

        Back to top

         
        Buy 2 Get 1 Free Free Shipping Guarantee
        Buying Options
        Immediate Access - Go Digital what's this?
        Ebook: $35.99
        Formats:  DAISY, ePub, Mobi, PDF
        Print & Ebook: $49.49
        Print: $44.99