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