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 version.
>
> Extension may have been
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 SQLi
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 :)
>
> https://www.sq
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: @sandersonfo
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. But they operate at the level they understand. F
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 command. It need not b
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 in a field which involves ch
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 done some things like th
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 d
> 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
> wrote:
>
> I wish for the day S
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 thing
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 SQLite has page checksums
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
> find the first table tha
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 cat
14 matches
Mail list logo