Currently viewing the category: "MySQL"

Simply scale with Nginx, Memcached, PHP-FPM and APC

By On February 1, 2013 · 4 Comments

When I started programming in PHP, my hosting setup involved a cPanel installation with Apache and MySQL. This has been the de facto standard for many PHP developers and for the most part I don’t think any of that needs to change. I simply never had to deal with websites that got more than 10,000 [...]

Continue Reading →

Executing raw MySQL queries in Lithium

By On October 25, 2011 · 9 Comments

Note: see comments below for a better solution

I’ve been working on a project that is using the MySql adapter for Lithium and I keep running into roadblocks when it comes to using some MySQL specific features. Unfortunately the adapter for MySQL that comes with Lithium doesn’t quite handle all of the features [...]

Continue Reading →
phactory-transparent

Unit Testing Models with Phactory and PHPUnit

By On June 12, 2011 · Leave a Comment

PHPUnit, although exceptional in so many aspects, is somewhat lacking when it comes to database testing. Testing models in with PHPUnit usually requires you to set up cumbersome XML files for fixtures and your are stuck with them for the entire testcase. I am going to show you how to [...]

Continue Reading →

You can’t do a natural sort on a string column in MySQL

By On December 14, 2010 · Leave a Comment

Recently a question popped up over on the CakePHP google group where someone had a problem sorting on a column of “registration numbers”. This was his table sorted order by “Reg No ASC“:

-

ID Name Reg No 1 Product A 1 2 Product B 123 3 Product C 2

-
1, [...]

Continue Reading →