samuellevy.com

BlogFile is a simple, very light weight blog system which is entirely housed in a single PHP file. It provides basic templating, a simple markdown format, simple comment spam protection, an automatic karma system, and the ability to add both blog posts and static pages.

Date: Released on May 7, 2012
Time: Development ~30 hours
Technology: PHP/MySQL
Licence: WTFPL
Github URL: https://github.com/samlev/blogfile

MICO (formerly Mantis) is a simple application for taking down and tracking phone calls. I designed it out of a need for a simple way to take down phone calls at work. Using email and instant messaging made following up calls difficult, but using a full blown task tracker lacked flexibility. Mantis is designed to make taking a call as painless as possible, while giving the users the ability to easily track and follow up on calls.

Date: Started September 2010, First Release on October 31, 2010
Time: Development ~100-150 hours
Technology: ExtJS/Sencha user interface, talking to a PHP/MySQL server side API.
Licence: GNU Lesser General Public Licence version 3.0
Download: Home page

A co-worker asked me a question about finding and deleting records in a link table which referenced records in either table which no longer existed.

My quick response was to provide him with a simple exclusion query:

SELECT  * 
FROM `Brand_Contacts` 
LEFT JOIN `Brands` ON `Brands`.`id` =  `Brand_Contacts`.`brand_id` 
LEFT JOIN `Contacts` ON `Contacts`.`id` =  `Brand_Contacts`.`contact_id` 
WHERE `Brands`.`id` IS  NULL 
OR `Contacts`.`id` IS  NULL

Yesterday I attended day one of the 2009 Open Source Developer's Conference. There was good company, some great talks, and a nice setting. I'm a little sad that I can't attend today and tomorrow, also, but I'm back to work today.