[sqlite] Compiler warning - signed unsigned mismatch if enable sorter references defined

Compiling the amalgamation (some previous versions including the current Version 3.25.2 (2018-09-25)) generates the following warning with SQLITE_ENABLE_SORTER_REFERENCES defined.  The build works fine and always has so this is really just benign. The warning is: sqlite3.c(106816): warning

Re: [sqlite] Ajqvue v2.10 Released

> Looks good. > > Would pronouncing ajqvue -- achoo? -- send Mr. Mxyzptlk back to the 5th > dimension for 90 days? > Ned Perhaps if it was said three times while clicking your heels together. Ajqvue - A Java Query Vue danap. ___ sqlite-users mailing

Re: [sqlite] [EXTERNAL] Persistent snapshots and rollbacks

Hi! On 2018-10-08 08:11, Hick Gunter wrote: > 1) Include an "inserted at" timestamp column in each table > 2) create a history table for each real table > 3) use before triggers to copy the old record to the history table and set > the "inserted at" timestamp Using triggers is an interesting

Re: [sqlite] [EXTERNAL] Persistent snapshots and rollbacks

1) Include an "inserted at" timestamp column in each table 2) create a history table for each real table 3) use before triggers to copy the old record to the history table and set the "inserted at" timestamp If you use temp triggers, you can even keep the history tables in a separate database