The Latest

New Tool: SQL to CSV

I write a lot of SQL queries at work and, quite regularly, find myself exporting them to CSV files. PostgreSQL’s command line client, psql, has a command to handle this task – \COPY – that you can use to output the results of a SELECT statement to a local CSV file. It looks like this:

\COPY (SELECT * FROM foo) TO '~/output.csv' CSV

That works well, but it’s tedious to constantly convert commented, indented SQL into a one-line COPY command. Sure, I could create a macro in my text editor to handle this. Since I’m probably not the only person annoyed by this though, I created a simple tool anyone can use to automate the conversion: SQL to CSV. Give it a try!

Screenshot of SQL to CSV tool

Desk Hacks

My wife and I have, between us, four laptops, two phones, and a number of other USB accessories. It’s hard to keep them all charged, and traditional power strips located on the floor are inconvenient. There was definitely room for improvement. Here’s what I came up with! More…

Onboarding New Hires

Words every onboarder (and team member) should live by:

Treat every question as an opportunity for a conversation.

Cheers to http://katrinaeg.com/ for the delightful discussion that produced this bit of wisdom.

Certbot Renewal Script

Now on GitHub: certbot-renew, my super-simple bash script for renewing Let’s Encrypt certs.

Polymer Binding Cheat Sheet

You shouldn’t have to read so many words in Polymer’s docs to figure out how to get the binding you want. Time is precious. There’s code to review. Your hair is turning gray. Use my cheat sheet instead!

More…