Here

Tutorial on using Postgres recursive Common Table Expressions (CTEs) to navigate a JSON tree structure.

Postgres Explain Visualizer (Pev) is a tool I wrote to make EXPLAIN output easier to grok. It creates a graphical representation of the query plan.

If you’d like to automatically download pics and videos from your Android phone to your Mac, this post is for you. All you need is a free Dropbox account and some elbow grease.