Subscribe to the feed
Follow me on Twitter
Preface: This article was written mostly half a year ago, as I was wrapping up an intense period of freelancing and sub-contracting. It is less relevant for me now, as I'm now an equal partner in a small web firm and my freelancing days are beyond me - however, I thought it might be a good read.
Selecting closest values in MySQL
MySQL • Web development February 2nd, 2009Sometimes the need arises to select several values in the vicinity of a certain value, preferably ordered by proximity. The values might be dates, zip-codes or any other meaningfully ordered values that can be represented as numerical values. How can we pull this off in MySQL?
Read the rest of this entry »
Zend Framework certification
PHP • Web development • techfounder December 30th, 2008Today I took and passed the Zend Framework certification exam. A possible project involving Zend might be materializing in the near future, and this was a requirement from one of my contractors (OpenIT). Being that they offered to sponsor the cost, I had no reason not take it.
As I found no concrete online information on the test (and the guide link from Zend doesn't work), I might as well elaborate a little for the benefit of future test takers reading this blog -
Read the rest of this entry »
If you like t-shirts, check this out
Interesting December 11th, 2008My good friend and Octabox co-founder, Tal Zubalsky, is a graphic designer by trade. He is also an avid t-shirts fan and therefor a threadless fan (who isn't? 
).
He has recently decided to have a go at a t-shirt design himself, and came up with this brilliant concept which I think is pretty awesome. If you like t-shirts and have a threadless account, please take the time to have a look and vote for it (I'd really like to see it printed 
).
OO PHP templating
PHP • Web development November 18th, 2008Templating is a common technique for separation of concerns in applications - separating presentational logic from domain (or business) logic. This kind of separation promotes higher maintainability and a better chance to reuse presentational code (by encapsulating it in templates), the kind of traits we would all love to have in our code base.
Read the rest of this entry »