Here is the presentation material I used for my "Testing PHP/MySQL Applications with PHPUnit/DbUnit" presentation at the MySQL Conference in Santa Clara, CA today.
A PDF version of the presentation is available here, notes by Joe Stump (Digg.com) are here. Thanks to Sheeri Kritzer Cabral there is a video of the presentation.
Testing PHP/MySQL Applications with PHPUnit/DbUnitI am looking forward to attending this conference, catching up with the recent improvements to MySQL, and meeting with my friends from the MySQL community.
In the last decade, PHP has developed from a niche language for adding dynamic functionality to small websites to a powerful tool making strong inroads into large-scale Web systems. Critical business logic like this needs to work correctly. But how do you ensure that it does? You test it, of course.
To make code testing viable, good tool support is needed. This is where PHPUnit comes into play. It is a member of the xUnit family of testing frameworks and provides both a framework that makes the writing of tests easy as well as the functionality to easily run the tests and analyse their results.
This session introduces the audience to PHPUnit’s DbUnit extension that makes the writing of tests that interact with databases more convenient and easier.
Testing PHP/MySQL Applications with PHPUnit/DbUnitThe scond proposal takes a piece of code for data partitioning that I wrote a long time ago for phpOpenTracker and relates it to MySQL 5.1's native support for this concept:
In the last decade, PHP has developed from a niche language for adding dynamic functionality to small websites to a powerful tool making strong inroads into large-scale Web systems. Critical business logic like this needs to work correctly. But how do you ensure that it does? You test it, of course.
To make code testing viable, good tool support is needed. This is where PHPUnit comes into play. It is a member of the xUnit family of testing frameworks and provides both a framework that makes the writing of tests easy as well as the functionality to easily run the tests and analyse their results.
This session introduces the audience to PHPUnit's DbUnit extension that makes the writing of tests that interact with databases more convenient and easier.
(Custom) Data Partitioning - Then & NowIf you are interested in these topics, share your opinion in the comments. Thanks!
Partitioning allows you to distribute portions of individual tables across a filesystem according to rules which you can set largely as needed. In effect, different portions of a table are stored as separate tables in different locations.
Some queries can be greatly optimized in virtue of the fact that data satisfying a given WHERE clause can be stored only on one or more partitions, thereby excluding any remaining partitions from the search.
Starting with version 5.1, MySQL natively supports partitioning. But partioning can even be implemented with older versions using MyISAM Merge Tables and custom application logic. This session will first present a small PHP library that rewrites SQL queries to a merge table to use as few individual tables as possible before it will give an overview of MySQL 5.1's native partioning implementation.
