# Node-Red SQLITE

**URL:** <https://discourse.nodered.org/t/node-red-sqlite/12583>\
**Category:** General\
**Created:** [25 June 2019 15:47 UTC](https://discourse.nodered.org/t/node-red-sqlite/12583 "2019-06-25T15:47:06Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![scargill](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scargill/32/1118_2.png) [@scargill](https://discourse.nodered.org/u/scargill)\
**Post date:** [25 June 2019 15:47 UTC](https://discourse.nodered.org/t/node-red-sqlite/12583/1 "2019-06-25T15:47:06Z")

</div>

I'm bang up to date with Node-Red on my Pi 3, latest Dashboard, everything updated as expected using the palette mnager, except, not for the first time, SQLITE - problem is its a while since I updated this and I've forgotten how to get out of a jam with it.

node-red-node-sqlite has 2 nodes, I'm using 0.3.6 no problem, but when I tried updating it using palette Manager to 0.3.7 - the relevant flows stopped, citing 2 missing sqlite nodes. I've a half memory that in the past I had to wipe the SSQLITE folder - anyone come across this recently?

---

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [25 June 2019 16:04 UTC](https://discourse.nodered.org/t/node-red-sqlite/12583/2 "2019-06-25T16:04:45Z")

</div>

I hit a similar problem with missing files.  
Nick told me to use...

npm rebuild sqlite3

It takes quite a while as it recompiles lots of things - but eventually it gets there.

Hope it helps.

---

<div class="post-metadata">

**Author:** ![scargill](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scargill/32/1118_2.png) [@scargill](https://discourse.nodered.org/u/scargill)\
**Post date:** [25 June 2019 16:10 UTC](https://discourse.nodered.org/t/node-red-sqlite/12583/3 "2019-06-25T16:10:43Z")

</div>

Thats a good start, Dave. Is that AFTER updating or will that automatically get latest version and is that as you state or "sudo npm rebuild sqlite3" ? I'm guessing that would be done in the /home/pi directory?

---

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [25 June 2019 17:22 UTC](https://discourse.nodered.org/t/node-red-sqlite/12583/4 "2019-06-25T17:22:01Z")

</div>

I just typed it in as is.

I don't think it matters whether you are in the Node-RED directory.

I didn't use 'sudo', just typed it in as shown above.

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [25 June 2019 17:47 UTC](https://discourse.nodered.org/t/node-red-sqlite/12583/5 "2019-06-25T17:47:36Z")

</div>

You probably need to run it in `~/.node-red` and do not use `sudo`

---

<div class="post-metadata">

**Author:** ![scargill](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scargill/32/1118_2.png) [@scargill](https://discourse.nodered.org/u/scargill)\
**Post date:** [25 June 2019 17:59 UTC](https://discourse.nodered.org/t/node-red-sqlite/12583/6 "2019-06-25T17:59:07Z")

</div>

Thank you both - much appreciated....

---

<div class="post-metadata">

**Author:** ![scargill](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/scargill/32/1118_2.png) [@scargill](https://discourse.nodered.org/u/scargill)\
**Post date:** [25 June 2019 22:10 UTC](https://discourse.nodered.org/t/node-red-sqlite/12583/7 "2019-06-25T22:10:06Z")

</div>

Just for clarification then - for anyone else getting this, I managed to use the Palette Manager to completely update all my nodes, BUT when it came to the node-red-node-sqlite node (in this case 0.3.6 with 0.3.7 available) my SQLITE operations came to a halt. So, using a backup NR, in Palette Manager again, I installed node-red-node-sqlite 0.3.7 (at which point NR said it will be necessary to restart NR) - I STOPPED NR when the manager was done. I then went to the /home/pi/.node-red directory and ran "npm rebuild sqlite3" as user PI, then 10 minutes later when it was done recompiling, I started NR again and all is well. That worked.