Hacker News Reader

I'll admit to giving little thought to the legibility of my SQL - this is a quick read, with some solid tips.

Do you do anything in particular to make your queries more digestible?

Craig mentions this in the piece, but I'll second it:

I fucking love CTE's for breaking apart ugly looking queries. They make everything significantly easy to read.

Yep, this is essentially the biggest piece. Using CTEs and having building blocks that are easy to logically follow is the single biggest thing you could do.

Reply on news.ycombinator.com