Documentation Source Text

Check-in [d9e14a871b]
Login

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

Overview
Comment:Further updates in support of 3.9.0. Mark FTS5 has being officially released.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d9e14a871beb340b1c343eccfb0a51096d492743
User & Date: drh 2015-10-09 14:45:42.158
Context
2015-10-09
15:01
Keep FTS5 experimental for at least one more release cycle. (check-in: 7ef90a2dde user: drh tags: trunk)
14:45
Further updates in support of 3.9.0. Mark FTS5 has being officially released. (check-in: d9e14a871b user: drh tags: trunk)
14:00
Update the documentation for the version numbering change. (check-in: 4fc9d7ce50 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
19
20
21
22
23
24
25
26



27
28
29
30
31
32
33
}

chng {2015-11-01 (3.9.0)} {
<p><b>Policy Changes:</b>
<li>The [version numbering conventions] for SQLite are revised to use the
    emerging standard of [http://semver.org/|semantic versioning].
<p><b>New Features And Enhancements:</b>
<li>Added [the json1 extension] module in the source tree.



<li>The [CREATE VIEW] statement now accepts an optional list of
    column names following the view name.
<li>Added support for [indexes on expressions].
<li>Added support for [table-valued functions] in the FROM clause of a
    [SELECT] statement.
<li>Added support for [eponymous virtual tables].
<li>A [VIEW] may now reference undefined tables and functions when







|
>
>
>







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

chng {2015-11-01 (3.9.0)} {
<p><b>Policy Changes:</b>
<li>The [version numbering conventions] for SQLite are revised to use the
    emerging standard of [http://semver.org/|semantic versioning].
<p><b>New Features And Enhancements:</b>
<li>Added [the json1 extension] module in the source tree, and in the [amalgamation].
    Enable support using the [SQLITE_ENABLE_JSON1] compile-time option.
<li>Added [FTS5|Full Text Search version 5 (FTS5)] to the [amalgamation], enabled
    using [SQLITE_ENABLE_FTS5].  FTS5 is now considered official and supported.
<li>The [CREATE VIEW] statement now accepts an optional list of
    column names following the view name.
<li>Added support for [indexes on expressions].
<li>Added support for [table-valued functions] in the FROM clause of a
    [SELECT] statement.
<li>Added support for [eponymous virtual tables].
<li>A [VIEW] may now reference undefined tables and functions when
Changes to pages/compile.in.
619
620
621
622
623
624
625





626
627
628
629
630
631
632
633
634
635
636
637
638





639
640
641
642
643
644
645
  and also allows query expressions to contain nested parenthesis.
}

COMPILE_OPTION {SQLITE_ENABLE_FTS4} {
  When this option is defined in the [amalgamation], versions 3 and 4
  of the full-text search engine is added to the build automatically.
}






COMPILE_OPTION {SQLITE_ENABLE_ICU} {
  This option causes the 
  [http://www.icu-project.org/ | International Components for Unicode]
  or "ICU" extension to SQLite to be added to the build.  
}

COMPILE_OPTION {SQLITE_ENABLE_IOTRACE} {
  When both the SQLite core and the [Command Line Interface] (CLI) are both 
  compiled with this option, then the CLI provides an extra command
  named ".iotrace" that provides a low-level log of I/O activity.
  This option is experimental and may be discontinued in a future release.
}






COMPILE_OPTION {SQLITE_ENABLE_LOCKING_STYLE} {
  This option enables additional logic in the OS interface layer for
  Mac OS X. The additional logic attempts to determine the type of the
  underlying filesystem and choose and alternative locking strategy
  that works correctly for that filesystem type. Five locking strategies 
  are available:







>
>
>
>
>













>
>
>
>
>







619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
  and also allows query expressions to contain nested parenthesis.
}

COMPILE_OPTION {SQLITE_ENABLE_FTS4} {
  When this option is defined in the [amalgamation], versions 3 and 4
  of the full-text search engine is added to the build automatically.
}

COMPILE_OPTION {SQLITE_ENABLE_FTS5} {
  When this option is defined in the [amalgamation], versions 5
  of the full-text search engine ([fts5]) is added to the build automatically.
}

COMPILE_OPTION {SQLITE_ENABLE_ICU} {
  This option causes the 
  [http://www.icu-project.org/ | International Components for Unicode]
  or "ICU" extension to SQLite to be added to the build.  
}

COMPILE_OPTION {SQLITE_ENABLE_IOTRACE} {
  When both the SQLite core and the [Command Line Interface] (CLI) are both 
  compiled with this option, then the CLI provides an extra command
  named ".iotrace" that provides a low-level log of I/O activity.
  This option is experimental and may be discontinued in a future release.
}

COMPILE_OPTION {SQLITE_ENABLE_JSON1} {
  When this option is defined in the [amalgamation], the
  [JSON SQL functions] are added to the build automatically.
}

COMPILE_OPTION {SQLITE_ENABLE_LOCKING_STYLE} {
  This option enables additional logic in the OS interface layer for
  Mac OS X. The additional logic attempts to determine the type of the
  underlying filesystem and choose and alternative locking strategy
  that works correctly for that filesystem type. Five locking strategies 
  are available:
Changes to pages/howtocompile.in.
105
106
107
108
109
110
111
112
113
114


115
116
117
118
119
120
121
option:</p>

<blockquote><pre>
gcc -DSQLITE_THREADSAFE=0 -DSQLITE_OMIT_LOAD_EXTENSION shell.c sqlite3.c
</pre></blockquote>

<p>One might want to provide other [compile-time options] such as
[SQLITE_ENABLE_FTS3 | -DSQLITE_ENABLE_FTS3] for full-text search or
[SQLITE_ENABLE_RTREE | -DSQLITE_ENABLE_RTREE]
for the R*Tree search engine extension.  In order to see extra commentary


in [EXPLAIN] listings, add the 
[SQLITE_ENABLE_EXPLAIN_COMMENTS | -DSQLITE_ENABLE_EXPLAIN_COMMENTS] option.
On unix systems, add -DHAVE_USLEEP=1 if the host machine supports the
usleep() system call.  Add -DHAVE_READLINE and the -lreadline
and -lncurses libraries to get command-line editing support.
One might also want to
specify some compiler optimization switches.  (The precompiled







|

|
>
>







105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
option:</p>

<blockquote><pre>
gcc -DSQLITE_THREADSAFE=0 -DSQLITE_OMIT_LOAD_EXTENSION shell.c sqlite3.c
</pre></blockquote>

<p>One might want to provide other [compile-time options] such as
[SQLITE_ENABLE_FTS5 | -DSQLITE_ENABLE_FTS4] for full-text search or
[SQLITE_ENABLE_RTREE | -DSQLITE_ENABLE_RTREE]
for the R*Tree search engine extension or
[SQLITE_ENABLE_JSON1 | -DSQLITE_ENABLE_JSON1] to include
[JSON SQL functions].  In order to see extra commentary
in [EXPLAIN] listings, add the 
[SQLITE_ENABLE_EXPLAIN_COMMENTS | -DSQLITE_ENABLE_EXPLAIN_COMMENTS] option.
On unix systems, add -DHAVE_USLEEP=1 if the host machine supports the
usleep() system call.  Add -DHAVE_READLINE and the -lreadline
and -lncurses libraries to get command-line editing support.
One might also want to
specify some compiler optimization switches.  (The precompiled
Changes to pages/json1.in.
1
2
3
4
5
6
7
8
9
<title>The JSON1 Extension</title>
<tcl>hd_keywords json1 {the json1 extension}</tcl>
<h2>The JSON1 Extension</h2>

<p>
The <b>json1</b> extension is a [loadable extension] that
implements eleven [application-defined SQL functions] and
two [table-valued functions] that are useful for
managing JSON content stored in an SQLite database.

|







1
2
3
4
5
6
7
8
9
<title>The JSON1 Extension</title>
<tcl>hd_keywords json1 {the json1 extension} {JSON SQL functions}</tcl>
<h2>The JSON1 Extension</h2>

<p>
The <b>json1</b> extension is a [loadable extension] that
implements eleven [application-defined SQL functions] and
two [table-valued functions] that are useful for
managing JSON content stored in an SQLite database.