# How to view SQLlite data in any userinterface apart from the terminal window

**URL:** <https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071>\
**Category:** General\
**Tags:** database\
**Created:** [3 March 2023 17:07 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071 "2023-03-03T17:07:17Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![YashPisat](https://avatars.discourse-cdn.com/v4/letter/y/e9a140/32.png) [@YashPisat](https://discourse.nodered.org/u/YashPisat)\
**Post date:** [3 March 2023 17:07 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/1 "2023-03-03T17:07:17Z")

</div>

I have sensor data which I am storing in sqlite database, Apart from terminal window, how can I view data in UI ?

---

<div class="post-metadata">

**Author:** ![marcus-j-davies](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/marcus-j-davies/32/103435_2.png) [@marcus-j-davies](https://discourse.nodered.org/u/marcus-j-davies)\
**Post date:** [3 March 2023 20:15 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/2 "2023-03-03T20:15:34Z")

</div>

Hi @YashPisat

This will involve 2 parts

- Use an SQL Lite node  
Search on [https://flows.nodered.org/](https://flows.nodered.org/) for an SQLite module to install that works for you.
- Install [node-red-dashboard (node) - Node-RED](https://flows.nodered.org/node/node-red-dashboard) OR [node-red-contrib-uibuilder (node) - Node-RED](https://flows.nodered.org/node/node-red-contrib-uibuilder)  
to present this data

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [3 March 2023 21:58 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/3 "2023-03-03T21:58:36Z")

</div>

Do you mean in node-red or just that you are looking for a GUI browser for sqlite?

---

<div class="post-metadata">

**Author:** ![YashPisat](https://avatars.discourse-cdn.com/v4/letter/y/e9a140/32.png) [@YashPisat](https://discourse.nodered.org/u/YashPisat)\
**Post date:** [3 March 2023 23:44 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/4 "2023-03-03T23:44:16Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![YashPisat](https://avatars.discourse-cdn.com/v4/letter/y/e9a140/32.png) [@YashPisat](https://discourse.nodered.org/u/YashPisat)\
**Post date:** [3 March 2023 23:45 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/5 "2023-03-03T23:45:10Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [4 March 2023 00:29 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/6 "2023-03-04T00:29:43Z")

</div>

> [@YashPisat](#):
>
> I have already inserted data in sqlite database using sqlite node. Now I want to have a look at the table.

i use [DB Browser](https://sqlitebrowser.org/) for looking at the db tables and query tests etc

in node red i use [node-red-node-sqlite](https://flows.nodered.org/node/node-red-node-sqlite)

---

<div class="post-metadata">

**Author:** ![edje11](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/edje11/32/572_2.png) [@edje11](https://discourse.nodered.org/u/edje11)\
**Post date:** [4 March 2023 09:51 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/7 "2023-03-04T09:51:34Z")

</div>

> [@YashPisat](#):
>
> 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.

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](https://www.phpliteadmin.org/phpliteadmin-dev.zip)

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [4 March 2023 10:10 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/8 "2023-03-04T10:10:15Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![YashPisat](https://avatars.discourse-cdn.com/v4/letter/y/e9a140/32.png) [@YashPisat](https://discourse.nodered.org/u/YashPisat)\
**Post date:** [4 March 2023 14:54 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/10 "2023-03-04T14:54:13Z")

</div>

Okay I will try this.

---

<div class="post-metadata">

**Author:** ![YashPisat](https://avatars.discourse-cdn.com/v4/letter/y/e9a140/32.png) [@YashPisat](https://discourse.nodered.org/u/YashPisat)\
**Post date:** [4 March 2023 14:54 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/11 "2023-03-04T14:54:51Z")

</div>

I also wanted to export the data int csv format so I think DB browser would work for me.

---

<div class="post-metadata">

**Author:** ![YashPisat](https://avatars.discourse-cdn.com/v4/letter/y/e9a140/32.png) [@YashPisat](https://discourse.nodered.org/u/YashPisat)\
**Post date:** [4 March 2023 14:55 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/12 "2023-03-04T14:55:10Z")

</div>

Thankyou, I installed DB browser and it works perfectly.

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [4 March 2023 14:58 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/13 "2023-03-04T14:58:11Z")

</div>

Just for info, if you pass the db data through a csv node it will produce a csv format for you to.

---

<div class="post-metadata">

**Author:** ![YashPisat](https://avatars.discourse-cdn.com/v4/letter/y/e9a140/32.png) [@YashPisat](https://discourse.nodered.org/u/YashPisat)\
**Post date:** [5 March 2023 13:06 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/14 "2023-03-05T13:06:53Z")

</div>

Oh, Thankyou, I will try this too.

---

<div class="post-metadata">

**Author:** ![YashPisat](https://avatars.discourse-cdn.com/v4/letter/y/e9a140/32.png) [@YashPisat](https://discourse.nodered.org/u/YashPisat)\
**Post date:** [7 March 2023 23:01 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/15 "2023-03-07T23:01:51Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [7 March 2023 23:14 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/16 "2023-03-07T23:14:30Z")

</div>

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](https://learn.sparkfun.com/tutorials/how-to-use-remote-desktop-on-the-raspberry-pi-with-vnc/all#enable-vnc)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [21 March 2023 23:14 UTC](https://discourse.nodered.org/t/how-to-view-sqllite-data-in-any-userinterface-apart-from-the-terminal-window/76071/17 "2023-03-21T23:14:44Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.