Re:ToroDB: A MongoDB-compatible, document-oriented database ...
by ashearer on Thursday April 30, 2015 @04:55PM
(#9467591)
One reason may be that Postgres doesn't have built-in operators for updating an individual field within a JSON doc. (The workarounds are complex and/or inefficient.)
Postgresql with jsonb lets you get the best of both world : schemaless when you want it, relationnal when you need it, and acid all the time.
I found it strange that they decided to map a document over relationnal schema. I would only map the "id" property of the document to a pkey, and then dump all the rest in a jsonb column, per document type.