MySQL Stored Procedure Programming Building High-Performance Web Applications in MySQL

Name: MySQL Stored Procedure Programming Building High-Performance Web Applications in MySQL
Price: 4.86 USD
Availability: InStock
ISBN: 9780596100896

ISBN-10: 0596100892

ISBN-13: 9780596100896

Edition: 2006

Authors: Guy Harrison, Steven Feuerstein

List price: $44.99

30 day, 100% satisfaction guarantee!

Buy new: $33.05

Marketplace

4 new & used from $4.86

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

The implementation of stored procedures in MySQL 5.0 a huge milestone -- one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work -- and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without. In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings…

Book details

List price: $44.99
Copyright year: 2006
Publisher: O'Reilly Media, Incorporated
Publication date: 4/7/2006
Binding: Paperback
Pages: 502
Size: 7.68" wide x 9.09" long x 1.42" tall
Weight: 1.936

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.



Preface



Stored Programming Fundamentals



Introduction to MySQL Stored Programs


What Is a Stored Program?


A Quick Tour


Resources for Developers Using Stored Programs


Some Words of Advice for Developers


Conclusion



MySQL Stored Programming Tutorial


What You Will Need


Our First Stored Procedure


Variables


Parameters


Conditional Execution


Loops


Dealing with Errors


Interacting with the Database


Calling Stored Programs from Stored Programs


Putting It All Together


Stored Functions


Triggers


Calling a Stored Procedure from PHP


Conclusion



Language Fundamentals


Variables, Literals, Parameters, and Comments


Operators


Expressions


Built-in Functions


Data Types


MySQL 5 "Strict" Mode


Conclusion



Blocks, Conditional Statements, and Iterative Programming


Block Structure of Stored Programs


Conditional Control


Iterative Processing with Loops


Conclusion



Using SQL in Stored Programming


Using Non-Select SQL in Stored Programs


Using Select Statements with an Into Clause


Creating and Using Cursors


Using Unbounded Select Statements


Performing Dynamic SQL with Prepared Statements


Handling SQL Errors: A Preview


Conclusion



Error Handling


Introduction to Error Handling


Condition Handlers


Named Conditions


Missing SQL:2003 Features


Putting It All Together


Handling Stored Program Errors in the Calling Application


Conclusion



Stored Program Construction



Creating and Maintaining Stored Programs


Creating Stored Programs


Editing an Existing Stored Program


SQL Statements for Managing Stored Programs


Getting Information About Stored Programs


Conclusion



Transaction Management


Transactional Support in MySQL


Defining a Transaction


Working with Savepoints


Transactions and Locks


Transaction Design Guidelines


Conclusion



MySQL Built-in Functions


String Functions


Numeric Functions


Date and Time Functions


Other Functions


Conclusion



Stored Functions


Creating Stored Functions


SQL Statements in Stored Functions


Calling Stored Functions


Using Stored Functions in SQL


Conclusion



Triggers


Creating Triggers


Using Triggers


Trigger Overhead


Conclusion



Using MySQL Stored Programs in Applications



Using MySQL Stored Programs in Applications


The Pros and Cons of Stored Programs in Modern Applications


Advantages of Stored Programs


Disadvantages of Stored Programs


Calling Stored Programs from Application Code


Conclusion



Using MySQL Stored Programs with PHP


Options for Using MySQL with PHP


Using PHP with the mysqli Extension


Using MySQL with PHP Data Objects


Conclusion



Using MySQL Stored Programs with Java


Review of JDBC Basics


Using Stored Programs in JDBC


Stored Programs and J2EE Applications


Using Stored Procedures with Hibernate


Using Stored Procedures with Spring


Conclusion



Using MySQL Stored Programs with Perl


Review of Perl DBD::mysql Basics


Executing Stored Programs with DBD::mysql


Conclusion



Using MySQL Stored Programs with Python


Installing the MySQLdb Extension


MySQLdb Basics


Using Stored Programs with MySQLdb


A Complete Example


Conclusion



Using MySQL Stored Programs with .NET


Review of ADO.NET Basics


Using Stored Programs in ADO.NET


Using Stored Programs in ASP.NET


Conclusion



Optimizing Stored Programs



Stored Program Security


Permissions Required for Stored Programs


Execution Mode Options for Stored Programs


Stored Programs and Code Injection


Conclusion



Tuning Stored Programs and Their SQL


Why SQL Tuning Is So Important


How MySQL Processes SQL


SQL Tuning Statements and Practices


About the Upcoming Examples


Conclusion



Basic SQL Tuning


Tuning Table Access


Tuning Joins


Conclusion



Advanced SQL Tuning


Tuning Subqueries


Tuning "Anti-Joins" Using Subqueries


Tuning Subqueries in the From Clause


Tuning Order and Group By


Tuning DML (Insert, Update, Delete)


Conclusion



Optimizing Stored Program Code


Performance Characteristics of Stored Programs


How Fast Is the Stored Program Language?


Reducing Network Traffic with Stored Programs


Stored Programs as an Alternative to Expensive SQL


Optimizing Loops


If and Case Statements


Recursion


Cursors


Trigger Overhead


Conclusion



Best Practices in MySQL Stored Program Development


The Development Process


Coding Style and Conventions


Variables


Conditional Logic


Loop Processing


Exception Handling


SQL in Stored Programs


Dynamic SQL


Program Construction


Performance


Conclusion


Index