3 ms·
When you don't want to use an ORM, want to scale horizontally, want to use BSON data types and all the indexing capabilities around them, etc.
by Beefin 7y ago
When you don't want to use an ORM, want to scale horizontally, want to use BSON data types and all the indexing capabilities around them, etc.
- jeltz 7y agoPostgreSQL has the JSONB data type which is essentially the same as the BSON type except slightly better optimized for reading partial documents. And PostgreSQL also provides good indexing support for them, and did so before MongoDB.
- Beefin 7y agohave you tried using the postgres json data type? it's a joke.
- LunaSea 7y agoCan you list some reasons?
- eyelidlessness 7y agoNot really sure about the `JSON` type, but the `JSONB` type is excellent.
- thinkx 7y agothat’s a throwaway opinion, worth the time you spent writing it
- zozbot234 7y agoPostgres can also be made to shard any table to multiple hosts via the PARTITION BY RANGE/PARTITION OF feature, combined with the FOREIGN DATA WRAPPER (FDW) core extension.