Latest Posts

  • An Inside Look at Working for YNAB

    I started at You Need a Budget (YNAB) about a year ago as a software developer. I was super excited about joining the YNAB team, had a bunch of enthusiasm built up and and was very curious to see what things looked like on the inside. Why? Well, because from the outside, things looked really good. From a company, busin... Read More

  • Converting WAV to MP3 for a Podcast

    I maintain a podcast and frequently have to convert WAV files to MP3 before publishing a new episode. I use the LAME MP3 Encoder for conversion and and have tried quite a few options to get the size/quality balance just right and have found a set of options that I am quite happy with. Read More

  • 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

More Posts