I have the same issue and have never bothered, mainly because I already had plotting interface to my solar data. I use weather data to feed into the solar charts. My difficulties are: time is not aligned and the interval is different. Otherwise, since my weewx data is in mariaDB, I could run a cron job to regularly UPDATE a few fields in the weewx records. I would not want to try that with sqlite db, although it might be safe if you have a 5-minute interval.
If you have different intervals, I think the "simplest" path might be to have a new separate DB in weewx style that you duplicate the solar data into and then plot from that. That way weewx can automatically handle its aggregate data tables. On Wednesday, 16 July 2025 at 6:09:57 am UTC+10 Peter Fletcher wrote: > I have real-time data from my PV Solar installation being saved on a MySQL > (actually mariadb) database on a NAS within my network. It would be nice if > I could, in real time, pull the values in a couple of fields from this > database and save them in my weewx database for trend display. I know that > I can create a second weewx binding to a MySQL/mariadb database, but the > structure of the database in question does not 'look' anything like that of > a normal weewx database, so the default Manager would presumably not be > able to work with it. Is there, or is it reasonably possible to write, a > Manager that simply implements SELECTs on the managed database and returns > the results to a user-written service that processes them? If not, one > could presumably import and use the regular MySQL connector within the > service to grab the needed data. -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/weewx-development/2fcb2f2e-068c-4ab7-8dce-c710d840adccn%40googlegroups.com.
