Jacob Kaplan-Moss

Bruce Schneier Blazes Through Your Questions - Freakonomics - Opinion - New York Times Blog

Required reading this AM.

(authentication, computing, cryptography, economics, encryption, for:jdunck, freakonomics, internet, interview, security, technology)

Wikipedia: Site internals, configuration, code examples and management issues (PDF)

Loads of information about the tech behind Wikipedia. I've become convinced that the only sane way to design scalable systems is by studying the trials and tribulations of others.

(architecture, for:jdunck, hardware, infrastructure, lighttpd, memcached, mysql, performance, scaling, sysadmin, via:simonw, web, webdev, wikipedia)

Efficient SQL

Greg Mullane's complete talk on optimizing postgresql. Looks like a few things have changed since 2003 (7.3 —> 8.2), but this still seems *very* relevant.

(database, for:jdunck, for:mcroydon, optimization, performance, postgresql, sql, tuning)

EXPLAIN plan Operators

Ridiculously in-depth explanation of what PostgreSQL means when you ask it to EXPLAIN. This is probably the only place this information lives.

(for:jdunck, for:mcroydon, performance, postgresql)

Peter Van Dijck’s Guide to Ease » Blog Archive » The top 10 presentations on scaling websites: twitter, Flickr, Bloglines, Vox and more.

A *great* roundup of ten presentations on scaling: Twitter, Flickr, LiveJournal, Vox, Bloglines, last.fm, and SlideShare.

(deployment, for:jdunck, performance, scaling, server, slides, software, sysadmin, tutorials, webdev)

Kitchen Soap » Blog Archive » Slides from ‘Capacity Planning for LAMP’ talk at MySQL Conf 2007

(apache, flickr, for:jdunck, mysql, scaling, slides)