Re: [sqlite] Database corruption check.

2019-04-15 Thread Richard Hipp
On 4/15/19, Tim Streater wrote: >> >> This command was added to the command-line tool recently. > > 3.19.3 has it - that's almost two years ago. > The .selftest command was added on 2017-03-09 by https://www.sqlite.org/src/timeline?c=f4fcd46f08ba59d2 and hence as likely first in release 3.18.0 on

Re: [sqlite] Database corruption check.

2019-04-15 Thread Tim Streater
On 15 Apr 2019, at 11:02, Simon Slavin wrote: > On 15 Apr 2019, at 10:36am, Lullaby Dayal wrote: > >> Thank you very much for your response. The link seems to be helpful. But I >> fail to run the .selftest command from my sqlite3 prompt. I got the error: >> unknown command or invalid arguments e

Re: [sqlite] Database corruption check.

2019-04-15 Thread Dominique Devienne
On Mon, Apr 15, 2019 at 11:37 AM Lullaby Dayal wrote: > [...]. But I fail to run the .selftest command from my sqlite3 prompt. I > got the error: > unknown command or invalid arguments error. > That code dates back to July 2017. So you must have a very old version. > I am a newbie in SQLite. I

Re: [sqlite] Database corruption check.

2019-04-15 Thread Simon Slavin
On 15 Apr 2019, at 10:36am, Lullaby Dayal wrote: > Thank you very much for your response. The link seems to be helpful. But I > fail to run the .selftest command from my sqlite3 prompt. I got the error: > unknown command or invalid arguments error. This command was added to the command-line tool

Re: [sqlite] Database corruption check.

2019-04-15 Thread Lullaby Dayal
Hi Richard, Thank you very much for your response. The link seems to be helpful. But I fail to run the .selftest command from my sqlite3 prompt. I got the error: unknown command or invalid arguments error. I am a newbie in SQLite. I am not sure how can I get this to working in our application run

Re: [sqlite] Database corruption check.

2019-04-14 Thread Richard Hipp
On 4/14/19, Lullaby Dayal wrote: > > For Sqlite database, as per my understanding, implementing pragma > integrity_check won't guarantee all errors to be detected. Maybe you are confused with "PRAGMA quick_check"? The "PRAGMA integrity_check" takes a little longer, but does a better job. There

[sqlite] Database corruption check.

2019-04-14 Thread Lullaby Dayal
Hi, We are using sqlite for our embedded automotive system based on QNX. We have a requirement to check whether database is corrupted on start-up and replace it with default database if such a scenario happens. For Sqlite database, as per my understanding, implementing pragma integrity_check won'