News for hackers. Stuff that matters.
Re:ToroDB: A MongoDB-compatible, document-oriented database ... by bsaul on Thursday April 30, 2015 @04:43PM (#9467525)
I wonder if the future stack isn't optional typing language querying optional-sql database.

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.

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.)
Re:ToroDB: A MongoDB-compatible, document-oriented database ... by ie on Thursday April 30, 2015 @05:04PM (#9467636)
TokuMX brought ACID to Mongo a couple years ago, and it's pretty solid.
Re:ToroDB: A MongoDB-compatible, document-oriented database ... by bsaul on Thursday April 30, 2015 @05:36PM (#9467818)
Thanks, i didn't know about it. It doesn't seem to bring relationnal, sql, and joins though ( which may be useful in certain cases).