3 ms·
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 : schemal
by bsaul 12y ago
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.
- ashearer 12y agoOne 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.)
- ie 12y agoTokuMX brought ACID to Mongo a couple years ago, and it's pretty solid.
- bsaul 12y agoThanks, i didn't know about it. It doesn't seem to bring relationnal, sql, and joins though ( which may be useful in certain cases).