Author: dj
Date: Fri Oct 27 11:44:48 2017
New Revision: 19395
Log:
Update to SQLite-3.21.0. Fixes #9932.
Modified:
trunk/BOOK/introduction/welcome/changelog.xml
trunk/BOOK/packages.ent
trunk/BOOK/server/databases/sqlite.xml
Modified: trunk/BOOK/introduction/welcome/changelog.xml
==============================================================================
--- trunk/BOOK/introduction/welcome/changelog.xml Fri Oct 27 09:21:45
2017 (r19394)
+++ trunk/BOOK/introduction/welcome/changelog.xml Fri Oct 27 11:44:48
2017 (r19395)
@@ -45,6 +45,10 @@
<para>October 27th, 2017</para>
<itemizedlist>
<listitem>
+ <para>[dj] - Update to SQLite-3.21.0. Fixes
+ <ulink url="&blfs-ticket-root;9932">#9932</ulink>.</para>
+ </listitem>
+ <listitem>
<para>[pierre] - Update to LXQt-0.12.0, libqtxdg-3.1.0,
lxqt-build-tools-0.4.0, libsysstat-0.4.0, lximage-0.6.0,
qterminal-0.8.0, qtermwidget-0.8.0, pavucontrol-qt-0.3.0. Fixes
Modified: trunk/BOOK/packages.ent
==============================================================================
--- trunk/BOOK/packages.ent Fri Oct 27 09:21:45 2017 (r19394)
+++ trunk/BOOK/packages.ent Fri Oct 27 11:44:48 2017 (r19395)
@@ -504,7 +504,7 @@
<!ENTITY lmdb-version "0.9.21">
<!ENTITY mariadb-version "10.2.9">
<!ENTITY postgresql-version "10.0">
-<!ENTITY sqlite-version "3.20.1">
+<!ENTITY sqlite-version "3.21.0">
<!-- Chapter 23 -->
<!ENTITY openldap-version "2.4.45">
Modified: trunk/BOOK/server/databases/sqlite.xml
==============================================================================
--- trunk/BOOK/server/databases/sqlite.xml Fri Oct 27 09:21:45 2017
(r19394)
+++ trunk/BOOK/server/databases/sqlite.xml Fri Oct 27 11:44:48 2017
(r19395)
@@ -4,19 +4,19 @@
<!ENTITY % general-entities SYSTEM "../../general.ent">
%general-entities;
- <!ENTITY sqlite-dl-version "3200100">
- <!ENTITY sqlite-doc-version "3200100">
+ <!ENTITY sqlite-dl-version "3210000">
+ <!ENTITY sqlite-doc-version "3210000">
<!ENTITY sqlite-download-http
"https://sqlite.org/2017/sqlite-autoconf-&sqlite-dl-version;.tar.gz";>
<!ENTITY sqlite-download-ftp " ">
- <!ENTITY sqlite-md5sum "369444dbf11895c61949940a6b038f92">
- <!ENTITY sqlite-size "2.4 MB">
- <!ENTITY sqlite-buildsize "73 MB (with docs)">
- <!ENTITY sqlite-time "0.4 SBU">
+ <!ENTITY sqlite-md5sum "7913de4c3126ba3c24689cb7a199ea31">
+ <!ENTITY sqlite-size "2.5 MB">
+ <!ENTITY sqlite-buildsize "79 MB">
+ <!ENTITY sqlite-time "0.3 SBU">
<!ENTITY sqlite-docs-download
"https://sqlite.org/2017/sqlite-doc-&sqlite-doc-version;.zip";>
- <!ENTITY sqlite-docs-md5sum "51a0aa9bbc78cc61c7d16625297c733b">
- <!ENTITY sqlite-docs-size "5.5 MB">
+ <!ENTITY sqlite-docs-md5sum "082aa03bc43b6e00db9787b30a2efa4f">
+ <!ENTITY sqlite-docs-size "5.6 MB">
]>
<sect1 id="sqlite" xreflabel="SQLite-&sqlite-version;">
@@ -127,7 +127,8 @@
</para>
<screen><userinput>./configure --prefix=/usr --disable-static \
- CFLAGS="-g -O2 -DSQLITE_ENABLE_FTS3=1 \
+ --enable-fts3 --enable-fts4 \
+ --enable-fts5 CFLAGS="-g -O2 \
-DSQLITE_ENABLE_COLUMN_METADATA=1 \
-DSQLITE_ENABLE_UNLOCK_NOTIFY=1 \
-DSQLITE_SECURE_DELETE=1 \
@@ -161,17 +162,18 @@
href="../../xincludes/static-libraries.xml"/>
<para>
- <parameter>CFLAGS="-g -O2 -DSQLITE_ENABLE_FTS3=1
- <!-- insecure, see below: -DSQLITE_ENABLE_FTS3_TOKENIZER=1 -->
+ <parameter>--enable-fts*</parameter>: enable all three full text search
+ extensions.
+ </para>
+
+ <para>
+ <parameter>CFLAGS="-g -O2
-DSQLITE_ENABLE_COLUMN_METADATA=1
- -DSQLITE_SECURE_DELETE -DSQLITE_ENABLE_UNLOCK_NOTIFY=1
+ -DSQLITE_SECURE_DELETE
+ -DSQLITE_ENABLE_UNLOCK_NOTIFY=1
-DSQLITE_ENABLE_DBSTAT_VTAB=1"</parameter>: Applications such as
<application>Firefox</application> require secure delete and enable
unlock notify to be turned on.
- <!-- Thunderbird requires the
- fts3_tokenizer option: this option is insecure if set for any
- application using sqlite on the host. So it is disabled for now, and the
- thunderbird static sqlite library is used instead.-->
Since <application>firefox-41</application> the dbstat virtual
table is also required. The only way to do this is to include them in the
CFLAGS. By default, these are set to <literal>"-g -O2"</literal> so we
--
http://lists.linuxfromscratch.org/listinfo/blfs-book
FAQ: http://www.linuxfromscratch.org/blfs/faq.html
Unsubscribe: See the above information page
