Use bigint for Flickr photo id's

December 31, 2007
If you are using FlickrAPI and you are storing the photo id's in a MySQL database, make sure the column is a bigint :-) Flickr reached the integer limit (2147483647) today with this photo.We've been bitten by this. We are using the Flickr API on the What's Cookin' website and we were using signed MySQL integers, which overflowed today.

Discussion, links, and tweets

I work at Venture Spirit. Follow me on Twitter; you'll enjoy my tweets. I take care to carefully craft each one. Or at least aim to make you giggle. Or offended. One of those two— I haven't decided which yet.