Many thanks for your reply. Agree on the findings. Nevertheless cant get my head around the solution outlined.
The sqlite file "db.sql" ist copied over on file lever every hour. This contains the table that is being queried. The table has new rows every time the db-file with the same name is exported again. This filename is "static" as sql-source file in node-red. Where should the export happening? Outside of node-red to a csv-file that is than picked up by node-red?
If time allows can you provide some more insight? That would be highly appreciated. Thank you in advance.
