Multisite and mysql

[juancabrio]

I love this utility and the tweaks made here. I'm thinking I could use this across all my sites if I had multisite support and MySQL.
I imagine an RPI at every site, all reporting home to a single DB. That would be cool !

[leiweibau]

Yes, would be cool, but would significantly increase complexity. I will not implement it, at least from today's perspective :D

[leiweibau]

This is not even about replacing sqlite3 with MySQL. The challenge is how Pi.Alert works in the database (single user vs. multiuser). The current way of working is not designed for multiuser database transactions.

The only "quick" approach I can think of here would be an extra database for each Pi.Alert on the MySQL server. But then you need a special interface to look at the data of all databases. And also this special case would mean a lot of work, which I can't do as a small hobby developer.

[juancabrio]

Yep, I agree. It would almost need a rewrite from scratch. I will remain content querying my remote sites with some scripts and such.

[jokob-sk]

Sorry to comment on a closed issue, just thought of a possible workaround - You could use a Home Assistant instance as your hub - I noticed @leiweibau added support for HA so if you @juancabrio are already using HA, this might be a way forward. I did something similar in my fork with MQTT as well. Just food for thought.