How To Navigate JSON Trees in Postgres using Recursive CTEs

| | |

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

Postgres Query Plan Visualization

| |

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.

How to Automatically Back up Photos from Android to Mac for Free

| | | | |

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.

How to Customize JFree Charts

| |

In this tutorial, I’ll explain how to customize JFree charts to look clean and modern.

A Second Look at Facebook’s React


React is a very impressive library for developing fast, component-based UIs. That said, it’s not a full framework and will likely require additional libraries in order to build large apps.

Groking Angular: Dependency Injection and Testing

| | |

Although Angular’s syntax for Dependency Injection is sometimes difficult to understand, it’s actually quite straight forward to use for testing.

How and When to Use Various GORM Querying Options

| | |

Grails GORM supports five increasingly powerful querying mechanisms: 1) dynamic finders, 2) where clauses, 3) criteria, 4) HQL, and 5) SQL.

How to Configure IntelliJ IDEA For Angular JS Testing

| |

Here’s a simple guide on how to configure IntelliJ IDEA to use Karma/Jasmine to run Angular tests

A Rating System For Free Apps


Every time I install a new free app, I wonder about exactly how its creators intend to make money. Am I going to see a bunch of ads? Are they going to sell me something? Are they going to sell me to someone?

How to Write a Children’s Book

| |

As a parent, I read a lot of children’s books. Each time I pick up one of these literary masterpieces, I can’t help but stare at amazement at the words in front of me. It’s hard to believe that such a delightful work of art was conceived of, written, edited, printed, distributed, and sold by and to adults.

Online Commenter Types


There are many, many people online who like to comment on things. A few are lucid, most are harmless, but some are… Well, let’s just say “not very nice”.