# SQLite Install Problem

**URL:** <https://discourse.nodered.org/t/sqlite-install-problem/43762>\
**Category:** General\
**Created:** [6 April 2021 12:51 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762 "2021-04-06T12:51:49Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [6 April 2021 12:51 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/1 "2021-04-06T12:51:49Z")

</div>

Hi, i try to install sqlite via manage palette, and the manage palette tab shows that sqlite is installed, but i don't see it in the list of node tabs. i try to intall it via command (npm install node-red-node-sqlite) on Win, but still nothing. Any help?

 ![Untitled000](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/1/c12d19e7eb09f32f203fe23dd76bfff79531d782.jpeg)

---

<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:** [6 April 2021 13:08 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/2 "2021-04-06T13:08:08Z")

</div>

I see you have installed multiple sqlite nodes, they may be interacting. I suggest you remove them all except the one you want to use.

---

<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:** [6 April 2021 13:54 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/3 "2021-04-06T13:54:58Z")

</div>

Also, have you installed sqlite on your windows computer?

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [7 April 2021 08:33 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/4 "2021-04-07T08:33:27Z")

</div>

I delete all sqlite nodes and than re-install them, successfully..

I try to install SQLite on my Win, but i receive this:

![Untitled222](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/2/a22a89d6fc7d3b5dc2d251b7f716f31868142a87.jpeg)

I watch from here

> **[How To Download & Install SQLite Tools](https://www.sqlitetutorial.net/download-install-sqlite/)**
>
> In this tutorial, you will learn step by step on how to download and use the SQLite tools to your computer.

Where can be the problem?

---

<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:** [7 April 2021 09:59 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/5 "2021-04-07T09:59:59Z")

</div>

What are the files in the folder?

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [7 April 2021 10:54 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/6 "2021-04-07T10:54:59Z")

</div>

sqldiff, sqlite3, sqlite3\_analyzer

---

<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:** [7 April 2021 12:00 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/7 "2021-04-07T12:00:11Z")

</div>

Are they in the c:/sql folder?

You might want to look at that guide for installing SQLite again

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [7 April 2021 12:16 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/8 "2021-04-07T12:16:33Z")

</div>

The picture i sent previously did not show the folder, that i'm in to ?

---

<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:** [7 April 2021 14:25 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/9 "2021-04-07T14:25:21Z")

</div>

Well if you loook at the install instructions you provided it says:

 ![Screen Shot 2021-04-07 at 10.23.00 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/1/019b9aa92b57f1a22a3abdbe68479d0817776287.png)

but in the next picture you have this:  
 ![Screen Shot 2021-04-07 at 10.23.43 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/1/b1af5a2e61d7b2ca2a9d8226f34eb9565221fe03.png)

Looks to me like you put them in the wrong place. You might want to try moving them.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [7 April 2021 15:01 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/10 "2021-04-07T15:01:16Z")

</div>

I fix it.  
Thank you for showing my mistake!

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [7 April 2021 15:03 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/11 "2021-04-07T15:03:20Z")

</div>

Which is better for SQL GUI- SQLiteStudio or DBeaver?

---

<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:** [7 April 2021 16:17 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/12 "2021-04-07T16:17:35Z")

</div>

You got me, I’m a Mac man 😁

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [15 April 2021 14:01 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/13 "2021-04-15T14:01:26Z")

</div>

I understand.

Anyone have experiences with SQLiteStudio or DBeave for sensor data storage ?

---

<div class="post-metadata">

**Author:** ![Kib](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kib/32/27493_2.png) [@Kib](https://discourse.nodered.org/u/Kib)\
**Post date:** [15 April 2021 14:07 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/14 "2021-04-15T14:07:28Z")

</div>

@Martin10 I have used both. I prefer DBeaver because most of the things you will ever require are going to be already available as GUI options. For example i used it with PostGRES and it is way better than PGAdmin. I assume will be the same for you.

I dont understand your sensor data storage, I mean data is data. I used InfluxDB for timeseries databases, and couldnt find a good GUI tool.

But as far as relational databases go i think you can not go wrong with DBeaver.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [18 April 2021 17:53 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/15 "2021-04-18T17:53:05Z")

</div>

Thank you!

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [23 April 2021 14:37 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/16 "2021-04-23T14:37:18Z")

</div>

Can we install DBeaver on RPI ? Or if we need GUI for SQLite we have to use another GUI software ?

---

<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:** [23 April 2021 23:47 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/17 "2021-04-23T23:47:38Z")

</div>

> [@Martin10](#):
>
> Can we install DBeaver on RPI ?

Did you try a Google search?

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [26 April 2021 18:42 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/18 "2021-04-26T18:42:27Z")

</div>

Yes, but don't understand very much

---

<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:** [26 April 2021 20:47 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/19 "2021-04-26T20:47:14Z")

</div>

I imagine that few, if any, here have used DBeaver, never mind installed it on a Pi and how to install it is nothing to do with node-red. You might be better on a DBeaver or Pi forum.

> [@Martin10](#):
>
> Anyone have experiences with SQLiteStudio or DBeave for sensor data storage ?

In what way is DBeaver relevant to sensor data storage with node-red?

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [27 April 2021 18:56 UTC](https://discourse.nodered.org/t/sqlite-install-problem/43762/20 "2021-04-27T18:56:52Z")

</div>

SQLite is option in NR, but in order to use SQLite we have to install it first, right? So anyone who want to use it, first have to find a way to install it on his hardware (PC, RPI...). That's why, it occurred to me, that they will be people with that type of experience.

[Next page](https://discourse.nodered.org/t/sqlite-install-problem/43762.md?page=2)