# SQLite Browser based manager

**URL:** <https://discourse.nodered.org/t/sqlite-browser-based-manager/27257>\
**Category:** General\
**Created:** [25 May 2020 13:13 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257 "2020-05-25T13:13:34Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![josekavunkal](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/josekavunkal/32/18505_2.png) [@josekavunkal](https://discourse.nodered.org/u/josekavunkal)\
**Post date:** [25 May 2020 13:13 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/1 "2020-05-25T13:13:34Z")

</div>

Do we have a node which work like SQLite manager for providing  
generic UI to edit table data using browser?

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [25 May 2020 13:59 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/2 "2020-05-25T13:59:45Z")

</div>

I don't believe so but I'd love to see one! 😀

---

<div class="post-metadata">

**Author:** ![thebaldgeek](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/thebaldgeek/32/93523_2.png) [@thebaldgeek](https://discourse.nodered.org/u/thebaldgeek)\
**Post date:** [26 May 2020 02:34 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/3 "2020-05-26T02:34:05Z")

</div>

Likewise. That would be a great node and a huge asset to the community.

---

<div class="post-metadata">

**Author:** ![happytm](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/happytm/32/7058_2.png) [@happytm](https://discourse.nodered.org/u/happytm)\
**Post date:** [29 May 2020 08:49 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/4 "2020-05-29T08:49:07Z")

</div>

Very useful proposal.

I would also like to see MQTT Explorer type of display format on dashboard either using sqlite database as input or directly input from MQTT messages. MQTT Explorer put out lot of data in very organised way with configurable charts. Unfortunately it is still not browser based.

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [29 May 2020 09:03 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/5 "2020-05-29T09:03:23Z")

</div>

You could use [https://sqlitestudio.pl](https://sqlitestudio.pl)

Cross platform, open source. standalone.

For web based you could use

> **[coleifer/sqlite-web](https://github.com/coleifer/sqlite-web)**
>
> Web-based SQLite database browser written in Python - coleifer/sqlite-web

---

<div class="post-metadata">

**Author:** ![janvda](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/janvda/32/234_2.png) [@janvda](https://discourse.nodered.org/u/janvda)\
**Post date:** [29 May 2020 10:07 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/6 "2020-05-29T10:07:20Z")

</div>

What do you exactly want to do ?

How do you want to be able to edit the table data:

- Is it in the node-red editor via the configuration of a node ?
- Is it in the node-red dashboard by means of this new node ?
- or did you have something else in mind.

There are tools to edit an sqlite database like _ **DB browser for SQL lite** _ and the chrome extension _ **SQLite Manager** _ you have mentioned. Are they also not an option ? I admit that in that case you must be careful not to corrupt the sqlite DB by updating it both via node-red and this tool.

---

<div class="post-metadata">

**Author:** ![josekavunkal](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/josekavunkal/32/18505_2.png) [@josekavunkal](https://discourse.nodered.org/u/josekavunkal)\
**Post date:** [29 May 2020 13:29 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/7 "2020-05-29T13:29:21Z")

</div>

What I was looking is a node like tablify ,but should emit actions like add rows ,delete row ,edit row etc.  
This will not directly write to DB ,but emit action and data as needed.

For example if we want to delete a row ,it emits rowid of table and action "delete".  
If we want to add a row ,it emits new set of data which we enter and "insert" .

If we need to update a row ,it send edited data along with rowid and "update".

The input to this node is from SQLiteDB select statement result.  
Does that make sense?.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [29 May 2020 13:35 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/8 "2020-05-29T13:35:18Z")

</div>

Do a search on the forum for `crud` (and search the 'Flows' tab) and you will find examples of flows that do what you want.

---

<div class="post-metadata">

**Author:** ![janvda](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/janvda/32/234_2.png) [@janvda](https://discourse.nodered.org/u/janvda)\
**Post date:** [29 May 2020 14:49 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/9 "2020-05-29T14:49:47Z")

</div>

So to put it simply: you want a wrapper around the [node-red-node-sqlite](https://flows.nodered.org/node/node-red-node-sqlite) that besides doing what it usually does, it also outputs a message (or extends the outputted message) with the following information:

- action = delete/insert/update
- rowid
- inserted or updated row data.

Is that right ?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [29 May 2020 15:01 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/10 "2020-05-29T15:01:25Z")

</div>

I think he rather would like something like UI\_Table to work seamlessly with a database. Something that has CRUD operations where events (msgs) from that table that state what needs to happen in the database (e.g. delete where key=mag.payload.rowID etc)

But as @zenofmudsaud already, there are a number of crud examples floating around.

---

<div class="post-metadata">

**Author:** ![josekavunkal](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/josekavunkal/32/18505_2.png) [@josekavunkal](https://discourse.nodered.org/u/josekavunkal)\
**Post date:** [29 May 2020 15:51 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/11 "2020-05-29T15:51:53Z")

</div>

Yes partially correct ,it should give a html UI to edit/crud table.  
The actions on the table should be routed to node outputs.

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [29 May 2020 16:05 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/12 "2020-05-29T16:05:53Z")

</div>

> [@happytm](#):
>
> Unfortunately it is still not browser based.

Actually I think that it is since I think (though may be wrong) that it is an Electron app (node.js wrapped into an executable with built-in web ui). 😀 But I get what you are saying. It would be interesting to have it deconstructed as a single-page app that could be run from uibuilder under Node-RED 😉

> [@bakman2](#):
>
> You could use

I'd forgotten about that, been a while since I used much SQLite. It will be added to my portable apps folder.

> [@bakman2](#):
>
> written in Python

:shudder: - trying to do my best to not be using Python right now thanks 😀

> [@janvda](#):
>
> SQLite Manager

Unfortunately, this looks like a no-go having read recent (since last summer) reviews which are all 1-star.

---

<div class="post-metadata">

**Author:** ![josekavunkal](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/josekavunkal/32/18505_2.png) [@josekavunkal](https://discourse.nodered.org/u/josekavunkal)\
**Post date:** [18 June 2020 10:59 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/13 "2020-06-18T10:59:33Z")

</div>

My idea is create a html table like what is done using tablify node.  
Then add edit actions to the same html table which will post the sql to another http end point .  
Connect the posted sql to sqlite ,which actually does editing.

http get Endpoint -\>Select-\>sqlite-\>custom Node-\>HTTP response.  
Table editing action will post sql to another http endpoint

HTTP post end point-\>sqlite.

Looks it is feasible.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [18 June 2020 12:53 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/14 "2020-06-18T12:53:33Z")

</div>

Well you should take a look at node-red-node-ui-table and read thru [Examples for node-red-node-ui-table](https://discourse.nodered.org/t/examples-for-node-red-node-ui-table/14256) for shoe ideas of how to make a table editable.

I'll be interested to see the flow you build.

---

<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:** [17 August 2020 12:53 UTC](https://discourse.nodered.org/t/sqlite-browser-based-manager/27257/15 "2020-08-17T12:53:45Z")

</div>

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