| Title | Postgres: Jsonb Has Committed | |
| Date | Monday March 24 2014, @04:28PM | |
| Author | janrinok | |
| Topic | ||
| 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)."
| Links |
printed from Dev.SN, Postgres: Jsonb Has Committed on 2024-05-02 09:18:48