sql
I thought Ligaya Turmelle's post on SQL joins [http://www.khankennels.com/blog/index.php/archives/2007/04/20/getting-joins] was a great primer for novice developers. Since SQL joins appear to be set-based, the use of Venn diagrams [http://en.wikipedia.org/wiki/Venn_diagram] to explain
ruby on rails
Twitter is a victim of its own success. The site has massive scaling problems, to the tune of 11,000 pageviews per second. According to this interview with a Twitter developer, a lot of the scaling problems are attributable to Twitter's choice of platform: By various metrics Twitter
database
In a recent article, Doug Reilly makes a fairly well reasoned case for the use of stored procedures in lieu of ad-hoc SQL: So, should you use SPs or ad-hoc SQL? The answer is "it depends." I have placed myself firmly on the side of doing all database