#1 2014-12-19 10:00:23

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,183
Website

Feature request: Native support of PostgreSQL 9.4 JSONB columns

Latest stable PostgreSQL 9.4 introduced the new JSONB format.

http://www.postgresql.org/about/news/1557 wrote:

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.
"JSONB brings PostgreSQL to the JavaScript development community by allowing JSON data to be stored and queried natively. Node.js and other server-side JavaScript frameworks can benefit from the safety and robustness of PostgreSQL, while still storing data in the schema-less format that they prefer," said Matt Soldo, Product Manager, Heroku Postgres.

We would like to implement direct and optimized support of JSONB columns for dynamic arrays, records or variant published records. At first, variant may be supported, since they are converted to/from JSON. Then SQL queries should be able to convert *DynArrayContains() functions - and eventually other more complex JSON queries - into corresponding JSONB operators.

This is the forum thread for feature request http://synopse.info/fossil/info/ae27dd8032a

Offline

#2 2015-01-11 06:17:32

edwinsn
Member
Registered: 2010-07-02
Posts: 1,215

Re: Feature request: Native support of PostgreSQL 9.4 JSONB columns

This seems to be very interesting.


Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

Offline

Board footer

Powered by FluxBB