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…

TotallyInformation 4 November 2022 16:46 5

This might help a little

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

1 Like

Topic		Replies	Views
Write a monthly temperatures File General	25	271	5 June 2025
Which database to choose for storing data (noob-friendly) Industrial	5	993	9 September 2022
Influx retention policy and remote storage location General	7	1657	22 March 2021
A few MQTT topics to SQLite General database , mqtt	20	5535	6 May 2019
Node-Red-Influxdb with Shelly 3EM General	2	912	9 July 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