<story><title>Document Storage Gymnastics with Postgres</title><url>http://rob.conery.io/2015/03/01/document-storage-gymnastics-in-postgres/?utm_source=feedburner&amp;utm_medium=feed&amp;utm_campaign=Feed%3A+wekeroad%2FEeKc+%28Rob+Conery%29</url></story><parent_chain><item><author>angersock</author><text>So, I love Postgres to death, but I&amp;#x27;m a bit let-down by the json and jsonb stuff.&lt;p&gt;It&amp;#x27;s really great for document storage and retrieval, but the fact that there doesn&amp;#x27;t seem to be any story for partial updates kind of kills it for me. If it just had that, it&amp;#x27;d cover every use case I could possibly want (except for maybe some of the Cassandra stuff).&lt;p&gt;It&amp;#x27;s annoying, though, because clearly that&amp;#x27;s what people often may want--just look at Mongo.</text></item></parent_chain><comment><author>tomiko_nakamura</author><text>PostgreSQL does not have in-place update in the first place, on every UPDATE it does a DELETE+INSERT. So &amp;quot;partial update&amp;quot; does not make much sense, because you&amp;#x27;ll create a new copy of the row anyway.</text></comment>
<story><title>Document Storage Gymnastics with Postgres</title><url>http://rob.conery.io/2015/03/01/document-storage-gymnastics-in-postgres/?utm_source=feedburner&amp;utm_medium=feed&amp;utm_campaign=Feed%3A+wekeroad%2FEeKc+%28Rob+Conery%29</url></story><parent_chain><item><author>angersock</author><text>So, I love Postgres to death, but I&amp;#x27;m a bit let-down by the json and jsonb stuff.&lt;p&gt;It&amp;#x27;s really great for document storage and retrieval, but the fact that there doesn&amp;#x27;t seem to be any story for partial updates kind of kills it for me. If it just had that, it&amp;#x27;d cover every use case I could possibly want (except for maybe some of the Cassandra stuff).&lt;p&gt;It&amp;#x27;s annoying, though, because clearly that&amp;#x27;s what people often may want--just look at Mongo.</text></item></parent_chain><comment><author>ahachete</author><text>Or ToroDB ;) &lt;a href=&quot;https://github.com/torodb/torodb&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;torodb&amp;#x2F;torodb&lt;/a&gt;</text></comment>