The 2010 US Census Population By Zip Code (Totally Free)

US Population By Zipcode / ZCTA
Population by ZIP code / ZCTA from US Census 2010. Why was this so freaking hard to find?

I’m going to kick off a multi-part series on US Census data by offering a totally free download, in XLS or CSV format, of something strangely hard-to-Google: the 2010 US Census population by Zip code (technically, by ZCTA). Splitwise is offering these files free of charge and in the public domain, and I can’t believe how many other sites are charging for them!

But the difficulty I had in creating this data set and using the US Census website has inspired me to write a bit more about how to use one of the world’s most interesting open data sources.

Continue reading The 2010 US Census Population By Zip Code (Totally Free)

The Splitwise API Is Here

Splitwise API clipart
“Building on Splitwise is fun,” says Clay Clipart, a fake developer at Google Image Search.

We’ve always hoped to give people the power to build new experiences on top of Splitwise, and we’re proud to announce today that we are releasing our first public API.

This will allow developers, Splitwise-lovers, and other companies to integrate with Splitwise. We’ve created an open-source API example, and published the instructions and documentation that we use internally. Check it out! Continue reading The Splitwise API Is Here

Setting up OAuth for the Splitwise API

Let users log into their Splitwise accounts
Users log in to Splitwise, then authorize your app

The Splitwise API is here! With it, any developer can create an app that interacts with a Splitwise account, just like Facebook or Twitter.

Have you ever wished Splitwise had a certain feature so bad that you would be willing to build it yourself? Now you can! Continue reading Setting up OAuth for the Splitwise API

Safari ‘Top Sites’ Pollutes Google Analytics and Mixpanel

Average browser visit time chartIf you are the creator of a website or web application yourself, you might want to install the rack-preview gem for Ruby, or something similar. We discovered Safari Top Sites was polluting Splitwise’s Google Analytics and Mixpanel data.

A couple of weeks ago, while digging into our site analytics, we noticed something strange with Safari. We’d just launched Fat Rabbit and were really interested in making sure we measured all the useful  statistics around user growth and engagement. As we pulled out interesting details about website visits (using a combination of Google Analytics and Mixpanel), we started seeing an odd pattern – the average visit length on Safari was half that of our other browsers and the bounce rate was much higher.

Continue reading Safari ‘Top Sites’ Pollutes Google Analytics and Mixpanel

Splitwise Pivots To A New Business Model

Coming soon to a t-shirt near you
Coming soon to a t-shirt near you

After two long years of trying to figure out how to make money, Splitwise has finally settled on a sustainable business model that will enhance the user experience of our website and keep ourselves profitable into the future.

Charging money for payments? Lame. Advertisements? Meh. Premium features? What premium features?

The only logical path, as I’m sure you will agree, is to become a web-comic. Continue reading Splitwise Pivots To A New Business Model

New “Divide A Bill” For The Web App

We’ve been dying to improve our “Divide A Bill” dialog box for months, and a preliminary version is finally ready! Take a look below, and please give us feedback or suggestions in the comments. We’ve been rolling it out slowly over the past few days, and all users will have it by early next week.

Now with auto-complete, and the ability to change the involved parties without clearing out data.
Now with auto-complete, and the ability to change the involved parties without clearing out data.

The form has been completely redesigned from scratch, with two killer new features.

  • You can add people into the “With’ field just like an email – without tons of clicking. SO much easier, and much more like the iPhone and Android apps.
  • Adding new people will automatically add them into the expense without clearing your existing data (a big complaint in the old version).

Continue reading New “Divide A Bill” For The Web App

Preview/Feedback: Splitwise v2.5 (web)

Splitwise is planning a big redesign of the website and mobile apps for winter 2013, based on all the things we’ve learned since this past August. We’re releasing some intermediate changes to the website over the next few days – please, let us know your feedback!

Continue reading Preview/Feedback: Splitwise v2.5 (web)

ImageMagick for iOS – armv7 and armv7s

I’ve been working on some speculative projects for Splitwise this week (fun!). I ran into some issues where I needed to do more image manipulation than is possible in iOS, so I needed to add some magic to my project. Ahem. I mean ImageMagick.

ImageMagick logo
I wish it were actually that magical…

Fortunately for me, Claudio Marforio did the work to build ImageMagick for iOS armv6 and armv7. Unfortunately, I need libraries that work with armv7 and armv7s for the newer iOS devices. With some time spent tweaking build files, I was able to update his script and put together my own version that supports the newer hardware.

For most of you, there’s no need to build your own version. I’m working with Claudio to get this update pushed out to the official ImageMagick ftp, but you can grab a copy now. Update: Claudio published the updated files to the ImageMagick FTP site.

Continue reading ImageMagick for iOS – armv7 and armv7s

Debts Made Simple

Ever get caught in a debt triangle? You know: Mike owes you $20 for the electric bill, but he’s waiting for Anna to pay him for back for pizza last weekend, and she’s waiting for you to pay her back for those movie tickets…

In the end, nobody owes anyone anything – but until you figure that out, it’s one giant pain in the neck.

Luckily, you’ve got Splitwise. And we have some cool new features for you. Continue reading Debts Made Simple