node-red-node-sqlite - "Error: SQLITE_READONLY: attempt to write a readonly database"

Which node are you reporting an issue on?

node-red-node-sqlite

What are the steps to reproduce?

I put my database into home folder (/home/dietpi/temps.db)

and used a fixed query in the node
INSERT INTO temps (temperature) VALUES (30);

What happens?

I'm getting "Error: SQLITE_READONLY: attempt to write a readonly database"

What do you expect to happen?

A normal write - the database is read/write/executable with every user on system -> chmod 777 temps.db

I'm able to write with the sqlite3 CLI in the database

Whats wrong?

Please tell us about your environment:

• [2.2.2 ] Node-RED version:
• [v12.22.12 ] node.js version:
• [6.14.16] npm version:
• [DietPi v8.6.1] Platform/OS:
• [ Firefox latest] Browser:

Start with the node-red-node-sqlite implementation and reproduce the fixed INSERT against /home/dietpi/temps.db on the reported environment. Compare its behavior with the sqlite3 CLI, then identify the cause of the readonly error and document a verified fix or required configuration; the issue is resolved when the write succeeds through the node.