Page 1 of 1

Option to keep sensor data for x number of years

Posted: Friday 23 February 2018 14:38
by ben53252642
I would really like to see an option to keep sensor data for x number of years.

At the moment my understanding is that data is only kept for 1 year in the database.

I'd really like to store things like my weight, sleep data and average living room noise level for longer than this. 8-)

Re: Option to keep sensor data for x number of years

Posted: Friday 23 February 2018 15:41
by Egregius
Push it to a MySQL database and you can keep whatever you want.

Re: Option to keep sensor data for x number of years

Posted: Friday 23 February 2018 17:59
by ben53252642
Yep, this is what I am currently working on right now... :D

Still it would be nice to have the option in Domoticz, I'd go another step and say it would be great for Domoticz DB to work from MySQL but I don't think its happening anytime soon. :(

Re: Option to keep sensor data for x number of years

Posted: Friday 23 February 2018 19:03
by Xztraz
influx and grafana is also a popular combination to store and graph stuff over longer time with a bit better resolution and such.