Portfolio: QueryBuilder

The QueryBuilder is an application that allows non-technical staff to build segmented lists for mailing or reports. It is driven by a meta-database that abstracts the structures of Smarter Living's sites' databases and the relationships between their tables. A command-line interface is used by the Smarter Living Mailer application to generate list results on an as-needed basis. For complex lists that may take a long time to run, the QueryBuilder allows users to pregenerate lists and give the result tables a time-to-live, in which case the Mailer will simply use any non-expired results without having to re-run the lists. I was solely responsible for the development of the application, and remain the primary developer.