Blog Archives

MySQL: Group By Column And Include Its Count

Without going into too much detail about the why, consider the below table. It’s a snippet of a table I’m working with for an e-commerce site. Any user (user_id) can have different products (product_id), but any user can also have

Posted in: Code Samples, Development  |  Tagged with:  |  Leave a comment

WooCommerce: How To “Trash” All Orders Really Fast

Some context I am working on a WooCommerce installation where I’m dealing with literally thousands of historical orders. All of which I am programmatically importing (including user accounts!) and doing a bunch of special updates, which are numerous and complicated,

Posted in: Code Samples, Development  |  Tagged with: , ,  |  Leave a comment

Harvest Launches Mobile Friendly Invoices

I love Harvest — the time-tracking bombshell of a service. They do more than track time, though. You can generate client invoices, manage projects, run real-time reports and with their mobile or desktop app you can easily switch between projects

Posted in: News  |  Tagged with: , ,  |  Leave a comment

Proton Mail Indiegogo Campaign Raises $115K In 3 Days

If you’ve seen or heard of Proton Mail in the news recently you might just be wondering what exactly they are all about. Well, I’ll tell you. Proton Mail is an NSA-proof end-to-end encrypted email service built by scientists from

Posted in: News, Technology  |  Tagged with: , , , ,  |  Leave a comment

“Can You Throw This up on the Website?”

In my profession, occasionally I’ll get an email from a client requesting if I can ‘throw something up on the[ir] website.’ I’ve had good laughs with co-workers and colleagues in the past about this, because this question is ultimately very

Posted in: Development  |   |  Leave a comment

Twitchy Artifacts with 1080i Video in Final Cut Pro X

I was cutting a quick video—which ended up not being so quick—for a friend. One not-so-small clip was recorded in 1080i 60 fps. Once imported into FCPX there were these twitchy artifacts forming every couple seconds during playback. I searched

Posted in: Video Production  |  Tagged with: , , ,  |  Leave a comment

The Stupid Zip Archive and WordPress Duplicator Issue

I’ve run into this issue a couple times and had to set everything aside and figure it out. It didn’t take long. I use WordPress Duplicator often to, well, duplicate and move different WordPress sites from production, for example, to

Posted in: Development  |  Tagged with: , , , , ,  |  Leave a comment

Unzip via SSH

I had to unzip a file on a clients server today. Unzipping it locally and then re-uploading it would have been a pain; the unzipped folder was about double the bits of the original ZIP file. Anyways, once terminal’d in,

Posted in: Development  |  Tagged with: , , ,  |  Leave a comment

Troubleshooting: Media Temple GRID SFTP Connection Issues

Sometimes I need to change a GRID Server Administrator password over at Media Temple. Once changed, I continually run into SFTP connection issues. It’s goddamn frustrating. And it was just working! I just want to code, not putts around with

Posted in: Development  |  Tagged with: , , ,  |  Leave a comment

Launched: Trivial Beersuit (for All Your Trivia Night Needs)

For the past few months I have been working on a subscription-based site that provides monthly custom curated trivia questions to bars and other establishments. It all began last summer at a friend’s wedding where I met the woman behind

Posted in: Development, Portfolio  |  Tagged with:  |  Leave a comment

Most recent work

  • Our Restroom Our Restroom is an (inter)national crowdsourced campaign who’s goal is simple: compel businesses to make their single occupancy restrooms gender neutral. Championed by Kristin Russo, designed by Allison Weiss, built by me on WordPress.
  • How To Win At Feminism The badasses over at Reductress are at it again with their new book How To Win At Feminism.
  • Reductress I crank out on-going web projects for Reductress. Super fun as you can imagine.
  • Everyone Is Gay Everyone Is Gay is an indispensable question and answer resource for the LGBTQ community. Hell, it’s great advice for anyone with a body with an emotion or two. I made the site responsive among other things. Give it a look see.

Need hosting?

  • Media Temple My go to hosting provider. You get rockstar hosting and I make a little cash. No pressure, just clean honest fun.

Past work

  • Christine Chaney Creative The online presence of Seattle artist Christine Chaney. Specializing in architecture, art and apparel.
  • Get Your Shit Together This is a site dedicated to helping you get your shit together before an unexpected tragedy, like the loss of a loved one.
  • IHG Instagram Sweepstakes An awesome Instagram driven sweepstakes site for IHG.
  • Trivial Beersuit A site that provides professional pub trivia to bars and restaurants.
  • Audi YouTube Channel This site was a quick turn-around hair pulling adventure for the Super Bowl: revamping Audi’s YouTube Channel.
  • Teach.org The new Teach.org. Providing tools to help students become teachers.
  • Valhalla DSP A one man Seattle based company, writing pretty sick professional audio plugins. Check ’em out!
  • Microsoft Visual Studio 2012 Launch This sweet new Visual Studio 2012 Launch website sports a mobile first, responsive web design architecture and comes in 14 different languages.
  • Nice Manners Music Nice Manners is an LA based recording studio offering their clients all sorts of digital audio services. This is a demo of an internal genre based music search & player I built for them. I am ecstatic about launching this project—check it out.
  • Holiday Inn Tumblr A quick, fully responsive update to the Holiday Inn Tumblr page.
  • Microsoft's Art of Touch An artful HTML5 Microsoft website. Sadly, this site is no longer live.
  • Microsoft Hardware Healthy Computing Tool A useful little tool to help you find the perfect Microsoft mouse or keyboard.
  • Pella Professional Pella manufactures high quality doors and windows. This is their professional site.
  • Imaging the World A non-profit dedicated to providing ultrasound services in remote areas of the world.
  • Ginny Ruffner: A not so still life A site for a documentary film about Seattle artist Ginny Ruffner.

Blogroll