Version 9.4 of PostgreSQL was released last month, which meant I got to experience a developer tradition unlike any other: Postgres fanatics being snarky about their database of choice on Twitter. These folks will say almost everything. They’ll tell you how your own databsae is worse (especially if your database is MongoDB), how you can replace it with Postgres (regardless of your requirements and environment), and how any issues you may find with Postgres may actually be a problem with you.
In all fairness, I have nothing against PostgreSQL. It is a fine database, and I really am impressed with its feature list. But I find its community to be far too much of the “tell not show” variety, and in my opinion this is the absolute worst way to promote a product to the uninitiated.
So when something like this pops up in my Twitter feed, the only way I, a Postgres neophyte, can learn how to use the database’s shiny new JSON features is to figure it out myself. Now I’d like to share what I’ve found for anyone else in my boat.