Documentation Source Text

Check-in [6f298c3ff3]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:A tweak to the 8+3 filename documentation. Update to the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 6f298c3ff30baf807dd7f9670e783baf2e0a89f3
User & Date: drh 2011-05-25 14:51:23.782
Context
2011-05-31
11:56
Update the documentation to state that the LIMIT of a scalar subquery is always 1. (check-in: 8d37b80354 user: drh tags: trunk)
2011-05-25
14:51
A tweak to the 8+3 filename documentation. Update to the change log. (check-in: 6f298c3ff3 user: drh tags: trunk)
2011-05-24
00:52
Added preliminary documentation for the SAVEPOINT methods in virtual tables. (check-in: 3dded2adf9 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
40
41
42
43
44
45
46

47


48
49
50
51
52
53
54
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2011 June 28 (3.7.7)} {
<li> Add support for [URI filenames]

<li> Add support for [ON CONFLICT] clauses with [virtual tables].


<li> Avoid unnecessary reparsing of the database schema.
<li> Allow [WAL | WAL-mode] databases to be opened read-only as long as
     there is an existing read/write connection.
<li> Added support for [short filenames].
}

chng {2011 May 19 (3.7.6.3)} {







>
|
>
>







40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2011 June 28 (3.7.7)} {
<li> Add support for [URI filenames]
<li> Add the [sqlite3_vtab_config()] interface in
     support of [ON CONFLICT] clauses with [virtual tables].
<li> Add the [xSavepoint], [xRelease] and [xRollbackTo] methods in
     [virtual tables] in support of [SAVEPOINT] for virtual tables.
<li> Avoid unnecessary reparsing of the database schema.
<li> Allow [WAL | WAL-mode] databases to be opened read-only as long as
     there is an existing read/write connection.
<li> Added support for [short filenames].
}

chng {2011 May 19 (3.7.6.3)} {
Changes to pages/shortnames.in.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
and the danger of
[database corruption caused by inconsistent use of 8+3 filenames].
</p>

<h2>Adjusting SQLite To Use 8+3 Filenames</h2>

<p>
Some systems are compelled to use an older filesystem with 8+3
filename restructions in order to be compatible with legacy, or due
to other non-technical factors.  In such situations, SQLite can be
coerced into using auxiliary files that fit the 8+3 pattern as follows:
</p>

<ol>
<li><p>Compile the SQLite library with the [SQLITE_ENABLE_8_3_NAMES]







|







37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
and the danger of
[database corruption caused by inconsistent use of 8+3 filenames].
</p>

<h2>Adjusting SQLite To Use 8+3 Filenames</h2>

<p>
Some devices are compelled to use an older filesystem with 8+3
filename restructions in order to be compatible with legacy, or due
to other non-technical factors.  In such situations, SQLite can be
coerced into using auxiliary files that fit the 8+3 pattern as follows:
</p>

<ol>
<li><p>Compile the SQLite library with the [SQLITE_ENABLE_8_3_NAMES]