Re:Goodbye MongoDB, Hello PostgreSQL (2015)
by justsomeuser on Thursday March 11, 2021 @04:51AM
(#26422229)
I agree with you. SQL allows for a much larger set of possible unknown-at-design-time queries as the data is broken down into atomic units.
With a document store, you often find yourself de-normalising and copying data to new collections on-write to deal with the limited query language.
This means your writers often implicitly encode the possible queries.
As an example, in Redis if you need a 3 way join/filter, you will either a) have your application read all the data and filter it or b) maintain the filtered collection via writers copying the data.
With a document store, you often find yourself de-normalising and copying data to new collections on-write to deal with the limited query language.
This means your writers often implicitly encode the possible queries.
As an example, in Redis if you need a 3 way join/filter, you will either a) have your application read all the data and filter it or b) maintain the filtered collection via writers copying the data.