Beyond the basics of today's ORM-based approaches, this discusses object-oriented querying in PHP, allowing developers to execute complex MySQL queries without needing to write a single line of SQL.
Your first MySQL Plugin or UDF extension is only 10 minutes away using this code generator. Focus on the actual functionality and let the generator take care of glue code and build infrastructure.
A popular and lighthearted session in quiz format. Fun and educational, a broad range of "what not to do" is explored, taking examples from the scary real world.
The more popular a web site gets, the more power it takes to run it. Brian Moon will share the journey of their web site from one server, to the cluster they run today, including how they have used MySQL.
How to extend your LAMP stack for rapid web application development by using an integrated environment of various frameworks (Zend for PHP, YUI for Ajax), Smarty for templating, and other libraries.
Phorum is the message board software used by MySQL. One reason they chose Phorum was because of its speed. We have to use some tricks and fancy SQL to make this happen. Learn how.
A hands-on discussion of the MySQL Workbench tool showing the benefits for Ruby/Python/PHP, as well as .NET/Java developers. Efficient database schema design and maintenance has never been so easy.
Flickr implemented a real-time collection of referrers to Photos, streams, sets and collections. MySQL myISAM/INNODB, curl, Java are the only component used in the setup and it scales linearly. This talk is about building a model for capacity planning, scaling for triple the request rate, and scaling linearly for an intensive application.
Services Oriented Architecture offers a number of benefits over the standard paradigm including parallel asynchronous request, decoupling your code from your data, and abstracting scalability.
PHP/MySQL applications are used more and more to perform enterprise-critical tasks. The audience will learn how to efficiently test PHP/MySQL applications with PHPUnit and its DbUnit extension.
Preserving backward compatibility often prevents projects from benefitting from new MySQL features. Learn how to write elegant PHP code and SQL protected against the future as well as the past.
During this tutorial, attendees will get a detailed introduction into the MySQL UDF interface and will learn to write and deploy their own UDFs for both Windows and Linux platforms.