Documentation Source Text

Check-in [55869edbde]
Login

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

Overview
Comment:Move the 3.8.7 release into October. Updates to URI documentation.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 55869edbdea078987853de5c593548246d420d1a
User & Date: drh 2014-10-05 20:07:56
Context
2014-10-05
20:54
Update the HTTP server to prohibit malformed and possibly malicious HTTP_HOST parameters. check-in: 5bb4dfcc73 user: drh tags: trunk
20:07
Move the 3.8.7 release into October. Updates to URI documentation. check-in: 55869edbde user: drh tags: trunk
2014-09-30
12:57
Remove the SQLITE_ENABLE_TREE_EXPLAIN compile-time option. check-in: a893d831f4 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2014-11-?? (3.8.7)} {
<p><b>Performance Enhancements:</b>
<li>Many micro-optimizations result in 18% more work for the same number
    of CPU cycles relative to the previous release. 
    The cumulative performance increase since [version 3.8.0] is 58%.
    (Measured using 
    [http://valgrind.org/docs/manual/cg-manual.html|cachegrind] on the
    [http://www.sqlite.org/src/artifact/83f6b3318f7ee|speedtest1.c] workload on







|







14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2014-10-?? (3.8.7)} {
<p><b>Performance Enhancements:</b>
<li>Many micro-optimizations result in 18% more work for the same number
    of CPU cycles relative to the previous release. 
    The cumulative performance increase since [version 3.8.0] is 58%.
    (Measured using 
    [http://valgrind.org/docs/manual/cg-manual.html|cachegrind] on the
    [http://www.sqlite.org/src/artifact/83f6b3318f7ee|speedtest1.c] workload on

Changes to pages/uri.in.

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Or the database can be opened read-only by using "mode=ro" as a query
parameter.
</p>

<h1>2.0 Backwards Compatibility</h1>

<p>
In order to maintain full backwards compatibility for legacy applications,
the URI filename capability is disabled by default.  
^(In order for URI filenames
to work, one or more of the following must be true:
</p>

<ol>
<li><p>The SQLite library is compiled with the [SQLITE_USE_URI] 
       compile-time option.</p></li>
<li><p>The [sqlite3_config]([SQLITE_CONFIG_URI], 1); configuration option
       is set at application start-time.</p></li>
<li><p>The [SQLITE_OPEN_URI] bit is OR-ed in with the set bits passed in
       as the 3rd parameter to the [sqlite3_open_v2()] interface.</p></li>
</ol>)^

<p>
^If URI filenames are recognized when the database connection is originally
opened, then URI filenames will also be recognized on [ATTACH] statements.
^Similarly, if URI filenames are not recognized when the database connection
is first opened, they will not be recognized by [ATTACH].
</p>








|
|
|
|
|
|
|
|
|
|
|
|
|
<
<







17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36


37
38
39
40
41
42
43
Or the database can be opened read-only by using "mode=ro" as a query
parameter.
</p>

<h1>2.0 Backwards Compatibility</h1>

<p>
^In order to maintain full backwards compatibility for legacy applications,
the URI filename capability is disabled by default.
^URI filenames can be enabled or disabled using the [SQLITE_USE_URI=1]
or [SQLITE_USE_URI=0] compile-time options.
^The compile-time setting for URI filenames can be changed
at start-time using the [sqlite3_config]([SQLITE_CONFIG_URI],1)
or [sqlite3_config]([SQLITE_CONFIG_URI],0) configuration calls.
^Regardless of the compile-time or start-time settings, URI filenames
can be enabled for individual database connections by including the
[SQLITE_OPEN_URI] bit in the set of bits passed as the F parameter
to [sqlite3_open_v2(N,P,F,V)].
</p>



<p>
^If URI filenames are recognized when the database connection is originally
opened, then URI filenames will also be recognized on [ATTACH] statements.
^Similarly, if URI filenames are not recognized when the database connection
is first opened, they will not be recognized by [ATTACH].
</p>