my problem is the following: I have an application in ruby ​​on rails that I would like to update in realtime, second by second. I would not, however, overload the database unnecessarily (because too many users and small server). I would like the ruby ​​on rails application to be notified in some way by the mysql database when an update occurred in some datqabase table. It's possible?
I have a python script that in realtime could populate with new data the mysql tables.
I'm not sure what problem you're trying to solve. Won't the rails app get the updated data from the db on each request anyway? Are you caching the data? If that's the case just have the python script invalidate the cache.
How to correctly update webapp when cron brings new data