12 Oct '15, 4pm

Understanding Postgres Common Table Expressions with FizzBuzz [blog post] - written by me -- #postgres

CTEs are great for a lot more than solving FizzBuzz. Non-recursive CTEs alone can be used to simplify and dry up complicated queries that would otherwise involve many nested sub-selects1 . Recursive CTEs allow you to do things in-database that simply aren't possible with other SQL constructs (e.g. sub-selects). The possibilities include but are not limited to generating reports from data aggregated from many tables and transforming data when migrating from one schema to another. This makes them a valuable addition to your SQL repertoire. CTEs are even more powerful than I've illustrated. To see some other cool capabilities of CTEs, check out this post on Writeable Common Table Expressions

Full article: http://hashrocket.com/blog/posts/understanding-common-tab...

Tweets

CHEAT DAY and Using an Inversion Table

runeatrepeat.com 12 Oct '15, 3pm

Hello! Happy Monday! How was your weekend? Did you run the Chicago Marathon? Long Beach Marathon?? Around your neighborhoo...

Folding Postgres Window Functions into #Rails -...

webcodegeeks.com 09 Oct '15, 9am

You’ve heard of window functions in PostgreSQL, but you aren’t quite sure what they are or how to use them. On the surface...