Propel 1.3 has served me very well over the past few years and I’m absolutely confident that recent projects would not have been delivered so quickly without it. However, when stuff gets a little crazy, you need to hydrate your objects using hand-crafted SQL. Building up a SQL in a variable and passing it between functions can be a nightmare to get right. Since I was already using Zend Framework, I decided to try and get Propel objects back from a Zend_Db_Select generated query. The Relational API in the upcoming 1.5 release of Propel would make this possible without the need for hacks and workarounds…
Archive for the ‘Development’ Category
Combining Zend_Db_Select and Propel 1.3
Sunday, April 18th, 2010Avoiding temporary array assignment in PHP
Thursday, September 3rd, 2009Even though I’ve been developing with PHP for a number of years, I still enjoy discovering new ways of working. Even though the stdClass object is about as basic as you can get, it’s never struck me as being a worthwhile tool. (more…)
MySQL Replication over SSL
Friday, June 19th, 2009A new project requires MySQL replication to be carried out over the internet. My first thought was to use stunnel, which I quickly implemented. This appeared to work perfectly (after some iptables configuration). However, I found out later that MySQL supports replication over SSL natively. I have made the assumption (perhaps mistakenly) that a native solution would be better (more reliable?) than a wrapped solution. Getting MySQL replicating over SSL was perhaps about 30 minutes work in total. This could’ve been cut down to about 10 minutes if it wasn’t for some documentation-related issues.
(more…)
wordpress, ahoy
Friday, June 19th, 2009For the past 7 years I have had good intentions for this domain. All I wanted was to fill it with useful stuff. Unfortunately, I was always busy playing games with work to actually put in enough time to develop a full CMS with useful tools and a nice user interface.
Along comes wordpress and very deftly puts to shame any half-baked CMS I ever came up with.
Hopefully, wordpress will bolster my rather stop-start blogging career.