3 ms·
Does anyone know of performance (and usability) comparisons between say Postgres JSONB and Azure CosmosDB?
by stevesimmons 5y ago
Does anyone know of performance (and usability) comparisons between say Postgres JSONB and Azure CosmosDB?
- jf22 5y agoThose are two completely different tools with different use cases.
- exceptione 5y agoWell, tell that to the MS-shops... I think it is a very good question, would love to see some benchmarks.
- fisf 5y agoWe use azure SQL (basically mssql) to perform something similar -- this might be a more apt comparison. We deal with largish amounts of JSON event data, and unpack specific fields to computed columns. This allows to use clustered indices, standard analytical tools, etc., while leaving the raw data as it is. Performance is mostly fine for analytics (time series aggregation and such). It is also a very flexible approach.
- stevesimmons 5y agoTo expand on my particular use case for Azure CosmosDB, I have a Python web app built with FastAPI. I find it super convenient to dump Pydantic data models of our primary domain objects to JSON and save them into Cosmos, tagged with the model name. Then on rereading the Cosmos records, my model registry automatically imports the required Pydantic model and reconstitutes the live Python object.