SoylentNews is people

Title    Postgres: Jsonb Has Committed
Date    Monday March 24 2014, @08:28PM
Author    janrinok
from the jason-who? dept.

Anonymous Coward writes:

"An article regarding adding support for a json variant to PostgreSQl appears interesting. From the article:

This work is a confluence of two projects - our hstore and json, which [have been] in PostgreSQL for years in somewhat incomplete forms - hstore (10 years old!) implements key-value storage with binary storage and indexing, while json - document storage implemented as a text. I and Teodor Sigaev have started working on nested hstore more than year ago with support of Engine Yard and got working prototype with everything document-oriented storage needed (see our presentations in Ottawa, 2013, Dublin, 2013,, which eventually happens to be binary storage for jsonb - a new data type, introduced by Andrew Dunstan, which has everything from json, but performs better, thanks to binary representation and indexing ! jsonb doesn't preserve an order of keys and keys are unique ( the last win)."


  1. "An article regarding adding support for a json variant to PostgreSQl" -

© Copyright 2023 - SoylentNews, All Rights Reserved

printed from SoylentNews, Postgres: Jsonb Has Committed on 2023-12-08 02:38:48