phpDesigner 2008

Wednesday, June 4th, 2008

It seems that my endless search for the ideal PHP IDE has finally…er…ended. phpDesigner 2008 is the most promising environment I’ve seen and even though I’ve only just started using it, it’s already seen Zend Studio Pro and the treacle-like Zend Studio Eclipse confined to the recycle bin.

(more…)

When to use Stored Procedures

Sunday, May 18th, 2008

Version 5 of MySQL added Stored Procedures and, as is often the case when you’ve been using earlier versions, I didn’t notice at all, until a client asked whether the site I’m building for him should be using this technique for interacting with a database. In this case, the answer is a resounding no since it would add an unnecessary level of complexity to a site in which the MySQL queries rarely involve more than one table at a time.

So, when should they be used?

(more…)