← Back to team overview

dhis2-devs team mailing list archive

PostgreSQL 9.4 and JSONB

 

Hi

I've noted an increased interest from many DHIS users to store,
deliver, and search source documents (policy, annual performance
plans, and similar) in an integrated manner - for instance, a recent
Request for Proposals for the Office of Standards Compliance in SA
outlined a integrated data & document system.

PostgreSQL 9.4 is now 2-3 weeks from final release, and the main new
feature is the new JSONB data type, ref PG Wiki:

"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 enables 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."

Has any other DHIS development or user team considered how to
integrate documents into their overall DHIS system?

Regards from Juba, South Sudan
Calle

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************


Follow ups