Skip to content

Comment on Inventory management in MongoDB: A design philosophy I find bafflingparent

Comments

A products table with a document per product. A user table. An order table with line items in an array of embedded objects.

One would subtract product from amout field in products table to set new inventory level. A new order document gets created with all information needed to describe an order. Fields like total, subtotal, date would sit at the root level and line items with product descriptions and prices would be embedded as an array of objects. Then a user object with user_id, name address would be embedded.

Dealing with documents is a different but being able to contain the entire dataset with some relations is nice.

AboutSource Built by g1lg1l

Hackerly is an independent reader for Hacker News, built on the public HN API. Not affiliated with Y Combinator.