Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typos in file format documentation. Ticket #505. (CVS 1121) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
4eef93814f4a26de4a088c4645454435 |
| User & Date: | drh 2003-11-25 23:48:57 |
Context
|
2003-11-27
| ||
| 00:48 | Disallow temporary indices on persistent tables. (CVS 1122) check-in: 72bf73b2 user: drh tags: trunk | |
|
2003-11-25
| ||
| 23:48 | Fix typos in file format documentation. Ticket #505. (CVS 1121) check-in: 4eef9381 user: drh tags: trunk | |
|
2003-11-24
| ||
| 23:11 | Fix typo in file format documentation. Ticket #502. (CVS 1120) check-in: 72f3e7c2 user: drh tags: trunk | |
Changes
Changes to www/fileformat.tcl.
1
2
3
4
5
6
7
8
9
10
11
...
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
|
#
# Run this script to generated a fileformat.html output file
#
set rcsid {$Id: fileformat.tcl,v 1.10 2003/11/24 23:11:08 drh Exp $}
puts {<html>
<head>
<title>SQLite Database File Format</title>
</head>
<body bgcolor="white">
<h1 align="center">
................................................................................
Entry 0. Bytes 4 and 5 of the header point to Cell 0. Cell 0 then
points to Cell 1 which contains Ptr 1 and Entry 1. And so forth.
Cells vary in size. Every cell has a 12-byte header and at least 4
bytes of payload space. Space is allocated to payload in increments
of 4 bytes. Thus the minimum size of a cell is 16 bytes and up to
63 cells can fit on a single page. The size of a cell is always a multiple
of 4 bytes.
A cell can have up to 238 byte of payload space. If
the payload is more than 238 bytes, then an addition 4 point page
number is appended to the cell which is the page number of the first
overflow page containing the additional payload. The maximum size
of a cell is thus 254 bytes, meaning that a least 4 cells can fit into
the 1016 bytes of space available on a b-tree page.
An average cell is usually around 52 to 100 bytes in size with about
10 or 20 cells to a page.
</p>
|
|
|
|
|
1
2
3
4
5
6
7
8
9
10
11
...
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
|
#
# Run this script to generated a fileformat.html output file
#
set rcsid {$Id: fileformat.tcl,v 1.11 2003/11/25 23:48:57 drh Exp $}
puts {<html>
<head>
<title>SQLite Database File Format</title>
</head>
<body bgcolor="white">
<h1 align="center">
................................................................................
Entry 0. Bytes 4 and 5 of the header point to Cell 0. Cell 0 then
points to Cell 1 which contains Ptr 1 and Entry 1. And so forth.
Cells vary in size. Every cell has a 12-byte header and at least 4
bytes of payload space. Space is allocated to payload in increments
of 4 bytes. Thus the minimum size of a cell is 16 bytes and up to
63 cells can fit on a single page. The size of a cell is always a multiple
of 4 bytes.
A cell can have up to 238 bytes of payload space. If
the payload is more than 238 bytes, then an additional 4 byte page
number is appended to the cell which is the page number of the first
overflow page containing the additional payload. The maximum size
of a cell is thus 254 bytes, meaning that a least 4 cells can fit into
the 1016 bytes of space available on a b-tree page.
An average cell is usually around 52 to 100 bytes in size with about
10 or 20 cells to a page.
</p>
|