I had a need for an sqlite database to be generated at the same time as the mysql one that I actually use. It's flipped compared to your case though - mysql is my main database, sqlite is the duplicate.
https://groups.google.com/forum/#!topic/weewx-development/-rOoK6oE1xY I haven't taken it any further than that, very rough, version as it works well for the intended purpose. ie: I get a simple database that I can transfer easily and that allows the wxobs demo to work on the remote, non weewx, machine. I also get to keep the main mysql database for its other benefits. Cheers Glenn rorpi - read only raspberry pi & various weewx addons https://github.com/glennmckechnie On 4 January 2018 at 03:57, Chris Alemany <[email protected]> wrote: > So my understanding then is that it is an either/or proposition. Either you > use sqlite or mysql, but never both? > > On Jan 2, 2018, at 2:30 PM, Neville Davis <[email protected]> > wrote: > > Yes I for one use to just dump and save but when I decided to use mySql I > also decided to use replication, which I set up on a QNAP NAS... it has > worked without fault as a realtime backup of the db on my pi. > > Nev > > On Tuesday, January 2, 2018 at 9:05:08 AM UTC+10, vince wrote: >> >> On Monday, January 1, 2018 at 12:56:27 PM UTC-8, Chris Alemany wrote: >>> >>> Is it possible to have a concurrent 'clone' of the local database and a >>> remote database? >>> >> >> Switching to mysql will get you that kind of functionality, albeit at the >> added complexity and compute capacity needs that mysql brings with it. >> >> (cloud example - amazon RDS with multi AZ enabled is essentially this) >> >> I guess the question is how important it is to you. Many folks just make >> periodic db dumps of their sqlite3 db(s) and stash them in Dropbox or the >> like. There's something to be said for the simplicity of sqlite3. > > > -- > 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/xCWvbw-4l_I/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. -- 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]. For more options, visit https://groups.google.com/d/optout.
