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, http://www.sai.msu.su/~megera/postgres/talks/), 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)."