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/b868f527-f9bb-436d-a562-e5c0cfd1b299o%40googlegroups.com.
