Using PostgreSQL and jsonb with Ruby on Rails

PostgreSQL 9.4 introduced jsonb, a new column type for storing documents in your relational database. jsonb and json columns look exactly the same on a higher level, but differs on the storage implementation. The advantage of using jsonb is that you can easily integrate relational and non-relation data, with performance that can be better than most non-relational databases like MongoDB. Understanding the differences between json and jsonb So, what are the differences between both column types? W...

Submit