The Guardian on migrating from Mongo to Postgres. It’s interesting to read about implementing a major database change like this with no downtime.
The Guided By Voices Database has everything you need to know about the band’s discography, as well as the various side projects that Pollard and crew are involved with.
This site allows you to navigate & search the Guided By Voices discography and gigography. Information includes catalog numbers, scanned album images, track times, credits, vinyl color, pressing information, release dates, setlists, and gig ticket/poster images. Song details include the releases the song appears on and gigs where the track was played live.
I found a copy of the setlist from one of two back-to-back shows that I went to at the Horseshoe Tavern years ago. Both nights were epic, featuring three hour sets with double encore.
Database War Stories
For those interested in designing large-scale web applications, it’s worth taking a look at O’Reilly’s database war stories. They tap some of the larger real-world players for your reading enjoyment.
- Part 1: Second Life
- Part 2: Bloglines and Memeorandum
- Part 3: Flickr
- Part 4: NASA World Wind
- Part 5: Craigslist
- Part 6: O’Reilly Research
- Part 7: Google File System and BigTable
- Part 8: Findory and Amazon
- Part 9: Brian Aker of MySQL responds
The future human consciousness will not be stored in a flat file.