Hello I have an SQLite databese in which i save temperature and humidity data with timestamps (epoch). I want to archive the databse by months. So that when november ends my data gets saved to another database for december etc. How can i achieve that?

[image] Parowek: data with timestamps (epoch) Is that defined as a datetime field in the DB? If so you can do a simple query on date to extract the data to a different DB. Then a delete query using the same date/time spec. [image] Parowek: So that when november ends my data gets saved to…

Have you considered using something like Influxdb rather than sqlite? Then you can always have previous months instantly accessible. Alternatively you can use one of the timer nodes, node-red-contrib-cron-plus is my favourite, to give you an event at the start of each month which you can use to do…

Well I’m a total newbie in database systems so I have no idea about how InfluxDB works. Guess I’ll have to find out. Thanks

This might help a little :slight_smile: How to effectively use InfluxDB - FAQs - Node-RED Forum (nodered.org)

But influxDB free plan allows to store data only for 30 days, am I right?

No, you want InfluxDB server. Self-hosted. No limits.

InfluxDB website literally says “server less”. I think I’m missing something

[image] Parowek: InfluxDB website literally says “server less" Can you give us a link to that please?

Nevermind, I had to be on InfluxDB Cloud website. Anyway, i downloaded InfluxDB and hope to sort it out soon.

Node-RED

Node-RED Forum

How to archive a SQLite database

General

TotallyInformation 4 November 2022 16:46 5

This might help a little

How to effectively use InfluxDB - FAQs - Node-RED Forum (nodered.org)

Topic		Replies	Views
Write a monthly temperatures File General	25	465	5 June 2025
Which database to choose for storing data (noob-friendly) Industrial	4	1087	11 July 2022
Influx retention policy and remote storage location General	6	1726	21 January 2021
A few MQTT topics to SQLite General database , mqtt	20	5693	6 May 2019
Node-Red-Influxdb with Shelly 3EM General	1	935	10 May 2022

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

How to archive a SQLite database

Related topics