Well first, I am experiencing some thing near the following...
Not identical but similar enough to find it interesting.
In that, I cannot get any variant of 'via msg.topic' configuration in the sqlite node to work with any variant of msg.params. Even though there are many examples via Google suggesting this.
So, I changed to a 'prepared' query node configuration, which ignores msg.topic and requires a static query syntax, this works with msg.params use. Or has thus far, as 10 to 20 tests.
As for the database instance going read only, that has not a materialized once I got the insert sequence working consistently. And yes, the user that NR runs under, has explicit permission to the file system and directory where the database file is located.
I still cannot get msg.payload to show any evidence of success or failure of any query. This seems really odd, compared to how MySQL or MariaDB query results are communicated back to NR flows.
