Hi. Sorry, I wasn't clear. I want to use MySQL as I'm MySQL DBA trained. OK, so I was, about 5 years ago. And I'm a little too long in the tooth to learn new stuff.
On Monday, 21 January 2019 10:23:16 UTC, Andrew Milner wrote: > > 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.
