Hello, I need advice for my database. The app is a store selling products. I want the the app to display total sales, stock and update the database every time an action occurs, say a sale stock order(quantity).
What is the best approach to the database? How do I update the stock quantity, product quantity and total sales?
How about scheduling a backend workflow conditioning it to update the DB when the said action is rendered