Thanks guys. Seems straightforward, and I will post results of my experience doing this! Stephen On Wednesday, February 10, 2021 at 12:06:33 PM UTC-8 gjr80 wrote:
> Hi, > > To move from using SQLite to MariaDB you might want to have a read of the > Transfer > from sqlite to MySQL wiki entry > <https://github.com/weewx/weewx/wiki/Transfer%20from%20sqlite%20to%20MySQL>. > As far as I know the approaches covered there are still valid. > > Gary > On Thursday, 11 February 2021 at 04:56:12 UTC+10 Stephen Rogers wrote: > >> Hi there, my first post as groups member. I am a software developer >> working primarily in Javascript/Vue/Express/MariaDB stack. >> >> I have been running WeeWx for almost 2 years, on Raspberry Pi 3/Raspbian >> Linux, using SQLite for data storage. >> >> I now want to be able to routinely pull specific dimensions of data >> (starting with temperature) from the WeeWx database and integrate that data >> into my own analytics program. SQLite, as far as I know, cannot be >> remotely accessed so I will need a different database that can. >> >> I'd like any advice you can provide on the most expedient way to >> accomplish my goal. Example idea: >> >> 1. install MariaDB on the WeeWx Pi >> 2. reconfigure WeeWx to use MariaDB using essentially the same steps >> as a fresh install (should I do a fresh WeeWxinstall?) >> 3. Pull data from SQLite and migrate it to MariaDB (best utility for >> doing this?) so I have all the almost 2 years of collected data available. >> >> I could also dump the SQLite data and reconfigure a different approach >> for making the new data available to my application, e.g. MQTT. >> >> Appreciate any advice you WeeWx veterans may have for me. >> >> >> -- 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/28cb1b19-9bd0-40f0-b621-7ae4295949ccn%40googlegroups.com.
