# SQLite table deleting over night, any advice!

**URL:** <https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755>\
**Category:** General\
**Created:** [6 April 2021 10:11 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755 "2021-04-06T10:11:39Z")\
**Posts on this page:** 10\
**Page:** 2

<div class="post-metadata">

**Author:** ![Dgillett](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dgillett](https://discourse.nodered.org/u/Dgillett)\
**Post date:** [7 April 2021 12:39 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755/21 "2021-04-07T12:39:41Z")

</div>

I am storing it in /tmp/SQLite. Do you have a suggestion for a better folder?

---

<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:** [7 April 2021 12:49 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755/22 "2021-04-07T12:49:38Z")

</div>

Rather depends on the data. Personally, I try to keep all data related to Node-RED in the userDir folder (normally `~/.node-red`) so that everything is together. Don't use `~` in your nodes though as this is an environment setting and may not always work. Use the absolute path instead. Probably `/home/pi/.node-red` in your case.

---

<div class="post-metadata">

**Author:** ![Dgillett](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dgillett](https://discourse.nodered.org/u/Dgillett)\
**Post date:** [7 April 2021 12:58 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755/23 "2021-04-07T12:58:16Z")

</div>

Thanks for the help.

---

<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 13:48 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755/24 "2021-04-07T13:48:55Z")

</div>

Well I'm glad we spolved that mystery. Personally I would careae a pi/databases folder and stick it in there but anywhere but /tmp is good! 😄

---

<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:** [7 April 2021 13:49 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755/25 "2021-04-07T13:49:09Z")

</div>

> [@Dgillett](#):
>
> I am storing it in /tmp/SQLite.

/tmp is a virtual disk in ram, I think. So when you reboot it ceases to exist. Put it somewhere in your user area, possibly even in the .node-red folder, it won't do any harm there and you can just add it to your backup strategy backing up your flow file.

---

<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 13:57 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755/26 "2021-04-07T13:57:24Z")

</div>

P.s. Why are you rebooting the pi every night?  
I have one that has been up for 21 days  
another for 35 days  
another for 135 days

---

<div class="post-metadata">

**Author:** ![Dgillett](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dgillett](https://discourse.nodered.org/u/Dgillett)\
**Post date:** [7 April 2021 15:27 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755/27 "2021-04-07T15:27:34Z")

</div>

The image for the pi I used was from another application. The Cron job was added for that specific application, not sure why. I didnt look at them before i started this project.

---

<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:** [7 April 2021 16:53 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755/28 "2021-04-07T16:53:01Z")

</div>

Mine often stay up for years 🙂

---

<div class="post-metadata">

**Author:** ![webtop](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/webtop/32/38070_2.png) [@webtop](https://discourse.nodered.org/u/webtop)\
**Post date:** [13 April 2021 14:55 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755/29 "2021-04-13T14:55:23Z")

</div>

> [@Dgillett](#):
>
> go home for the day

How the heck did you manage to swing that? =)

---

<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:** [27 April 2021 14:55 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755/30 "2021-04-27T14:55:41Z")

</div>

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

[Previous page](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755.md?page=1)