Thanks! I do, also, have some graphical access to my solar data, but it involves logging in to my system provider's site - not a real problem, but inconvenient. Time alignment is not a problem - my local energy monitoring hardware records data to its memory on the minute, and I can access it very shortly thereafter. I think that I will probably add some functionality to my current user-written weewx services to grab and record a summary of the last 5 minutes' data for each archive record.
On Tuesday, July 15, 2025 at 9:54:17 PM UTC-4 Cameron D wrote: > 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/6de4a13d-fa08-4e6e-9913-ea1e856b7bcbn%40googlegroups.com.
