Random thoughts of a self-professed nerd.

This blog is largely an excuse for me to stretch long-unused writing muscles and to explore ideas I find interesting. There's likely a lot of technology and internet related content, and I'm sure there will be food-related musings as well.

Justin Fargione

DBWhere clause builder

One of the things that's always bugged me about designing good cross-platform SQL queries is the difficulty in constructing complicated 'where' clauses. Things like nested logic (AND (a = 2 OR b = 3)), column comparisons (whenadded != lastupdated), and function calls (whenadded > dateAdd(d…

Continue reading...
Justin Fargione

Google application server - it's about time

When Amazon began reselling their backbone as web services, another barrier to the internet collapsed. Much like the introduction of the LAMP stack heralded the arrival of commoditized web applications, Amazon's service heralded the commoditization of large-scale application deployment. A budding web company no longer…

Continue reading...
Justin Fargione

Layman's analogy for version control

One of my clients recently overhauled their talent pool. Their staff went from two freelancers with very general development skills to one generalist (me), two php developers, and a CSS/HTML developer. System administration was understandably not in the three new developers' bags of tricks, and…

Continue reading...