Re: [sqlite] Bad db feature request

2016-06-30 Thread Eduardo Morras
On Thu, 30 Jun 2016 10:12:05 +0100 Paul Sanderson wrote: > The OP wanted something to check his systems for corruption - if the > SQLite dev team don't want to add checksums then the OP could possibly > solve his own problem by adding them to his own internal

Re: [sqlite] Bad db feature request

2016-06-30 Thread Paul Sanderson
The OP wanted something to check his systems for corruption - if the SQLite dev team don't want to add checksums then the OP could possibly solve his own problem by adding them to his own internal version. Extension may have been a bad choice of word - he can modify/compile his own version of

Re: [sqlite] Bad db feature request

2016-06-29 Thread Dominique Devienne
On Wed, Jun 29, 2016 at 9:54 PM, Paul Sanderson < sandersonforens...@gmail.com> wrote: > As mentioned above there is (or can be) reserved space at the end of > each page (documented in the DB header) that can be used for checksums > - you just need to write your own extension :) > >

Re: [sqlite] Bad db feature request

2016-06-29 Thread Paul Sanderson
As mentioned above there is (or can be) reserved space at the end of each page (documented in the DB header) that can be used for checksums - you just need to write your own extension :) https://www.sqlite.org/fileformat2.html Paul www.sandersonforensics.com skype: r3scue193 twitter:

Re: [sqlite] Bad db feature request

2016-06-29 Thread Scott Hess
On Wed, Jun 29, 2016 at 10:36 AM, Simon Slavin wrote: > On 29 Jun 2016, at 5:45pm, Drago, William @ CSG - NARDA-MITEQ > wrote: >> Aren't there things like that already built in to the hard disk controllers >> (CRC, Reed Solomon, etc.)? > > Yes.

Re: [sqlite] Bad db feature request

2016-06-29 Thread R Smith
On 2016/06/29 4:28 PM, Simon Slavin wrote: On 29 Jun 2016, at 10:17am, R Smith wrote: I know I can write nonsense over the file, but I was hoping to be able to cause specific common corruptions, like Invalid-Schema, Missing Index entries, Missing pages etc. with this

Re: [sqlite] Bad db feature request

2016-06-29 Thread Simon Slavin
On 29 Jun 2016, at 5:45pm, Drago, William @ CSG - NARDA-MITEQ wrote: > Aren't there things like that already built in to the hard disk controllers > (CRC, Reed Solomon, etc.)? Yes. But they operate at the level they understand. For instance ... A change is made

Re: [sqlite] Bad db feature request

2016-06-29 Thread Scott Hess
On Wed, Jun 29, 2016 at 2:17 AM, R Smith wrote: > In response to a recent forum post and many other posts, where SQLite > corrupt files or Index integrity was the problem at hand, I was wondering if > we could ask for an API function that would corrupt a DB for us. I have

Re: [sqlite] Bad db feature request

2016-06-29 Thread Roger Binns
On 29/06/16 09:45, Drago, William @ CSG - NARDA-MITEQ wrote: > Aren't there things like that [checksums] already built in to the hard disk > controllers (CRC, Reed Solomon, etc.)? They are at a different level and can only detect issues in what they see. For example SQLite can create a page of

Re: [sqlite] Bad db feature request

2016-06-29 Thread Drago, William @ CSG - NARDA-MITEQ
> boun...@mailinglists.sqlite.org] On Behalf Of Dominique Devienne > Sent: Wednesday, June 29, 2016 10:52 AM > To: SQLite mailing list > Subject: Re: [sqlite] Bad db feature request > > On Wed, Jun 29, 2016 at 4:28 PM, Simon Slavin <slav...@bigfraud.org> > wrote: > &

Re: [sqlite] Bad db feature request

2016-06-29 Thread Roger Binns
On 29/06/16 07:51, Dominique Devienne wrote: > I wish for the day SQLite has page checksums to detect any such random > corruption. Agreed. The SQLite team rejected doing so: http://www.sqlite.org/src/tktview/72b01a982a84f64d4284 > Yes, I know, it's a format change, and will likely slow

Re: [sqlite] Bad db feature request

2016-06-29 Thread Dominique Devienne
On Wed, Jun 29, 2016 at 4:28 PM, Simon Slavin wrote: > I prefer your idea of opening the file and randomly overwriting a few > bytes. Of course some of them will just be values in unindexed fields, so > there would be no damage SQLite could notice. I wish for the day

Re: [sqlite] Bad db feature request

2016-06-29 Thread Simon Slavin
On 29 Jun 2016, at 10:17am, R Smith wrote: > I know I can write nonsense over the file, but I was hoping to be able to > cause specific common corruptions, like Invalid-Schema, Missing Index > entries, Missing pages etc. with this command. It need not be fancy, just >

[sqlite] Bad db feature request

2016-06-29 Thread R Smith
Hi SQLite devs, In response to a recent forum post and many other posts, where SQLite corrupt files or Index integrity was the problem at hand, I was wondering if we could ask for an API function that would corrupt a DB for us. I would like to use this to test all our systems' ability to