Re: [sqlite] Freelist walking and location of free blocks

2010-09-09 Thread David C. Smith
Got it - I think I understand. I don't really care about free list pages, just free blocks within a page. So, deleting a second row from my small test database gave me the following output: Page Size is: 1024 (0400) FreeListPage = 0 FreeListCount = 0 Going to offset: 1024 Freeblock = 964 (0D was

Re: [sqlite] Freelist walking and location of free blocks

2010-09-09 Thread Richard Hipp
On Thu, Sep 9, 2010 at 4:03 PM, David C. Smith wrote: > All, I am trying to manually parse the freelist to recover deleted data. > Yes, I googled for someone to have created this already :) > > I am getting data that I don't expect and wanted to see if anyone could see > where I have a misunders

[sqlite] Freelist walking and location of free blocks

2010-09-09 Thread David C. Smith
All, I am trying to manually parse the freelist to recover deleted data. Yes, I googled for someone to have created this already :) I am getting data that I don't expect and wanted to see if anyone could see where I have a misunderstanding. I am using http://www.sqlite.org/fileformat2.html () =