[–] creager 10y ago ↗ 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? [–] ThatMightBePaul 10y ago ↗ 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. [–] craigkerstiens 10y ago ↗ 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.
[–] ThatMightBePaul 10y ago ↗ 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. [–] craigkerstiens 10y ago ↗ 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.
[–] craigkerstiens 10y ago ↗ 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.
3 comments
[ 3.5 ms ] story [ 15.6 ms ] threadDo you do anything in particular to make your queries more digestible?
I fucking love CTE's for breaking apart ugly looking queries. They make everything significantly easy to read.