I am planning on building a micro-service eCommerce back-end to be easy to reuse in any project as we need. I would like to use both Python and Node.js and MongoDB & PostgreSQL , in your opinion which one would best suited for the following services:
- And more not yet defined....
Nine times out of ten, you don't need Mongo, and for what you're doing, I really don't see a benefit here. You're going to have users, and you'll want to link those users to auth events, inventory, and payments. You'll also want to link your payments to inventory and skus, etc etc. That's relational data. Don't put that in a document store unless you have a penchant for frustrating hours debugging race conditions.
For anything that needs 100% acuracy you should utilize Postgres for your database, (auth, payment, user, order, inventory) for catalog and SKU's mongo is a good choice. For business logic, choose what performs best. Order, payment and inventory type services can really get hammered from my experience, so I would even consider soemthing like rust for that.