MongoDB’s new query engine

This article seems to have inspired others to look at MongoDB again, so I&#x27;ll give my thoughts after using it recently.<p>MongoDB Atlas is a surprisingly good managed database product. I&#x27;m not a huge fan of someone else running my databases, but I think it might be the best one you can run across any cloud. If you like MongoDB (and, ignore the memes, there is a lot to like nowadays), and are OK paying a bit more to have someone run your database, I&#x27;d strongly consider Atlas.

I love Postgres and use it for different projects but for inboxes.com which has a very high insert rate coupled with auto delete by time stamp Mongo up until now has been very kind to me. We sometimes have 1000 incoming emails per second and high usage of our API and it just works.

This is great and all but I&#x27;m curious on the performance improvements. I&#x27;m surprised there are no graphs or charts when show improvement in latency, CPU usage, disk reads, etc

Heh, I missed that there&#x27;s a new query engine.<p>From [0] it looks like it was available from 5.1, also interesting is that you can&#x27;t choose which engine to use, so I suppose it only works on subsets or queries that meet certain conditions.<p>This isn&#x27;t the first time I hear something to the effect of &quot;LLVM JIT is great, but it introduces a lot of query latency&quot;. I wonder if there are other JIT engines more suitable for compiling potentially small&#x2F;simple queries.<p>[0] <a href="https:&#x2F;&#x2F;www.mongodb.com&#x2F;docs&#x2F;v7.0&#x2F;reference&#x2F;sbe&#x2F;#std-label-sbe-landing" rel="nofollow noreferrer">https:&#x2F;&#x2F;www.mongodb.com&#x2F;docs&#x2F;v7.0&#x2F;reference&#x2F;sbe&#x2F;#std-label-s...</a>

can it sort by id?

Serious question: Why use MongoDB when Postgres supports indexed dynamic json?

Does MongoDB still lose data?

Dear Geeks with interesting things to say on your blog:<p>Please, for sake of the people you want to hear your words. DO NOT USE A SANS SERIF MONOSPACED FONT FOR ANYTHING BUT CODE.<p>I get it. We stare at text (code) formatted in this kind of font all day long, and many of us find fonts that we truly enjoy. But, most of our monospace sans-serif fonts are designed to make sure individual characters aren&#x27;t misread. We don&#x27;t read prose the same way we read code. There is far more pattern recognition going on than actual parsing of individual letters, and monospaced fonts break that. We can debate the aesthetics of serifs but they actually do help provide context clues to the pattern recognition systems in our brain.<p>Convincing you all to start using serif fonts on prose is not a battle i&#x27;m likely to win, but maybe I can convince you to only use monospaced fonts for your terminal, and your code.<p>Please.