Some of the insights match my personal experience and preferences. At $dayjob we're migrating from Mongo to TimescaleDB (now TigerData ¯\_(ツ)_/¯) which is basically a PostgreSQL extension for time series data and couldn't be happier. We are getting better performance and massive storage savings. On the analytics side of things we are starting to use DuckDB for some development efforts, but we are keen on potentially…
Can you tell me, the scenarios you used MongoDB for? Because I'm still curious about why would anyone use MongoDB after all these years.
It is a especially bad choice considering that a lot of the data stored in it is IoT-like and the system creates a single document per event :facepalm: