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
Save payload in sqlite data base General	5	593	14 January 2020
Which database to choose for storing data (noob-friendly) Industrial	5	795	9 September 2022
Sqlite Vs InfluxDB & Grafana General	7	4971	3 August 2018
I want to fetch data from sqlite in batches after certain interval of time General database , function-node , mqtt	11	141	20 March 2023
How to effectively use InfluxDB FAQs database	23	2596	15 March 2021

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