the simplest thing is to install sqlite3 https://sqlite.org/cli.html
and give a command such as sqlite3 fullpathtosdbfile then select * from archive order by dateTime desc limit 10; should give you the last 10 entries On Thursday, 1 August 2019 15:19:49 UTC+3, Richard Rosa wrote: > > What the manual says and what is available on my system don't quite jive. > The ONLY wview-archive.sdb that I can find was last updated 5 years ago. > > It has been running for the past 5 years WITHOUT generating this file. > Unless the file has been rendered invisible, it does NOT exist on my > current system. > > I would LOVE to try to extract the data from the existing SDB file, but as > I indicated, > I do not know ANYTHING about SQL databases (or how to manipulate them). > If you can suggest the correct commands or operations, I will be more than > happy to give it a shot. > > BTW, I finished my script last night. Took about 10 seconds to create the > CSV file, and about 10 minutes to import everything. > > So far, it looks like most of my info got imported. As expected, some > information (such as inside temp/console voltage/etc) is not there, but I > can live with that. > > > Thanx. > > > Richard Rosa > > > > > On Wednesday, July 31, 2019 at 9:52:03 PM UTC-4, Andrew Milner wrote: >> >> I don't think you have an alternative, you have something different. >> >> From wview manual: >> *Day history Table (wview-history.sdb)* >> >> *Overview* >> >> This table is generated internally by wview to avoid having to compute >> the daily summary records used for the yearly charts every time wview >> starts. This was not a time concern with the flat WLK files but became more >> costly when we started storing data in SQLite3. The external use or utility >> of this table is limited at best. >> >> *Regeneration* >> >> To regenerate the NOAA database: >> >> ---------------------------------- >> >> I think you need to double check with wview, but the manual CLEARLY says >> the wview archive is wview-archive.sdb and that wview-history.sdb is an >> internal database used by wview for the yearly reports. >> >> >> >> On Thursday, 1 August 2019 01:45:27 UTC+3, vince wrote: >>> >>> On Wednesday, July 31, 2019 at 3:31:01 PM UTC-7, Richard Rosa wrote: >>>> >>>> It looks like I have an alternative: >>>> >>>> Thankfully, WVIEW saved a bunch of .txt files for every logged day >>>> (almost 4k). Although I know very little about SQL databases, I am pretty >>>> decent at converting text file formats to CSV files. >>>> >>>> >>>> >>> Still think a sqlite dump, a little editing, and a sqlite restore is the >>> right move here, but of course do what you think is right for you. >>> >>> >>> >> -- 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/b2acdf61-00aa-4e7f-b199-22ec9fccdca2%40googlegroups.com.
