Domoticz

sjb66 wrote: ↑Sunday 29 October 2023 20:13 SQL Lite is good for normal Domoticz operation but the ability to "Push Data" to MYSQL would allow you have custom sample intervals and retention periods for specific inputs.

Those properties are not defined by the database but by the application, including that they are global settings. At the expense of a relatively huge amount of additional resources required all that MySQL would add is the possibility to set triggers at the database level, which you can also create in Domoticz with the added freedom that the target doesn't have to be part of the same database. Pushing data to a different database of any type is really not that hard, e.g. you can do an HTTP call to a simple SOAP service, or a system call to sqlcmd.