I would like to store some heating tables into dynamic tables instead of lots of items.
The tables contain the following data sets:
Heating.items Number Heating_RoomA_Time1 Number Heating_RoomB_Value1 ...
Time1 is transformed into a time with steps of 30min:
Time.map 1=00:30 2=01:00 ...
I have several tables for different seasons. With a cronjob I send the data to the thermostat. Currently I have everything stored in around 400 items. The items are accessible via the ui and persistet over a database. I would like to add special tables for weekends or holidays, but then the number of items will increase further.
Is it possible to store this data in a table or array, that is accessible via the ui and persistet into the database. This would be a more dynamic way, than creating lots of items.
What is the best approach to do this?