Hi Gert, I use mysql and weewx and grafana can us mysql as a data source (as has been mentioned above by Michael)
It works well. I have used this was for over a year. On Saturday, 31 October 2020 at 02:08:11 UTC+11 vince wrote: > On Thursday, October 29, 2020 at 11:32:52 PM UTC-7, [email protected] > wrote: > >> I already get data inserted into InfluxDB via Matthew's script and it >> works fine. I was interested in getting my old data visible in Grafana. >> >> > Sure. Be careful that you don't have influxdb set to auto-prune aged > data. I just keep 6 months worth in mine. > > Unfortunately, it is not possible to use Sqlite3 as a data source yet. It >> could be that there was already someone who had been through the same >> process with old data, so therefore my question. >> > > Sorry, not aware of one. It wouldn't be too hard to write some kind of a > one-time catchup program if you know the database format the weewx plugin > you're using to get your realtime data into weewx. You likely want to be > consistent so your grafana dashboards can pick any time range you have data > for. > > Basically you'd do a select on your archive table and postprocess the > output into the format influxdb wants to see for batch uploads of records. > Definitely doable with a few hours work I think. > > (if you don't get there by Christmas, ping me via email and I could maybe > give it a try that week when I'll have time available) > > > BTW, are there some advantages to using Telegraf / MQTT instead of >> Matthew's plugin. >> > > It's not weewx-centric and it's more IoT mainstream, but no, not really in > your case. If what you have works, keep using it. > > The downside of telegraf/MQTT is that I've found that sometimes it loses > the subscription and data doesn't come in. For my raspi IoT sensor things > here and my former WeatherFlow gear, I changed my code to write to > influxdb directly, which I'm guessing is what Matthew does. > > For my Davis VP2 weewx=>influxdb stuff I stuck with the MQTT extension and > the telegraf path, mainly because it was stable. Once I got it working > locally, I figured "if it ain't broke don't fix it". > > > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/3af16997-84c1-4bfb-b3d0-9e0435d41cd2n%40googlegroups.com.
