Re:Hstore development for 9.4 release
by mml on Thursday November 07, 2013 @04:38PM
(#6692591)
I'm very excited to put my 3m documents into hstore, as they are currently in a horrible, unqueryable, unwritable (mostly) blobs of compressed, b64encoded serialized ruby hash structures (long story, predating nosql).
This makes me very, very happy.
Edit:
I should point out why:
-my document structures pretty much match 1:1 with hstore now (we have nested arrays of hashes)
-i can query & report on the data with normal tools
-i can update individual fields on my data (currently impossible)
-i can do relational joins & such-like in the db (currently impossible)
-i can have sensible transactions
This makes me very, very happy.
Edit:
I should point out why: -my document structures pretty much match 1:1 with hstore now (we have nested arrays of hashes) -i can query & report on the data with normal tools -i can update individual fields on my data (currently impossible) -i can do relational joins & such-like in the db (currently impossible) -i can have sensible transactions