Foursquare Check-in Stats

Late last year I wrote a script that took my Foursquare check-ins and created an entry for each of them in the Day One app. This continues to work well and you can read more about it here:

I felt that there was more that could be done with the information held in Foursquare and set about extracting it.

Into the Dataverse

I decided that the best way to get the data in a usable form would be to extract it and store it in a database, choosing SQLite as the repository (Read Read the rest

Exporting Foursquare check-ins to Day One

This is the project that I expected to do for my November 12 Apps in 12 Months challenge but, as you will see, that wasn’t actually possible.

Don’t rely on someone else’s API

I had two projects in mind for Day One: sync my WordPress blog posts and my Foursquare/Swarm check-ins to it. I felt that the latter was probably the easier of the two, so I started with that last September.

I went through the OAuth process to get my key and then started making authenticated calls to the https://api.foursquare.com/v2/users/self/checkins endpoint. This should have returned a list … Read the rest