It’s just me or there are others who keep seeing these updates and think mongodb had all of this years ago?
Seriously so happy to be running our production stack on mongo.
It’s just me or there are others who keep seeing these updates and think mongodb had all of this years ago?
Seriously so happy to be running our production stack on mongo.
Poe's Law strikes again.
Is this an ad? Postgres has had search for more than a decade.
> Postgres has had search for more than a decade.
More than two decades (it moved to core from contrib in version 8.3 in 2008, but it was available in contrib since 7.4 in 2003.)
Not an ad, just a happy user. You can check my profile. I run another startup not affiliated with Mongo.
Wow, you're serious. So FYI, postgres has had FTS for decades. TIN is possibly an improvement on existing PG behavior, but proprietary to planetscale.
Mongo's older search system was strictly worse than ancient standard FTS on postgres. About five years ago Mongo added more sophisticated search options. Standard PG search has been pretty stagnant, but there are PG extensions (like TIN, some proprietary some not) that add more sophistication.
In the mean time, Mongo doesn't let you use SQL unless you're directly a customer of MongoDB. The native primitives for aggregation in Mongo are ghastly and feel like the era of RDBMSes before query planners were a thing. Plus transactions... are relatively new.
I've used Mongo, there are things I like about Mongo, but the main benefit is horizontal scaling and the main penalty is any query more complex than get/put is hard. Whether that is worth it (especially compared to alternatives like CRDB, TiDB, or Spanner) is really very specific to you.
Take another look. It does a lot more than Postgres search.