3 ms·
I don’t currently use Mongo. But some reasons I would: 1. Because Postgres support for complex JSON queries are sub par compared to MongoDB 2. When I did use
by scarface74 6y ago
I don’t currently use Mongo. But some reasons I would:
1. Because Postgres support for complex JSON queries are sub par compared to MongoDB
2. When I did use MongoDB it was with C#. The Mongo Linq driver is excellent. You write standard Linq queries and it gets translated to MongoQuery. You use standard C# POCO objects and the compiler ensures a consistent “schema”.
- tehlike 6y agoCan you give examples to #1? Did mongo linq driver support everything linq supported? I assume joins would not be or other complex things you'd otherwise use with rdbms. On postgres + linq + document db - check: https://martendb.io/documentation/documents/querying/linq/ https://martendb.io/documentation/documents/querying/linq/
- scarface74 6y agoYes it supports joins. https://www.axonize.com/blog/iot-technology/joining-collections-in-mongodb-using-the-c-driver-and-linq/ https://www.axonize.com/blog/iot-technology/joining-collecti... The weird left join syntax for LINQ with Mongo is endemic to how LINQ does left joins even with an RDMS. Yeah it’s obtuse.
- tehlike 6y agoNot always - depending on the underlying linq provider, you could probably query the child collection diretly without join and it would generate the proper sql. It's a function of ORM though, but if you are using linq you probably have EF or NHibernate going for it (i was a former nhibernate developer around the time linq support was added)
- scarface74 6y agoYes you usually can query the child directly. I did a bunch of left joins with LINQ when I knew SQL, but didn’t understand how EF worked as well as I do now. I watched videos by Julie Lerman and since then I learned that any time you do an explicit join with EF, you’re probably doing it wrong. I haven’t used Mongo in years , but I would be surprised if there isn’t some type of annotation that you could do on a class to tell the driver how to map the relationships so it would do it implicitly. My recent experience with DynamoDB best practices though is that is usually a smell when you try to bring over relational thinking to a NoSQL database and you should carefully think about your design decisions.