# Sqlite not shown on Raspberry Pi

**URL:** <https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479>\
**Category:** General\
**Created:** [4 December 2018 16:37 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479 "2018-12-04T16:37:23Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andre](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andre/32/4554_2.png) [@Andre](https://discourse.nodered.org/u/Andre)\
**Post date:** [4 December 2018 16:37 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/1 "2018-12-04T16:37:23Z")

</div>

Hey,

I have just installed Sqlite in node red on a raspberry via the pallete manager, but in node red it is not in the list? how is this possible? normal sql is is only in the list.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [4 December 2018 16:54 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/2 "2018-12-04T16:54:30Z")

</div>

Did it come up with any message when you were installing?

What does the log say?

---

<div class="post-metadata">

**Author:** ![Andre](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andre/32/4554_2.png) [@Andre](https://discourse.nodered.org/u/Andre)\
**Post date:** [4 December 2018 17:13 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/3 "2018-12-04T17:13:06Z")

</div>

When I add a flow with a sqlite node in it, it says that it found a uninstalled node called sqlite, in the pallet manager it says that sq-lite is installed

---

<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:** [4 December 2018 17:36 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/4 "2018-12-04T17:36:13Z")

</div>

What is the full name of the node it says is installed? node-red-something probably.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [4 December 2018 18:01 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/5 "2018-12-04T18:01:18Z")

</div>

Thanks for the great info, but I’d still like you to answer the questions I asked.

---

<div class="post-metadata">

**Author:** ![Andre](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andre/32/4554_2.png) [@Andre](https://discourse.nodered.org/u/Andre)\
**Post date:** [4 December 2018 18:20 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/6 "2018-12-04T18:20:07Z")

</div>

I'll let you know tomorrow morning at 7.am Amsterdam time

---

<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:** [4 December 2018 22:55 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/7 "2018-12-04T22:55:55Z")

</div>

are you sure you have sqlite installed?  
try `sudo apt-get install sqlite3`

---

<div class="post-metadata">

**Author:** ![Andre](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andre/32/4554_2.png) [@Andre](https://discourse.nodered.org/u/Andre)\
**Post date:** [5 December 2018 13:56 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/8 "2018-12-05T13:56:06Z")

</div>

SEe log

```
Start Node-RED
 
Once Node-RED has started, point a browser at http://127.0.0.1:1880
On Pi Node-RED works better with the Firefox or Chrome browser
 
Use node-red-stop to stop Node-RED
Use node-red-start to start Node-RED again
Use node-red-log to view the recent log output
Use sudo systemctl enable nodered.service to autostart Node-RED at every boot
Use sudo systemctl disable nodered.service to disable autostart on boot
 
To find more nodes and example flows - go to http://flows.nodered.org
 
Starting as a systemd service.
Started Node-RED graphical event wiring tool.
5 Dec 13:38:45 - [info]
Welcome to Node-RED
===================
5 Dec 13:38:45 - [info] Node-RED version: v0.19.4
5 Dec 13:38:45 - [info] Node.js version: v8.11.1
5 Dec 13:38:45 - [info] Linux 4.14.79-v7+ arm LE
5 Dec 13:38:51 - [info] Loading palette nodes
5 Dec 13:39:06 - [info] Dashboard version 2.11.0 started at /ui
5 Dec 13:39:10 - [warn] ------------------------------------------------------
5 Dec 13:39:10 - [warn] [node-red-node-sqlite/sqlite] Error: Cannot find module '/home/pi/.node-red/node_modules/node-red-node-sqlite/node_modules/sqlite3/lib/binding/node-v57-linux-arm/node_sqlite3.node'
5 Dec 13:39:10 - [warn] ------------------------------------------------------
5 Dec 13:39:10 - [info] Settings file : /home/pi/.node-red/settings.js
5 Dec 13:39:10 - [info] Context store : 'default' [module=memory]
5 Dec 13:39:10 - [info] User directory : /home/pi/.node-red
5 Dec 13:39:10 - [warn] Projects disabled : editorTheme.projects.enabled=false
5 Dec 13:39:10 - [info] Flows file : /home/pi/.node-red/flows_raspberrypi.json
5 Dec 13:39:10 - [warn]
---------------------------------------------------------------------
Your flow credentials file is encrypted using a system-generated key.
If the system-generated key is lost for any reason, your credentials
file will not be recoverable, you will have to delete it and re-enter
your credentials.
You should set your own key using the 'credentialSecret' option in
your settings file. Node-RED will then re-encrypt your credentials
file using your chosen key the next time you deploy a change.
---------------------------------------------------------------------
5 Dec 13:39:10 - [info] Waiting for missing types to be registered:
5 Dec 13:39:10 - [info] - sqlite
5 Dec 13:39:10 - [info] Server now running at http://127.0.0.1:1880/
5 Dec 13:40:11 - [info] Stopping flows
5 Dec 13:40:11 - [info] Stopped flows
5 Dec 13:40:11 - [info] Waiting for missing types to be registered:
5 Dec 13:40:11 - [info] - sqlite
> 

pi@raspberrypi:~ $ sudo apt-get install sqlite3
Reading package lists... Done
Building dependency tree       
Reading state information... Done
sqlite3 is already the newest version (3.16.2-5+deb9u1).
0 upgraded, 0 newly installed, 0 to remove and 33 not upgraded

> pi@raspberrypi:~ $ sudo apt-get install sqlite
> Reading package lists... Done
> Building dependency tree        
> Reading state information... Done
> sqlite is already the newest version (2.8.17-14).
> 0 upgraded, 0 newly installed, 0 to remove and 33 not upgraded.
```

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [5 December 2018 14:14 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/9 "2018-12-05T14:14:09Z")

</div>

so now

`cd .node-red`

and the install the node and look at the messages for any errors.

---

<div class="post-metadata">

**Author:** ![Andre](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andre/32/4554_2.png) [@Andre](https://discourse.nodered.org/u/Andre)\
**Post date:** [5 December 2018 14:29 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/10 "2018-12-05T14:29:39Z")

</div>

There are no errors, the node is installed without errors

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [5 December 2018 14:47 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/11 "2018-12-05T14:47:04Z")

</div>

Just to confirm you have installed the node again, from within your `.node-red` directory?

---

<div class="post-metadata">

**Author:** ![Andre](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andre/32/4554_2.png) [@Andre](https://discourse.nodered.org/u/Andre)\
**Post date:** [5 December 2018 15:08 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/12 "2018-12-05T15:08:26Z")

</div>

I'm installing it with this code: "sudo apt-get install sqlite3", after it says in the pallete manager that it's installed, but it's not showed in the list and giving the error when I import a flow with a sqlite node in it.

I don't know what to do ☹

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [5 December 2018 15:29 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/13 "2018-12-05T15:29:27Z")

</div>

But thats not the node-red-node.

With that you have installed the "database", but now that is installed you need to reinstall the Node-RED component that allows you to read and write to that "database".

See this page for how to do it.

> **[node-red-node-sqlite](https://flows.nodered.org/node/node-red-node-sqlite)**
>
> A sqlite node for Node-RED

  
NOTE It does not use `sudo`

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [5 December 2018 20:09 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/14 "2018-12-05T20:09:46Z")

</div>

If that install fails due to not having access type errors, then try it with extra parameter

```
npm i —unsafe-perm node-red-node-sqlite
```

---

<div class="post-metadata">

**Author:** ![Andre](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/andre/32/4554_2.png) [@Andre](https://discourse.nodered.org/u/Andre)\
**Post date:** [17 December 2018 10:24 UTC](https://discourse.nodered.org/t/sqlite-not-shown-on-raspberry-pi/5479/15 "2018-12-17T10:24:04Z")

</div>

Thanks

Fixed it with some help [https://groups.google.com/forum/#!topic/node-red/60STlYN53e0](https://groups.google.com/forum/#!topic/node-red/60STlYN53e0)