Domoticz

It would be nice to split the file domoticz.Db in 2 functionalities:
1/ link to any technical references (ID,..)
2/ link to any information like sotring date link to information example (weather,n...)
this allow a roll back or a save with different rules

example 2 days ago their were a problem for me on a beta update for Aeon Labs USB
To do a roll back on this, I lost a day of information stored like water follow up, electricity,...

hope it is clear

mrelfire wrote: ↑Monday 01 March 2021 11:28 It would be nice to split the file domoticz.Db in 2 functionalities:

The information is now split on a table level.
Because in sqlite it is relatively easy to restore tables from one database to another (backup database -> live database), there is no real need to split the information on a database level which is quite lucky because it would be a major task to split it like that and would make the risk of alignment problems much higher.

I do not share the basics:
- it is easier to restore a file rather than goinh inside the database and look tables by tables to restore some data
the splitting is just by logic :
1 file to technical strucuture / hardware
=> this one is the heart of domoticz which can be impacted by an upgrade which doesn't work
=> easy to roll back
1 file to data link to your device like temperature, humidity,...
=> this one is independant
=> no consequences on a upgrade or roll back wich fail

So make a suggestion how to split-up the current database into 2 new databases.