[sqlite] Overflow Page

2010-09-21 Thread Scott Weigand
Hello List, Apologies if this is the wrong list to post to. Can anyone tell me if an overflow page is encapsulated within a B-Tree page or if it starts on a standard page boundary and has its first 4 bytes as the next overflow page number? Thanks,Scott ___

Re: [sqlite] Overflow Page

2010-09-22 Thread Scott Weigand
> > Starts on a page boundary. The first four bytes are the > next overflow page number (or 0 for the last page in a chain). Thanks Dan. Have you ever come across a database page that starts with 0x100? The database file is roughly 328KiB, so there is no way that this page points to anot

Re: [sqlite] Overflow Page

2010-09-22 Thread Scott Weigand
> From: slav...@bigfraud.org > Date: Wed, 22 Sep 2010 10:30:27 +0100 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Overflow Page > > Is that perhaps the last page in the list ? According to > > http://www.sqlite.org/fileformat.html#overflow_page_chains > > the value is undefined (altho

[sqlite] Pages with all zeros

2010-10-29 Thread Scott Weigand
Hi List, I'm looking through some SQLite databases that are used by Google Chrome on Mac OSX 10.6.4 and find some cases where entire pages are filled with 0x00. I checked and there are no corresponding journal files. I also verified that Google Chrome was not running at the time. Would there