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 running in QNX on an ARM board. Thank you! Lullaby On Sun, Apr 14, 2019, 5:38 PM Richard Hipp <d...@sqlite.org wrote: > On 4/14/19, Lullaby Dayal <lullaby.tec...@gmail.com> 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 > is very little that will slip past integrity_check. > > Both of these pragmas only check the meta-data and linkage. If a bit > flips in the middle of a data field (perhaps due to a cosmic-ray hit > or something) and that field is not indexed, then there is nothing > that will detect that change. > > To verify the data, you can use checksums. The > https://www.sqlite.org/src/file/ext/misc/shathree.c extension > implements SHA3 hash functions, for example. The CLI uses those hash > functions to checksum the data. In the CLI you can type: > > .selftest --init > > And that will create a new table named "selftest" that contains > checksums for all other tables. Then later to verify those checksums, > run just: > > .selftest > > You can look at the CLI source code > (https://www.sqlite.org/src/artifact?ln=7748-7852&name=c1986496062f9dba) > to see how this is implemented, and even copy/paste the CLI source > code into your application, if you want. > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
