Latest Posts

  • Generating Date Ranges in SQLite

    SQLite supports Recursive Common Table Expressions which is very handy sometimes. Although you have to keep an eye on performance, they can help you accomplish something that would otherwise be non-trival. Something like generating a range of dates or months, as I recently had to do. Read More

  • Performance Tuning Queries in PostgreSQL

    Database performance tuning: developers usually either love it or loathe. I happen to be one that enjoys it and want to share some of the techniques I’ve been using lately to tune poor performing queries in PostgreSQL. This is not meant to be exhausive but more of a primer for those just getting their feet wet with tuning. Read More

  • Ansible Module for Modifying JSON

    I just recently finished a side project in Node.js and decided to use Ansible for provisioning a Digital Ocean server and deploying the app to it. As part of the deploy playbook, I needed a way to set production specific config values in a JSON file. There isn’t a native way to do this in Ansible (that I know of at least)... Read More

  • Posting To Facebook with Rails

    Awhile back I developed a Rails app I call “veritas” (GitHub) that is intended to help organize community around a group of people. It was primarily developed for the class my wife and I attend at our church. It allows us to keep a contact list of members with photos, a calendar of events, signups management (class breakfast, baby meals, etc.), sending of SMS messages, and manages the publi... Read More

  • Complexity Creep

    “Controlling complexity is the essence of computer programming.” — Brian Kernighan
    Read More

More Posts