Analyzing database trends through 1.8M Hacker News headlines

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 replacing some or all of our Snowflake usage with DuckDB.

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 the main database for a huge Rails app. They adopted Mongo right when its popularity started to decline. I always thought it was a very poor choice since the day I joined.

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:

I'm sorry to hear about your bad experience. From your comment I take it that you weren't using a time-series collection to store data in mdb which uses industry-standard compression techniques?

> I'm still curious about why would anyone use MongoDB after all these years.

Because MongoDB is webscale.