Preserving leading zeros when writing CSV files for Excel

How to write a CSV such that Excel doesn't drop leading zeros where they're needed. Postal codes are a great example of when those leading zeros contain valuable information.

Read

Software Reliability

A quick post on defining what reliability means in terms of software development.

Read

Make Git Forget About Files Previously Tracked

Useful for adding a gitignore file later into a project.

Read

Refactoring: Parameter Objects

Introducing parameter objects into your code.

Read

Compiling GO for Synology NAS

Compiling GO binaries for the synology platform.

Read

I Created an Arc Reactor!

...And then my wife took it.

Read

New Year, New Blog

Details about undergoing a facelift.

Read

Building A Custom Music Box (Part 1)

My wife loves the movie Pan's Labyrinth. In that movie, there's a lullaby and she's mentioned to me several times that she has always wanted a music box that plays that lullaby.

Read

Automating the Boring Search for an iPhone X

T-Mobile didn't let me pre-order the new iPhone. So I had to write a script to notify me when there was stock nearby.

Read

How I Used Python and Boto3 to Modify CSV's in AWS S3

Using Python to write to CSV files stored in S3. Particularly to write CSV headers to queries unloaded from Redshift (before the header option).

Read

Automating Christmas with Particle, Docker, and Siri

This was an incredibly fun project to do and gave me an excuse to not only put our Christmas tree up well before December, but to also keep it well into January. I’m not entirely sure how much this would cost if you had to buy each part separately. I’ve had this hobby for quite some time now and have dedicated a whole desk drawer to little sensors, micro-controllers, led’s and resistors. Most of those parts live inside little cubbies in something that resembles a cheap tackle-box.

Read

Choices for Choices in Django CharFields

You have multiple choices when implementing a multiple choice field in Django.

Read