If the external application changes the data in the sqlite table, we need the refresh option (button or menu).
Especially in the grist-electron, because it doesn't have the refresh option that a browser has.
In a browser frontend sometimes (not a big table) helps to set table advanced settings to on-demand and then refresh a browser page.
Which is not possible in electron.
It is a good idea. It would also be possible to check directly if an external application changes the data, since SQLite maintains a version number that is increased every time a change is made.
If the external application changes the data in the sqlite table, we need the refresh option (button or menu). Especially in the grist-electron, because it doesn't have the refresh option that a browser has. In a browser frontend sometimes (not a big table) helps to set table advanced settings to on-demand and then refresh a browser page. Which is not possible in electron.