My Weewx is somewhere with a pretty terrible internet connection. Disconnects a lot. So I need a database on the WeeWx host, or I'd lose a ton of intervals. But I also run various programs at home that reference the archive, and they won't work when the WeeWx host has lost internet.
So I need two copies of the archive available at all times, one for each location. I use mariabackup, however that doesn't clone the database so much as package it. It needs to be extracted to be used, and that would be impractical to do every 5-10 minutes. There might be a way to mirror a database (without querying the entire db each time), but I don't know it. I'm open to ideas, and I really appreciate everyone taking the time to respond. Thanks On Wed, Sep 14, 2022 at 6:01 PM vince <vinceska...@gmail.com> wrote: > On Wednesday, September 14, 2022 at 3:50:16 PM UTC-7 Seth Ratner wrote: > >> That's an option, though I would want the databases to be mirrored +/- >> one or two archive intervals, and that might get messy with mariabackup. I >> have some services that will run at another location (Home Server) using >> the archive data, but due to a bad internet connection I can't rely on >> accessing the database on the Weewx computer (Farm) directly. >> >> > Not understanding the 'why' at all on this one...but perhaps MQTT might be > one possibility. Publish from the weewx site and subscribe on the other > site. > > >> Separately, could you point me to any documentation on the AQI and >> forecast databases in WeeWX? I'd like to go down that rabbithole a bit. >> >> > There are no such things in core weewx. You have to pick your > extension(s) of choice and check out the code, or alternately spin up a > simulator VM and add them to a throwaway instance of weewx perhaps... > > > -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/weewx-user/PPGSbaoX_ns/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > weewx-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/92149663-4379-405c-b29f-f62efca19362n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/92149663-4379-405c-b29f-f62efca19362n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAHTssjNabT8X%2B304Nv9Dv1mGTbaArgnXRsiz%2B66CdjEZ%3DHMw5A%40mail.gmail.com.