Re: [sqlite] SQLite 3.X Database File Format ?

2007-06-15 Thread Dan Kennedy
On Thu, 2007-06-14 at 15:08 -0700, Joe Wilson wrote:
> Is there an SQLite 3.x equivalent document for this?
> 
>   SQLite 2.X Database File Format
>   http://sqlite.org/fileformat.html
> 
> If not, is this 2.x document worth reading as a background to
> the general structure of the sqlite 3.x file and page format?
> Or has it changed so much that it's not useful?

I just took a quick look, and it all still looks pretty 
relevant to me. 

The exact way the bytes are arranged to form row-records
has changed (to accommodate manifest types), the database 
header is different and some of the "b trees" are now "b+ trees".
And the root-page of the sqlite_master table is now on page 1
(with the header) instead of 2. But these are all really 
just details, the basic approach is the same.  

If you need the precise details, it might be easiest to read
that document and then proceed to the comments in btreeInt.h.

Dan.

> 
> 
>
> 
> Be a better Globetrotter. Get better travel answers from someone who knows. 
> Yahoo! Answers - Check it out.
> http://answers.yahoo.com/dir/?link=list=396545469
> 
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] SQLite 3.X Database File Format ?

2007-06-14 Thread Joe Wilson
Is there an SQLite 3.x equivalent document for this?

  SQLite 2.X Database File Format
  http://sqlite.org/fileformat.html

If not, is this 2.x document worth reading as a background to
the general structure of the sqlite 3.x file and page format?
Or has it changed so much that it's not useful?


   

Be a better Globetrotter. Get better travel answers from someone who knows. 
Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list=396545469

-
To unsubscribe, send email to [EMAIL PROTECTED]
-