The database granularity, contents and structure is identical for sqlite3 and MySQL.
The archive records are stored at 'archive interval' granularity. There are also 'daily' tables for each of the reading type which give max and min for each calendar day. If you can use MySQL then you should also be capable of using sqlite3. How would you plan to retrieve the data from MySQL? Use the same method/approach to retrieve it from sqlite3 (Granted, you may need to install sqlite3 on your weewx computer first) I guess I did not fully understand how/why going to MySQL would enable you to get information from the database easier than from sqlite3. The select statements are nearly identical - albeit a little different for date\time fields. On Monday, 21 January 2019 12:03:18 UTC+2, Cycle London wrote: > > Hi, > I've been running my station for just over a year, and would like to > switch from sqilite to MySQL on a different server. To be clear, what I > mean by that is: I want to use a 'production' MySQL instance that is on a > 'live' server. > > A couple of questions, if I may. > > 1. What 'granularity' of data is available inside the database? I ask > because today for example, 21 January, I'd like to know what the > temperature was like last year on the same date. In the weewx GUI, I can > see that the coldest day of the month of January 2018 was the 30th, but I > can't see what the temperature was on the 21st. Is this inside the DB? > I know nothing of sqlite, so even if it's in there, I can't get it out. > > 2. Is there an easy, foolproof way of switching to MySQL? I can do > Linux, I can do MySQL but I don't know python or sqlite. A quick method of > switching would be great. > > Many thanks. > -- 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.
