Pinetek Networks - Knowledge Base - pinebox:manual:6_sqlite
https://doc.pinetek-networks.com/
2026-05-01T11:59:58+00:00Pinetek Networks - Knowledge Base
https://doc.pinetek-networks.com/
https://doc.pinetek-networks.com/lib/exe/fetch.php?media=wiki:logo.pngtext/html2025-04-22T15:31:35+00:00Anonymous (anonymous@undisclosed.example.com)6.1 SQLite Database – Create, delete and export tables
https://doc.pinetek-networks.com/doku.php?id=pinebox:manual:6_sqlite:6-1_create-delete-export&rev=1745335895&do=diff
6.1 SQLite Database – Create, delete and export tables
The Pinebox offers a possibility to create the table structure from the process data.
To create the data, a valid IODD file needs to be present for the port. In the web interface, the section for the database control is in the process data section of the port page. To create a new table structure, hit the “Create structure for process data” button:text/html2025-04-22T15:31:03+00:00Anonymous (anonymous@undisclosed.example.com)6.2 SQLite Database – Database Frontend
https://doc.pinetek-networks.com/doku.php?id=pinebox:manual:6_sqlite:6-2_database-frontend&rev=1745335863&do=diff
6.2 SQLite Database – Database Frontend
The Pinebox has an integrated web front end for the SQLIte database. The database frontend is based on sqlite-web, and can be accessed on port :8080 of the Pinebox web server or via the link in the Pinebox web interface menu:text/html2025-04-22T15:41:27+00:00Anonymous (anonymous@undisclosed.example.com)6.3 SQLite Database – Node-RED database node
https://doc.pinetek-networks.com/doku.php?id=pinebox:manual:6_sqlite:6-3_sqlite-node-red&rev=1745336487&do=diff
6.3 SQLite Database – Node-RED database node
Import node into Node-RED
The Node-RED node for the database is generated similar to other nodes and imported into Node-RED:
Copy the content:
Import into Node-RED:
Connect node in Node-RED
For the resulting node, the output of the Process Data needs to be directly connected to the “Compile Data” node: