4 ms·

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 instea

by zulban 2y ago

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 https://blog.stuartspence.ca/2023-05-goodbye-mongo.html Personally tho, I plan to just drop all similarity to mongo in future projects.

oskar_dudycz 2y ago
Yup, I might not reach full compliance, but I will try to follow the Pareto principle. Thanks for the link and kind feedback!
jrochkind1 2y ago
> I was surprised how much performance improved Are you saying you got better performance from postgres jsonb than from mongodb itself?
- zo1 2y ago
  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.
  - deleted 2y ago
    [deleted]
  - jrochkind1 2y ago
    Thanks. How embarressing for mongo, woah.
Thaxll 2y ago
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.
throwaway2037 2y ago
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").
- dayjaby 2y ago
  > I knew it was time to migrate when my non-programmer wife was becoming familiar with Mongo shortcomings That part was so relatable

by zulban 2y ago

oskar_dudycz 2y ago

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

jrochkind1 2y ago

> I was surprised how much performance improved Are you saying you got better performance from postgres jsonb than from mongodb itself?

zo1 2y ago
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.
- deleted 2y ago
  [deleted]
- jrochkind1 2y ago
  Thanks. How embarressing for mongo, woah.

Thaxll 2y ago

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.

throwaway2037 2y ago

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").

dayjaby 2y ago
> I knew it was time to migrate when my non-programmer wife was becoming familiar with Mongo shortcomings That part was so relatable