dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #34197
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