[speedgoose]

I am not sure about the speed actually. I wouldn't bet on a MongoDB against a PostGreSQL or even SQLite with JSONB fields and some indexes.

I find NoSQL document databases harder to maintain over time, and you can always have tables with JSON columns.

But moreover, my question was about MongoDB, not about SQL vs NoSQL. And it has been answered, the developer was familiar with it.

[_akhe]

NoSQL is faster than SQL for access, talking like 10x faster. Which makes sense if you think about what it is.

Very true with maintainability - it's ridiculous to use a NoSQL as your main db eventually because of duplicate data and the very large file storage.

You'd use neither of them with certain math or AI (they use vector dbs optimized for array data) - different tools/jobs.

[speedgoose]

Do you have a source about the 10x speed gain for NoSQL? It doesn’t really make sense to me and the benchmarks I found say it’s about the same, which makes sense to me.