MySQL Support

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

PierreT
Posts: 51
Joined: Wednesday 03 May 2023 10:12
Target OS: NAS (Synology & others)
Domoticz version:
Contact:

Re: MySQL Support

Post by PierreT »

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.
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 1 guest