Just ran across this excellent pair of blog posts on using JSONB with Go application design to simplify your data model.  Since that blog is...

First, in case you somehow missed it, PostgreSQL 9.5 Beta 2 is now out.  Time for another round of testing!  There's fewer and fewer bu...

Continued from Part 2 . The next test is two tags combined.  This is where the alternative approaches really pull ahead of the tradition...

continued from part 1. So the real test of the different tagging data structures and types is how they perform.  The tests below were run ...

Many web applications are designed with a "tags" feature, where users can add arbitrary string "tags" to  each document ...

For the third night of Hanukkah, we have a nice present for you: PostgreSQL 9.4.0 .  Now eat your latkes. Let's talk about 9.4 by ...

Of course, the first thing which occurred to me with pg_shard was to create a distributed "NoSQL" database using 9.4's JSONB ...

If you've been paying any attention at all, you're probably wondering why 9.4 isn't out yet.  The answer is that we had to chang...

One thing we're waiting on to get 9.4 out the door is making a decision on JSONB storage.  Currently under debate are patches to the JSO...

Apparently June is the month for hackers named Peter with difficult-to-spell last names.  Join us for two live streams of two different Pete...

There are a bunch of features which are pending for 9.4, still, and a bunch of features which are already committed.  Given how interesting ...