Hacker News Reader

Comment by zulban | Hacker News Reader

Neat. When I migrated a project from mongo to postgres I took a similar approach, except I only implemented the mongo feel I needed within my own project instead of building a proper library as done here. I was surprised how much performance improved despite using a hacky wrapper.

https://blog.stuartspence.ca/2023-05-goodbye-mongo.html

Personally tho, I plan to just drop all similarity to mongo in future projects.

View on HN

Cripes, this is a good blog post. Did it get posted to HN for discussion? If not, it should have been. I especially like this part:

    > I'm trying to stay humble. Mongo must be an incredibly big project with lots of nuance. I'm just a solo developer and absolutely not a database engineer. I've also never had the opportunity to work closely with a good database engineer. However I shouldn't be seeing improvements like this with default out of the box PostgreSQL compared to all the things I tried over the years to fix and tune Mongo.

Humbleness: That is rare to see around here. It is impressive that you go such speed-ups for your use case. Congrats and thank you to share with the blog post.

EDIT

The Morgan Freeman meme at the end gave me a real laugh. I would say the same about my experience with GridGain ("GridPain").

> I knew it was time to migrate when my non-programmer wife was becoming familiar with Mongo shortcomings

That part was so relatable

Yup, I might not reach full compliance, but I will try to follow the Pareto principle. Thanks for the link and kind feedback!

> I was surprised how much performance improved

Are you saying you got better performance from postgres jsonb than from mongodb itself?

From the article, they mention this alongside a neat graph: "API calls generally take 8 ms now, not 150 ms."

His endpoints went from 150ms (with Mongo) to 8ms after moving to Postgres.

Thanks. How embarressing for mongo, woah.

I remember your post back then and it did not made sense at all, many pointed out it was lacking information and you probably did something wrong with mongo.

All the stuff under Mongo Problems is garbage, sorry.

Reply on news.ycombinator.com