Flickr

A few bits and pieces that have crossed my browser in the past couple of weeks (though mostly sifted through yesterday). The NoSQL (or LessSQL) movement has garnered a lot of attention over the past few months, but numerous people have pointed out that MySQL can be adapted to cover many of the most common use-cases. Flickr’s Kellan kicked off a series of posts on that topic with Using, Abusing and Scaling MySQL at Flickr and Richard Crowley responded with OpenDNS MySQL abuses. On the other side of the coin, Luke Melia has a write-up of how he uses Redis to build a “who’s online now list” and Sean Cribbs’ (fairly convincing) Why Riak should power your next Rails app is worth a read even if you’re not a ruby developer. ...

The past two weeks haven’t really left time to compile my selected links, though there have been many. A few days at SxSWi (on which more, later) followed by travelling with the family and the inevitable work backlog moved blogging way down the priority list. So here’s a mammoth selection to get me caught up. Particularly interesting has been the discussion around the future of newspapers (represented here by Clay Shirky, Steven Johnson and Russell Davies), which seem to have finally pushed beyond “how t ind a good business model for papers” to looking at where the real value for society lies and how we can preserve and extend that in a changing landscape. ...

Yesterday, responding to a post Steve wrote on our Social Media efforts at Greenbelt I noted that it’s important to remember that this wasn’t the first year we’d worked with social media at the festival. Flickr has been our most prominent outlet, with the festival’s tags being some of the most visible in the week following the festival for several years now. But as I’ve written about here in the past (from a fairly techie perspective), we’ve made efforts to aggregate content from multiple blogs, social bookmarking services, and the like a few times previously. So what was different this year? ...

Thanks to some hard design work on the part of Rob Vander Giessen-Reitsma I was able to launch a new look for the website of singer/songwriter Sarah Masen a week or so ago. Sarah’s recently released three new EPs (her first releases since 2001, and all with hand made packaging) and it was high time the site got a new lease of life. At heart, the site is a simple rails application, and we’re still making frequent updates as we let the new design settle in and begin to hook the site together with the new web world that has sprung up since it was last given any real attention. One of the latest changes is the use of the flickraw gem to pull in photos from gigs. We’re using last.fm’s machine tags to identify events, which may not be the best route as we build out the archive but for now provides a nice way to disambiguate events on flickr, with the fringe benefit that the photos show up on last.fm too. ...

Back from Greenbelt last night, I spent some time this morning trying out flickr’s new support for ‘geotagging’ by placing all my photos on a map. The interface is nice and hopefully as the API is updated and more uses for the geodata emerge, more and more users will geotag their photos. I’m imagining a map of the Greenbelt site that lets visitors see photos based on when and where on the site they were taken, opening up all sorts of navigational possibilities. ...