| Newsgroups |
gmane.linux.lfs.book |
| Message-ID |
<[email protected]> |
This is an automated email from the git hooks/post-receive script.
git pushed a commit to branch prepare-ml-12.5
in repository lfs.
commit 7920d646ba5f54c268f10978556d7053edcf0791
Author: Thomas Trepl <[email protected]>
AuthorDate: Mon Aug 18 16:05:08 2025 +0200
Add sqlite
---
chapter03/packages.xml | 18 ++++++
chapter08/chapter08.xml | 2 +
chapter08/sqlite.xml | 154 ++++++++++++++++++++++++++++++++++++++++++++++++
packages.ent | 18 ++++++
4 files changed, 192 insertions(+)
diff --git a/chapter03/packages.xml b/chapter03/packages.xml
index 2bbebf936..3251d3239 100644
--- a/chapter03/packages.xml
+++ b/chapter03/packages.xml
@@ -617,6 +617,15 @@
</listitem>
</varlistentry>
+ <varlistentry>
+ <term>PCRE2 (&pcre2-version;) - <token>&pcre2-size;</token>:</term>
+ <listitem>
+ <para>Home page: <ulink url="&pcre2-home;"/></para>
+ <para>Download: <ulink url="&pcre2-url;"/></para>
+ <para>MD5 sum: <literal>&pcre2-md5;</literal></para>
+ </listitem>
+ </varlistentry>
+
<varlistentry>
<term>Perl (&perl-version;) - <token>&perl-size;</token>:</term>
<listitem>
@@ -706,6 +715,15 @@
</listitem>
</varlistentry>
+ <varlistentry>
+ <term>Sqlite (&sqlite-version;) - <token>&sqlite-size;</token>:</term>
+ <listitem>
+ <para>Home page: <ulink url="&sqlite-home;"/></para>
+ <para>Download: <ulink url="&sqlite-url;"/></para>
+ <para>MD5 sum: <literal>&sqlite-md5;</literal></para>
+ </listitem>
+ </varlistentry>
+
<varlistentry revision="sysv">
<term>Sysklogd (&sysklogd-version;) - <token>&sysklogd-size;</token>:</term>
<listitem>
diff --git a/chapter08/chapter08.xml b/chapter08/chapter08.xml
index 1283f0573..e50ecea85 100644
--- a/chapter08/chapter08.xml
+++ b/chapter08/chapter08.xml
@@ -47,6 +47,7 @@
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="psmisc.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="gettext.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="bison.xml"/>
+ <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="pcre2.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="grep.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="bash.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="libtool.xml"/>
@@ -63,6 +64,7 @@
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="openssl.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="libelf.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="libffi.xml"/>
+ <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="sqlite.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="python.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="flit-core.xml"/>
<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="packaging.xml"/>
diff --git a/chapter08/sqlite.xml b/chapter08/sqlite.xml
new file mode 100644
index 000000000..26253252b
--- /dev/null
+++ b/chapter08/sqlite.xml
@@ -0,0 +1,154 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE sect1 PUBLIC "-//OASIS//DTD DocBook XML V4.5//EN"
+ "http://www.oasis-open.org/docbook/xml/4.5/docbookx.dtd" [
+ <!ENTITY % general-entities SYSTEM "../general.ent">
+ %general-entities;
+]>
+
+<sect1 id="ch-system-sqlite" role="wrap">
+ <?dbhtml filename="sqlite.html"?>
+
+ <sect1info condition="script">
+ <productname>sqlite</productname>
+ <productnumber>&sqlite-version;</productnumber>
+ <address>&sqlite-url;</address>
+ </sect1info>
+
+ <title>SQLite-&sqlite-version;</title>
+
+ <indexterm zone="ch-system-sqlite">
+ <primary sortas="a-SQLite">SQLite</primary>
+ </indexterm>
+
+ <sect2 role="package">
+ <title/>
+
+ <para>
+ The <application>SQLite</application> package is a software library that
+ implements a self-contained, serverless, zero-configuration, transactional
+ SQL database engine.
+ </para>
+
+ <segmentedlist>
+ <segtitle>&buildtime;</segtitle>
+ <segtitle>&diskspace;</segtitle>
+
+ <seglistitem>
+ <seg>&sqlite-fin-sbu;</seg>
+ <seg>&sqlite-fin-du;</seg>
+ </seglistitem>
+ </segmentedlist>
+
+ </sect2>
+
+ <sect2 role="installation">
+ <title>Installation of SQLite</title>
+
+ <para>
+ Install <application>SQLite</application> by running the following
+ commands:
+ </para>
+
+<screen><userinput remap="configure">./configure --prefix=/usr \
+ --disable-static \
+ --enable-fts{4,5} \
+ CPPFLAGS="-D SQLITE_ENABLE_COLUMN_METADATA=1 \
+ -D SQLITE_ENABLE_UNLOCK_NOTIFY=1 \
+ -D SQLITE_ENABLE_DBSTAT_VTAB=1 \
+ -D SQLITE_SECURE_DELETE=1"</userinput></screen>
+
+ <variablelist>
+ <title>The meaning of the configure parameters:</title>
+
+ <varlistentry>
+ <term><parameter>--enable-fts{4,5}</parameter></term>
+ <listitem>
+ <para>These switches enable
+ support for version 4 and 5 of the full text search (FTS)
+ extension.</para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term><parameter>CPPFLAGS="-D SQLITE_ENABLE_COLUMN_METADATA=1 ... </parameter></term>
+ <listitem>
+ <para>Some applications require these options to be turned on.
+ The only way to do this is to include them in
+ the <envar>CFLAGS</envar> or <envar>CPPFLAGS</envar>.
+ We use the latter so the default value (or any value set by the user)
+ of <envar>CFLAGS</envar> won't be affected.
+ For further information on what can be specified see <ulink
+ url="https://www.sqlite.org/compile.html"/>.</para>
+ </listitem>
+ </varlistentry>
+ </variablelist>
+
+ <para>Compile the package:</para>
+
+<screen><userinput remap="make">make</userinput></screen>
+
+ <para>
+ Now, as the <systemitem class="username">root</systemitem> user:
+ </para>
+
+<screen><userinput remap="install">make install</userinput></screen>
+
+ </sect2>
+
+ <sect2 id="contents-sqlite" role="content">
+ <title>Contents of SQLite</title>
+
+ <segmentedlist>
+ <segtitle>Installed Program</segtitle>
+ <segtitle>Installed Library</segtitle>
+ <segtitle>Installed Directory</segtitle>
+
+ <seglistitem>
+ <seg>
+ sqlite3
+ </seg>
+ <seg>
+ libsqlite3.so
+ </seg>
+ <seg>
+ /usr/share/doc/sqlite-&sqlite-version;
+ </seg>
+ </seglistitem>
+ </segmentedlist>
+
+ <variablelist>
+ <bridgehead renderas="sect3">Short Descriptions</bridgehead>
+ <?dbfo list-presentation="list"?>
+ <?dbhtml list-presentation="table"?>
+
+ <varlistentry id="sqlite3">
+ <term><command>sqlite3</command></term>
+ <listitem>
+ <para>
+ is a terminal-based front-end to the <application>SQLite</application>
+ library that can evaluate queries interactively and display the
+ results
+ </para>
+ <indexterm zone="ch-system-sqlite sqlite3">
+ <primary sortas="b-sqlite3">sqlite3</primary>
+ </indexterm>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry id="libsqlite3">
+ <term><filename class="libraryfile">libsqlite3.so</filename></term>
+ <listitem>
+ <para>
+ contains the <application>SQLite</application> API functions
+ </para>
+ <indexterm zone="ch-system-sqlite libsqlite3">
+ <primary sortas="c-libsqlite3">libsqlite3.so</primary>
+ </indexterm>
+ </listitem>
+ </varlistentry>
+
+ </variablelist>
+
+ </sect2>
+
+</sect1>
diff --git a/packages.ent b/packages.ent
index 4f083ed55..53840b88a 100644
--- a/packages.ent
+++ b/packages.ent
@@ -581,6 +581,14 @@
<!ENTITY patch-fin-du "13 MB">
<!ENTITY patch-fin-sbu "0.2 SBU">
+<!ENTITY pcre2-version "10.45">
+<!ENTITY pcre2-size "1.9 MB">
+<!ENTITY pcre2-url "https://github.com/PCRE2Project/pcre2/releases/download/pcre2-&pcre2-version;/pcre2-&pcre2-version;.tar.bz2">
+<!ENTITY pcre2-md5 "f71abbe1b5adf25cd9af5d26ef223b66">
+<!ENTITY pcre2-home "https://github.com/PCRE2Project">
+<!ENTITY pcre2-fin-du "20 MB">
+<!ENTITY pcre2-fin-sbu "0.5 SBU">
+
<!ENTITY perl-version-major "5">
<!ENTITY perl-version-minor "42">
<!ENTITY perl-version-patch "0">
@@ -671,6 +679,16 @@
<!ENTITY shadow-fin-du "115 MB">
<!ENTITY shadow-fin-sbu "0.1 SBU">
+<!ENTITY sqlite-version "3.50.4">
+<!ENTITY sqlite-version-pkg "3500400">
+<!ENTITY sqlite-year "2025">
+<!ENTITY sqlite-size "3.0 MB">
+<!ENTITY sqlite-url "https://sqlite.org/&sqlite-year;/sqlite-autoconf-&sqlite-version-pkg;.tar.gz">
+<!ENTITY sqlite-md5 "d74bbdca4ab1b2bd46d3b3f8dbb0f3db">
+<!ENTITY sqlite-home "https://sqlite.org">
+<!ENTITY sqlite-fin-du "0.0 MB">
+<!ENTITY sqlite-fin-sbu "0.1 SBU">
+
<!ENTITY sysklogd-version "2.7.2">
<!ENTITY sysklogd-size "474 KB">
<!ENTITY sysklogd-url "https://github.com/troglobit/sysklogd/releases/download/v&sysklogd-version;/sysklogd-&sysklogd-version;.tar.gz">
--
To stop receiving notification emails like this one, please contact
the administrator of this repository.
--
http://lists.linuxfromscratch.org/sympa/info/lfs-book
Unsubscribe: See the above information page