The newest social networking nerd site, Pownce, has some great back-end cred: The website is made with Django, which is Python powered, and we use a MySQL database. The servers are powered by Debian, and our webservers run a combination of Apache and Perlbal. File storage is supported by S3 from Amazon Web Services.
Yowza. Me like.