With the new JSONB data type for PostgreSQL, users no longer have to choose between relational and non-relational data stores: they can have both at the same time. JSONB supports fast lookups and simple expression search queries using Generalized Inverted Indexes (GIN). Multiple new support functions enable users to extract and manipulate JSON data, with a performance which matches or surpasses the most popular document databases. With JSONB, table data can be easily integrated with document data for a fully integrated database environment.

18 DECEMBER 2014: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.4, the latest version of the world’s leading open source database system. This release adds many new features which enhance PostgreSQL’s flexibility, scalability and performance for many different …

Categories: Plus

Related Posts

Plus

www.economist.com/blogs/economist-explains/2017/02/economist-explains-0

A new study by Raj Chetty of Stanford University and a collective of other economists helps answer this question. By matching data from the Department of Education with 30m tax returns, Mr Chetty and his Read more…

Plus

How to build your own bio-bot | KurzweilAI

Bio-bot design inspired by the muscle-tendon-bone complex found in the human body, with 3D-printed flexible skeleton. Optical stimulation of the muscle tissue How to build your own bio-bot | KurzweilAI Related PostsBubble sheet multiple choice Read more…

Plus

How PostgreSQL is tested

How PostgreSQL is tested – http://blog.pgconf.us/2017/02/how-postgresql-is-tested.html At PgConf US 2016, PostgreSQL core team member Peter Eisentraut presented: How PostgreSQL is tested. Below is the video for that presentation. Join us at the end of March Read more…