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
A few MQTT topics to SQLite General database , mqtt	20	5557	6 May 2019
Saving informations General	11	461	30 August 2018
Influx retention policy and remote storage location General	7	1698	22 March 2021
Insert data in sqlite or mssql General	8	918	12 July 2020
Data storage and defined time checking General	4	424	29 March 2019

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