That's not the first time Gary's brain has been right, and mine has not been.
There is no "out of the box" way to do that, but you could write a service, bind it to NEW_ARCHIVE_RECORD events, then have it write to the 2nd database. -tk On Wed, Oct 2, 2019 at 3:26 AM Wout Vdh <[email protected]> wrote: > Thank you for your feedback. > Gary's brain is right! ;-) I'd like to store the data into 2 different > databases (1 SQLite and one MySQL) and not use 2 different databindings in > my reports. > Is there a way to do this? > > Many thanks > Wout > > On Wednesday, 2 October 2019 03:04:54 UTC+2, gjr80 wrote: >> >> Maybe it's just my brain, but when I first read the OP I thought the >> question was along the lines of dual storing of archive data rather than >> reporting/plotting from multiple archives. Might be handy if the OP >> clarified. >> >> Gary >> >> On Wednesday, 2 October 2019 09:09:19 UTC+10, Thomas Keffer wrote: >>> >>> Yes, you can do this. In fact, there's an example in the Customization >>> Guide of using MySQL and SQLite simultaneously. See the section *Using >>> multiple bindings >>> <http://www.weewx.com/docs/customizing.htm#Using_multiple_bindings>*. >>> >>> On Tue, Oct 1, 2019 at 2:35 PM Wout Vdh <[email protected]> wrote: >>> >>>> Hi >>>> >>>> Is it possible to have multiple data_bindings to archive data in SQLite >>>> and MySQL at the same time? >>>> I can't define the parameter twice and I can't use a list (data_binding >>>> = wx_binding, mysql_binding). >>>> >>>> Best regards >>>> Wout >>>> >>>> -- >>>> 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/890eeb53-2201-47bb-89ac-169bb56bf92e%40googlegroups.com >>>> <https://groups.google.com/d/msgid/weewx-user/890eeb53-2201-47bb-89ac-169bb56bf92e%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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/f425cba5-8560-4f2b-a306-197a1a4f1fa9%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/f425cba5-8560-4f2b-a306-197a1a4f1fa9%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEAkAE4tRBHWcxdzHhtFqJ0U%2BUN951ur%3DLX7e%2BYV4CqqpQ%40mail.gmail.com.
