I am writing a Flutter app that uses a NodeJS REST API server as it's backend. The NodeJS application also uses MySQL database to store data.
The data inside the MySQL gets updated by another application. What I want to do is to read some specific tables of the MySQL database every 1-10 seconds.
I also have a router point within the NodeJS app that I can send http.get() requests from my flutter app to read data from MySQL. But I don't know what is the best way of sending these kind of requests frequently?
I am also interested to know if there is a better way of doing that like using socket.io? Or maybe accessing the MySQL directly without using the NodeJS app?