Re: [sqlite] Round-tripping SQLite back and forth between text representation.

On 7/11/18, Randall Smith wrote: > > My wishlist is: > > (o) Allow humans to view the contents of a DB without custom tools. SQLite database file are binary. That is a necessity in any format that needs to store binary data. On the other hand, the SQLite database file format is carefully and

Re: [sqlite] Round-tripping SQLite back and forth between text representation.

On 11 Jul 2018, at 6:01pm, Randall Smith wrote: > (o) Allow humans to view the contents of a DB without custom tools. > (o) Have a way to see what has changed between V1 and V2 of a database, e.g., > for a "change review." SQL is based around Ted Codd's view of relational databases. One of

Re: [sqlite] Minimum Delta Time

Paul; I can't use a trigger without having to create it, do the update, then destroy the trigger. There are form elements that can change these times (I submit at time start at 3pm, but I actually started at 2pm). If the time spent is less than 5 minutes, then David; I like that. Didn't

Re: [sqlite] Round-tripping SQLite back and forth between text representation.

On 2018/07/10 8:27 PM, Randall Smith wrote: > One follow-up: Do you know if the dump output is "deterministic" over > time? That is, if I diff two dumps taken at different times, will the > unchanged material be in the same order and so on? Or is the ordering > effectively random? > My

Re: [sqlite] Minimum Delta Time

How about just using a trigger to check if endtime is < starttime+10 and updating if it fires Paul www.sandersonforensics.com SQLite Forensics Book On 11 July 2018 at 17:09, David Raymond wrote: > For a minimum of 10 minutes it'd be something like

Re: [sqlite] Minimum Delta Time

For a minimum of 10 minutes it'd be something like update TimeEvents set EndTime = max( current_timestamp, datetime(StartTime, '+10 minutes') ) where EventID = ? and (EndTime is null or EndTime = ''); -Original Message- From: sqlite-users

Re: [sqlite] Minimum Delta Time

On 11 Jul 2018, at 3:25pm, Stephen Chrzanowski wrote: > interest is modifying the Stop part so that at a minimum, there is a 10 > minute delta between the start and end time. So if I start a timer at > 11:00, then stop at 11:01, I want the database to update the end time to > 11:10. To round a

[sqlite] Minimum Delta Time

I've got an application that I've written that keeps track of time spent on particular tasks. I do many things throughout the day, going between different tasks, and tasks I've already worked on for today, so this tool is incredibly helpful to help justify my warming a chair. I'd prefer the SQL

Re: [sqlite] Corrupted FTS5 index? disk image is malformed

> > On 11 Jul 2018 at 9:28 am,wrote: > > > Yours is not a contentless table. It is an "external content" table. Dan. > > > > > >Noted. Thanks for the clarification. > Regards > Nick ___ sqlite-users

Re: [sqlite] Round-tripping SQLite back and forth between text representation.

On Tuesday, 10 Jul 2018 2:27 PM -0400, Randall Smith wrote: > My underlying question is "can text-comparing two DB dumps be used > to determine what has changed?" I don't know if it will meet your needs, but I've written a script for my own purposes to compare DB changes. Since it's fairly

[sqlite] auto_vacuum resets after '.dump'

I have two databases: original.db and backup.db. backup.db is created via: sqlite3 original.db '.dump' | sqlite3 backup.db Original DB had 'auto_vacuum' set to 'FULL' . Backup DB has it set to 'None'. sqlite3 --version 3.11.0 2016-02-15 17:29:24 3d862f207e3adc00f78066799ac5a8c282430a5f under

Re: [sqlite] Corrupted FTS5 index? disk image is malformed

On 07/11/2018 04:04 AM, Nick wrote: On 10 Jul 2018, at 21:17, Dan Kennedy wrote: Try running the FTS5 integrity-check command with the 3.24.0 command line to ensure it really is corrupt: https://www.sqlite.org/fts5.html#the_integrity_check_command The index can be rebuilt using the rebuild