I've used (and introduced) MongoDB in production. Though I much prefer PostgreSQL, SQLite, MySQL, or SQL Server, for some use cases a document database is fine.
However as I discovered myself, once you realise you need to use Mongoose with it you should usually take that as a prompt to consider going relational.
Don't get me wrong, Mongoose is a good package. But the things it solves could likely be better fixed by moving away from MongoDB - I'd go so far as to say that in most cases Mongoose should only be added to help an existing project; if you need it from the start you probably should go relational.
However as I discovered myself, once you realise you need to use Mongoose with it you should usually take that as a prompt to consider going relational.
Don't get me wrong, Mongoose is a good package. But the things it solves could likely be better fixed by moving away from MongoDB - I'd go so far as to say that in most cases Mongoose should only be added to help an existing project; if you need it from the start you probably should go relational.
(YMMV and there will be exceptions.)