2 ms·
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 sta
by adityapatadia 2mo ago
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.
- stickfigure 2mo agoPoe's Law strikes again.
- groundzeros2015 2mo agoIs this an ad? Postgres has had search for more than a decade.
- dragonwriter 2mo ago> 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.)
- adityapatadia 2mo agoNot an ad, just a happy user. You can check my profile. I run another startup not affiliated with Mongo.
- stickfigure 2mo agoWow, 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.
- wyclif 2mo agoTake another look. It does a lot more than Postgres search.