tatiyants.com tatiyants.com - geek humor and other drivel

I recently ran into an interesting challenge trying to use Postgres to work with JSON trees. Specifically, I had to figure out how to navigate a tree structure stored as JSONB in a Postgres table. Here’s how I did it.
The Setup
Let’s start by defining the schema. We’ll create a table that will store org charts as a JSONB object:...

After a recent stint in query optimization, I once again found myself wanting a better way to view query plans produced by EXPLAIN. So, I finally decided to do something about it and the result is Postgres EXPLAIN Visualizer (or Pev):
Why Pev
I wanted a tool that can make plans simple to understand and be visually pleasing. More specifically, I wanted:...

If you'd like to automatically download pics and videos from your Android phone to your Mac, this post is for you. Here's what you'll need:
Android phone with pictures on it
Free Dropbox account – feel free to use my referral link

JFree Chart is an open-source charting library for the JVM. It's been around forever, it's got a ton of options, and it's capable of generating some really great charts.
That said, it's default output is not great. There's a fair amount of visual noise and default color choices could be better. So, in this tutorial, I'll explain how to customize your JFree chart to look clean and modern....