split domoticz.DB in 2 files linked to technical/information

Use this forum to discuss possible implementation of a new feature before opening a ticket.
A developer shall edit the topic title with "[xxx]" where xxx is the id of the accompanying tracker id.
Duplicate posts about the same id. +1 posts are not allowed.

Moderators: leecollings, remb0

Post Reply
mrelfire
Posts: 40
Joined: Wednesday 03 August 2016 15:12
Target OS: Windows
Domoticz version:
Contact:

split domoticz.DB in 2 files linked to technical/information

Post by mrelfire »

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 ;)
User avatar
waaren
Posts: 6028
Joined: Tuesday 03 January 2017 14:18
Target OS: Linux
Domoticz version: Beta
Location: Netherlands
Contact:

Re: split domoticz.DB in 2 files linked to technical/information

Post by waaren »

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.
Debian buster, bullseye on RPI-4, Intel NUC.
dz Beta, Z-Wave, RFLink, RFXtrx433e, P1, Youless, Hue, Yeelight, Xiaomi, MQTT
==>> dzVents wiki
mrelfire
Posts: 40
Joined: Wednesday 03 August 2016 15:12
Target OS: Windows
Domoticz version:
Contact:

Re: split domoticz.DB in 2 files linked to technical/information

Post by mrelfire »

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
EddyG
Posts: 1042
Joined: Monday 02 November 2015 5:54
Target OS: -
Domoticz version:

Re: split domoticz.DB in 2 files linked to technical/information

Post by EddyG »

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

Who is online

Users browsing this forum: No registered users and 1 guest