From what I have seen/read, it would require direct database update. The challenge will be to have both short_term and stats aligned. I am not sure if SQL integration allows to write, I know Nodered does but that just makes it even more complex as integration/
I am looking for a similar thing related to the EDF (MyED) integration which only gives yesterday but have not had the time to look at it as low prio (using linky).
I will follow your French thread as well
EDIT: SQL won’t ‘insert’ with my mariadb recorder… looking at some other threads they use shell command (with mysql client installed) or python scripts, example…