# SQLite - 2 problems

**URL:** <https://discourse.nodered.org/t/sqlite-2-problems/68983>\
**Category:** General\
**Created:** [13 October 2022 12:48 UTC](https://discourse.nodered.org/t/sqlite-2-problems/68983 "2022-10-13T12:48:11Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Giamma](https://avatars.discourse-cdn.com/v4/letter/g/e47774/32.png) [@Giamma](https://discourse.nodered.org/u/Giamma)\
**Post date:** [13 October 2022 12:48 UTC](https://discourse.nodered.org/t/sqlite-2-problems/68983/1 "2022-10-13T12:48:11Z")

</div>

Hi,  
to make you understand I need to tell you my configuration ....  
I have one Raspberry Pi4 (so Raspberry original) with node red-mqtt-zigbee2mqtt and this is the primary hardware for my home automation.  
I have also one pc (so Kubuntu) with node-red and this is my test environment.  
I test here the code changes and after I connect node red on Raspberry to implement changes ....  
Yesterday I installed on pc kubuntu SQLite,  
I created one database, enter the data and after I copied the db into a folder of Raspberry shared with pc-Kubuntu.  
I don't want to install SQLite on Raspberry but I would like to select and update data only with node-red-node-sqlite 1.0.3.  
Well, this are my two problems:

1. with a query on Raspberry I update one record but on pc-kubuntu I don't see the change of the record (with a query select), I have the old value. I need to deploy and so I have the real data.

2. I cannot insert a record into database from pc-kubuntu with a query of insert because I have this error:

![err](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/d/2df56f602170d26dbeeba517ac1232c7adfe3743.png)

The first problem is not a big problem, but the second is a very big problem because I would like to create query of insert on pc-kubuntu and not on Raspberry; on raspberry I select and update only .....

How can I fix this problems?

---

<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:** [13 October 2022 13:13 UTC](https://discourse.nodered.org/t/sqlite-2-problems/68983/2 "2022-10-13T13:13:40Z")

</div>

What are the `sqlite` nodes configurations on both node-red's?

---

<div class="post-metadata">

**Author:** ![Giamma](https://avatars.discourse-cdn.com/v4/letter/g/e47774/32.png) [@Giamma](https://discourse.nodered.org/u/Giamma)\
**Post date:** [13 October 2022 13:20 UTC](https://discourse.nodered.org/t/sqlite-2-problems/68983/3 "2022-10-13T13:20:11Z")

</div>

This:

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

---

<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:** [13 October 2022 13:21 UTC](https://discourse.nodered.org/t/sqlite-2-problems/68983/4 "2022-10-13T13:21:28Z")

</div>

That is the node, how have you configured them on the two systems?

---

<div class="post-metadata">

**Author:** ![Giamma](https://avatars.discourse-cdn.com/v4/letter/g/e47774/32.png) [@Giamma](https://discourse.nodered.org/u/Giamma)\
**Post date:** [13 October 2022 13:29 UTC](https://discourse.nodered.org/t/sqlite-2-problems/68983/5 "2022-10-13T13:29:08Z")

</div>

This is Raspberry configuration:

![raspconf](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/b/7b889f62ff3c64f795fb85d484700b47a4c7bcb7.png)

and this is Kubuntu configuration:

![kubuntuconfig](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/7/1707103304d4a22ee71ecc3187a8535a62a2add7.png)

The path on Kubuntu refers to a folder on Rspberry shared with smb and mount on Kubuntu.  
I have all the permission for this folder for Kubuntu; in this folder I have more txt files and I can read, write, delete without 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:** [13 October 2022 14:30 UTC](https://discourse.nodered.org/t/sqlite-2-problems/68983/6 "2022-10-13T14:30:27Z")

</div>

I did some playing with a DB on a Pi and NR running on both the Pi and a Mac. At one point I hit an IO error and did some searching using 'sharing sqlite db on two computers' and basically this summerizes the results:

`SQLite’s use-case is as a single-application datastore. It does this very well, but it was not intended or designed to be a client-server database engine.`

Here is another good post to read [SQLite Forum: Sharing a SQLite3 Database](https://sqlite.org/forum/info/c386e7df7783c0f211524fc84a62f75cd5ffcff636e4e607cb79b0d9e86bc649)

---

<div class="post-metadata">

**Author:** ![Giamma](https://avatars.discourse-cdn.com/v4/letter/g/e47774/32.png) [@Giamma](https://discourse.nodered.org/u/Giamma)\
**Post date:** [13 October 2022 14:42 UTC](https://discourse.nodered.org/t/sqlite-2-problems/68983/7 "2022-10-13T14:42:44Z")

</div>

Ok, I understand ...  
Thank you very much for help ......

---

<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:** [12 December 2022 14:42 UTC](https://discourse.nodered.org/t/sqlite-2-problems/68983/8 "2022-12-12T14:42:55Z")

</div>

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