Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Additional documentation on the 3.3.0 file format change added to formatchng.html. (CVS 3306) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 955551ca2e66a1f21dae21aa0265906887d7138d |
| User & Date: | drh 2006-06-27 12:24:14 |
Context
|
2006-06-27
| ||
| 12:25 | Fix up the test tclvar virtual module. (CVS 3307) check-in: a20bfa46 user: danielk1977 tags: trunk | |
| 12:24 | Additional documentation on the 3.3.0 file format change added to formatchng.html. (CVS 3306) check-in: 955551ca user: drh tags: trunk | |
| 12:16 | Fix bug in transfer of arguments from WHERE clause to virtual table xFilter() methods. (CVS 3305) check-in: cf41f2a3 user: danielk1977 tags: trunk | |
Changes
Changes to www/formatchng.tcl.
1
2
3
4
5
6
7
8
9
10
11
...
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
|
#
# Run this Tcl script to generate the formatchng.html file.
#
set rcsid {$Id: formatchng.tcl,v 1.17 2006/02/16 00:32:37 drh Exp $ }
source common.tcl
header {File Format Changes in SQLite}
puts {
<h2>File Format Changes in SQLite</h2>
<p>
Every effort is made to keep SQLite fully backwards compatible from
................................................................................
restores the database to a format such that it can be read by earlier
SQLite versions.</p>
</td>
</tr>
<tr>
<td valign="top">3.2.8 to 3.3.0</td>
<td valign="top">2006-Jan-10</td>
<td><p>Version 3.3.0 uses a new encoding for boolean values that
uses less disk space. Version 3.3.0 can read and write database
files created by prior versions of SQLite. But prior versions
of SQLite will not be able to read or write databases created
by Version 3.3.0</p>
</td>
</tr>
</table>
</blockquote>
<p>
To perform a database reload, have ready versions of the
|
|
>
|
|
>
>
>
>
>
>
>
>
>
>
|
1
2
3
4
5
6
7
8
9
10
11
...
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
|
#
# Run this Tcl script to generate the formatchng.html file.
#
set rcsid {$Id: formatchng.tcl,v 1.18 2006/06/27 12:24:14 drh Exp $ }
source common.tcl
header {File Format Changes in SQLite}
puts {
<h2>File Format Changes in SQLite</h2>
<p>
Every effort is made to keep SQLite fully backwards compatible from
................................................................................
restores the database to a format such that it can be read by earlier
SQLite versions.</p>
</td>
</tr>
<tr>
<td valign="top">3.2.8 to 3.3.0</td>
<td valign="top">2006-Jan-10</td>
<td><p>Version 3.3.0 adds support for descending indices and
uses a new encoding for boolean values that requires
less disk space. Version 3.3.0 can read and write database
files created by prior versions of SQLite. But prior versions
of SQLite will not be able to read or write databases created
by Version 3.3.0</p>
<p>If you need backwards and forwards capatibility, you can
compile with -DSQLITE_DEFAULT_FILE_FORMAT=1. Or at runtime
you can say "PRAGMA legacy_file_format=ON" prior to creating
a new database file</p>
<p>Once a database file is created, its format is fixed. So
a database file created by SQLite 3.2.8 and merely modified
by version 3.3.0 or later will retain the old format. Except,
the VACUUM command recreates the database so running VACUUM
on 3.3.0 or later will change the file format to the latest
edition.</p>
</td>
</tr>
</table>
</blockquote>
<p>
To perform a database reload, have ready versions of the
|