Comment on RethinkDB: An open-source distributed database built with love over three yearsparentComments−shawn-butler13yWhile technically correct I assume the parent was referring to hstore [0] which has both GIST and GIN indexes as well as btree and hash for equality.With some simple formatting functions (its just json after all) it's sixes to me.[0] http://www.postgresql.org/docs/9.2/static/hstore.html−dbuxton13yhstore is great, I won't hear a word against it, but it doesn't deal with complex nested objects like JSON can (I would love to be wrong about this) - it's just a key/value store with indexing of the objects inside.
Comments
While technically correct I assume the parent was referring to hstore [0] which has both GIST and GIN indexes as well as btree and hash for equality.
With some simple formatting functions (its just json after all) it's sixes to me.
[0] http://www.postgresql.org/docs/9.2/static/hstore.html
hstore is great, I won't hear a word against it, but it doesn't deal with complex nested objects like JSON can (I would love to be wrong about this) - it's just a key/value store with indexing of the objects inside.