What is the best way to implement the backend order counter architecture?

Question

Backend

There is a database with a list of orders, you need to check it every (conditionally) minute and update customer accounts (reduce the amount of funds in the account depending on the type of orders and all sorts of such trifles). This system should work in parallel with the Django server and a couple of other daemons. What is the best way to implement such a program? What architecture and approach to use? Now I have a separate service running a script that while True checks the database, does all the updates and is idle for a minute time.sleep(60). How to do it right?

Answer 1

Why do this on a schedule if you can make an event system using a message broker. You can take RabbitMQ to start. And if you have self-confidence, then Kafka is better so that you can go back in time