I hope my question is not "off topic" really. Many users here are using node-red to store energy (gas, water, electricity meters...) consumption data to the sql table. The simple table to store kWh consumption can look like this: |ID|timestamp |kWh | |1 | 2019-07-31 14:24:25 | 270.8| …

Wattmeter data from sqlite

ukmoose 7 August 2019 16:10 2

https://www.codeproject.com/Questions/878973/sum-of-values-between-two-dates

Topic		Replies	Views
Reading data from an sqlite server base on time and date General sqlite	6	63	16 July 2025
Energy Dashboard + SQL General	16	175	23 December 2024
Retrieve Data from sqlite database based on the input time from date picker and moment nodes Dashboard	8	895	18 April 2022
Calculate hourly consumption General	18	4369	18 June 2020
Data get from SQLite General	52	1505	7 March 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.

Wattmeter data from sqlite

Related topics