Hi! My name is Brian and I am a web developer working in Nashville. Find out more?

Determining AWS Redshift Spectrum Spend

01 June 2018

I’ve enjoyed using AWS Redshift Spectrum for quick-and-easy analysis of fairly large-ish data sets using one of my favorite tools: SQL. However, as far as I could tell, there’s no way to see a breakdown of Amazon Web Services Redshift Spectrum usage for your most recent billing cycle. You can, however, pull this information from SVL_S3QUERY_SUMMARY.

Continue reading...

Using GNU Readline (Bash Shortcuts) in VS Code Terminal

30 May 2018

If you use VS Code and a Linux (bash/zsh/what-have-you) terminal, you may have noticed that some keyboard shortcuts (e.g., ctrl+p to cycle previous commands) are intercepted by VS Code. As a fairly proficient user of shell keyboard shortcuts, I found this to be pretty obnoxious. Here’s how you can fix it.

Continue reading...

Help! My Keyboard Layout Keeps Switching in Windows 10

09 May 2018

I use the Colemak layout on Windows 10 version 1803 (April 2018). I’m aware that I can switch back to a Qwerty layout by hitting Windows + Space, but occasionally my layout would switch anyway and I knew I wasn’t hitting this shortcut. It turns out that there’s another keyboard shortcut that does the same thing - either Alt+Left Shift or Ctrl+Left Shift. In my case, it was the latter. Here’s how to fix this.

Continue reading...

Coaching/Mentoring Growing Developers

09 October 2017

Let me hedge sharing this by saying: I am a terrible teacher. I lack patience, and when presented with the opportunity I will immediately jump to providing a solution rather than explaining the problem and working through it with a colleague.

Continue reading...

Mapping NAD83 Projection Maps With GeoDjango

09 March 2017

Placing shapes on a map is pretty straight-forward thanks to fantastic libraries like Leaflet.js. However, on one of my recent projects I needed to take maps that were using NAD83 projections and translate them into usable GeoJSON. Most mapping libaries used on the web use a more generic projection, WGS84, and will not support drawing shapes using an alternative projection (like NAD83).

Continue reading...