I have sensor data which I am storing in sqlite database, Apart from terminal window, how can I view data in UI ?
Hi @YashPisat
This will involve 2 parts
- Use an SQL Lite node
Search on https://flows.nodered.org/ for an SQLite module to install that works for you. - Install node-red-dashboard (node) - Node-RED OR node-red-contrib-uibuilder (node) - Node-RED
to present this data
Do you mean in node-red or just that you are looking for a GUI browser for sqlite?
I have already inserted data in sqlite database using sqlite node. Now I want to have a look at the table.
The dashboad part you mentioned, Will it give me graphical representation or tabular view of the database?
I am looking for GUI browser for sqlite.
I tried to install phpliteadmin, but I dont know for some reason it is not working for me.
i use DB Browser for looking at the db tables and query tests etc
in node red i use node-red-node-sqlite
Most like due Php 8, this is not compatible with the release versions of PhpLiteAdmin.
You have to download and install the develop version, that works with php 8.
https://www.phpliteadmin.org/phpliteadmin-dev.zip
If all you want to do is view it in the ui send it to ui-table node, it should then display it in a table.
Okay I will try this.
I also wanted to export the data int csv format so I think DB browser would work for me.
Thankyou, I installed DB browser and it works perfectly.
Just for info, if you pass the db data through a csv node it will produce a csv format for you to.
Oh, Thankyou, I will try this too.
I have installed DB browser in raspberry pi. I use putty to access nodered of raspberry pi in my laptop. Is there any way to access dbbrowser of raspberry pi in my laptop?
do you have VNC server running on the PI ?
if its not enabled by default you can enable it and download VNC client on your laptop to connect to the PI
and see its UI and also run DB browser
there is an article that gives detailed steps how to do it
How to Use Remote Desktop on the Raspberry Pi with VNC
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.