Hi Greg,
I intended to respond to this message of yours some weeks ago, but
apparently forgot to do so.
Basically, I think it's a good idea to look carefully at possible use of
SQLite for several tasks in WSJT-X: logging and a replacement for
CALL3.TXT are two good possibilities.
Have you gone any further with the idea?
-- Joe, K1JT
On 8/18/2015 1:43 PM, KI7MT wrote:
> Just for kicks ( and learning ), I've been playing with Sqlite3 and
> adding support to a WSJT.db in addition too flat files (ALL.TXT,
> Loggings, etc) JT and WSPR.
>
> At present, I'm using WSJT for testing and such, but for all you C/C++
> dev's, the Sqlite3 API is fairly straight forward.
>
> Maybe this would be a good project for someone ( one of the core
> developers ) to take on and add the logging functionality to WSJTX. SQL
> is well supported in QT.
>
> I think there's a lot of benefit to having a simple .db file for all
> logging. I can't really see any downside to it, it's fast, no server
> config needed, it's a single file and there are many Sqlite DB
> Applications for browsing data / table structures / SQL statement
> generation available for all the Major distributions (Win/*Nix/Mac etc).
>
> I think JT-Alerts uses Sqlite for it's logging ( I'd have to verify that
> though ).
>
> Just a thought.
>
> 73's
> Greg, KI7MT
>
> On 08/18/2015 06:34 AM, Michael Black wrote:
>> I use this little utility to find records in all.txt and format them a bit
>> to make them easier to view and grep a 2nd time if you want a specific date
>> for example.
>> It adds the date and lines up the columns better.
>> You'll have to change the getenv for Linux. I don't know what it uses.
>>
>> I also use a batch file to drive this and save a few more keystrokes.
>> alltxt w9mdb %1
>>
>> 73
>> Mike W9MDB
>>
>> #include<stdio.h>
>> #include<string.h>
>>
>> char *strtoupper(char *s)
>> {
>> char *s2 = strdup(s);
>> char *s3 = s2;
>> while(*s) {
>> *s2++ = toupper(*s++);
>> }
>> return s3;
>> }
>>
>> int main(int argc, char*argv[])
>> {
>> if (argc != 3) {
>> printf("Usage: %s mycall findcall\n",argv[0]);
>> return 1;
>> }
>> char *mycallsign = strtoupper(argv[1]);
>> char *findcallsign = strtoupper(argv[2]);
>> char date[4096];
>> char path[4096];
>> char buf[4096];
>>
>>
>> sprintf(path,"%s/AppData/Local/WSJT-X/ALL.TXT",getenv("USERPROFILE"));
>>
>> FILE *fp = fopen(path,"r");
>>
>> while(fgets(buf,sizeof(buf),fp)) {
>> if (buf[4]=='-') { // then this is a date
>> strncpy(date,buf,11);
>> }
>> else if (strstr(buf,mycallsign)&& strstr(buf,findcallsign)) {
>> // non-date line
>> if (strstr(buf,"Trans")) { // make this a consistent
>> fixed format
>> char *p=strtok(buf,":");
>> char *p2 = strtok(NULL,"\r\n");
>> printf("%s %-36s: %s\n",date,p,p2);
>> }
>> else {
>> char *field1 = strdup(buf);
>> char *field2 = strdup(buf);
>> field1[4]=0;
>> strcpy(field2,&field2[5]);
>> printf("%s %s
>> %s",date,field1,field2);
>> }
>> }
>> }
>> fclose(fp);
>>
>> return 0;
>>
>> }
>>
>> -----Original Message-----
>> From: Alan VK2ZIW [mailto:[email protected]]
>> Sent: Tuesday, August 18, 2015 5:03 AM
>> To: WSJT software development
>> Subject: Re: [wsjt-devel] WSJT-X, some s/w little issues
>>
>> Hi,
>>
>> Can we have the date in "ALL.TXT" please ?
>>
>> This is the balloon PS-49 near New Zealand:
>>
>> bash-4.3$ cat ALL_WSPR.TXT | grep VK3
>> 150816 1500 3 -13 -0.2 10.1402676 VK3YT RF15 27 2 1 0
>> 150816 2100 2 -21 -0.7 10.1402686 VK3YT RF46 27 0 1 0
>> 150816 2200 2 -24 -0.5 10.1402686 VK3YT RF46 27 0 1 0
>> 150818 0700 2 -22 -0.1 10.1402676 VK3YT BF86 27 2 2 0
>> 150818 0800 1 -24 -0.2 10.1402664 VK3YT BF86 27 1 100 0
>> bash-4.3$ cat ALL.TXT | grep VK3
>> 0702 -17 -0.1 1004 @ VK3YT1CB38S40
>> 0802 -21 -0.1 1004 @ VK3YT1D738RU0
>> bash-4.3$ ls -l ALL*
>>
> <snip>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> wsjt-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/wsjt-devel
------------------------------------------------------------------------------
_______________________________________________
wsjt-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wsjt-devel
