Years ago, we were setting up an architecture where we fetch certain data as-is and throw it in CosmosDb. Then we run a daily background job to aggregate and store it as structured data.
The problem is the volume. The calculation step is so intense that it will bring down the host machine, and the insert step will bring down the database in a manner where it takes 30 min or more to become accessible again.

Accommodating for this would need a fundamental change in our setup. Maybe rewriting the queries, data structure, containerizing it for auto scaling, whatever. Back then, this wasn't on the table due to time constraints and, nobody wanted to be the person to open that Pandora's box of turning things upside down when it "basically works".

So the hotfix was to do a 1 second threadsleep for every iteration where needed. It makes the job take upwards of 12 hours where - if the system could endure it - it would normally take a couple minutes.

The solution has grown around this behavior ever since, making it even harder to properly fix now. Whenever there is a new team member there is this ritual of explaining this behavior to them, then discussing solutions until they realize how big of a change it would be, and concluding that it needs to be done, but...

not right now.

Cosmonaut is a simple and lightweight ORM for CosmosDB.

A simple object mapper for CosmosDB SQL API

Cosmonaut is an object mapper that enables .NET developers to work with a CosmosDB using .NET objects. It eliminates the need for most of the data-access code that developers usually need to write.

Anyone knows wtf has happend with Azure DocumentDB??? Someone renamed it to CosmosDB or what?

I only learn and work with aws. Never tried gcp or azure

Someone explain me the difference between all 3 in your own words

1) A quick summary in 1-2 sentences each
2) Pros and cons
3) Which one is the best in your opinion
4) which one would you recommend for all projects
5) would you recommend to use 1 for all projects or does it depend on a project, if it depends how do you determine which one should be used for which project
6) some people post on linkedin about azure cosmos db glorifying it of how superior db it is. Never tried it. Whats so special about Azure CosmosDB since this is only for Azure i think