Message Queues Async Database Updates

[Harshavardhan Patil]

Hello,

Has anyone implemented a message queue for async updates in Jam.py?

Context:

In my database I need several tables to be updated based on actions by the user on forms in other areas.

 
For example:
 - Changing workflow status from 'New' to 'In Progress' to 'Completed' etc. 
 - Updating reference / ID numbers of items up / down the workflow.
 - Updating quantities and costs into other tables after certain transactions are done.

I was wondering if all such cross-reference data updates can be bundled into a query, and processed at certain intervals using message queues. Can this work? Is this the right approach?

Or is there a better approach to this?

<<PS: I am a CODER, not a SOFTWARE ENGINEER>> :)  

Best Regards,

Harsh

[Dean D. Babic]

Hi, 

I think all of this can be done with the Server Module. on_apply can be used for the Form, etc.

For sure SQL can be used, or Jam way with set_where.

Looks to me that u are referring to Northwind example, where Danijel did that.

D. 

[Dean D. Babic]

Are you referring this this?

https://groups.google.com/g/jam-py/c/S9HRyxGKH60/m/-QR3XkGnAQAJ

[Harshavardhan Patil]

Exactly.! 

Something on these lines, I was trying to implement using Python's inbuilt queue and threading modules.

Thanks for this, will try out the rq and redis approach and see how it works. 

Best Regards,

Harsh

<<PS: I am a CODER, not a SOFTWARE ENGINEER>> :)