Subscribe to the feed
Follow me on Twitter
Specifications are an integral part of any web project (or any software project for that matter). Writing good specifications will improve the probability of success for a given project by a great deal.
(more...)
Archive for the ‘Web development’ Category
Writing specifications for web applications
Friday, July 3rd, 2009Multiple row operations in MySQL / PHP
Thursday, May 14th, 2009Multiple row operations are in common use in a normalized application databases as one database entity is often linked to multiple sub-entities (for example a user and his tags). By row operations I'm referring to write queries, namely UPDATE and INSERT queries (DELETE is less interesting so I'll leave it out for now).
Too often I've seen such queries ran in long loops one at a time, which is very bad for performance (as I will show here) and sometimes equally bad for integrity (if the process is interrupted). So what are the alternatives?
(more...)
Lionite relaunched! time to kick back… and work some more
Thursday, April 30th, 2009For a long time, we've been feverishly developing beautiful sites for others while our own site was left to rot in mediocrity for lack of time. Now, finally, we've taken the time to properly redesign and relaunch our portfolio website, at http://www.lionite.com:
Conveying value to clients
Sunday, April 5th, 2009Preface: 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.