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/4e169a73-1376-46b4-b5ea-dd4c499384b8n%40googlegroups.com.
