| Newsgroups |
gmane.linux.lfs.book |
| Message-ID |
<175702705836.14639.17562942979782862627@rivendell.linuxfromscratch.org> |
This is an automated email from the git hooks/post-receive script.
git pushed a commit to branch trunk
in repository lfs.
The following commit(s) were added to refs/heads/trunk by this push:
new cdd3eabbd Add the sqlite-3.50.4.
new 09e1aa056 Merge branch 'trunk' of git.linuxfromscratch.org:lfs into trunk
cdd3eabbd is described below
commit cdd3eabbd5dceb26c953e79ab473be25b00d4c9f
Author: Bruce Dubbs <[email protected]>
AuthorDate: Thu Sep 4 18:03:44 2025 -0500
Add the sqlite-3.50.4.
---
appendices/dependencies.xml | 43 ++++++++++++-
chapter01/changelog.xml | 6 +-
chapter01/whatsnew.xml | 1 +
chapter03/packages.xml | 24 ++++++++
chapter08/chapter08.xml | 1 +
chapter08/sqlite.xml | 144 ++++++++++++++++++++++++++++++++++++++++++++
packages.ent | 14 +++++
prologue/why.xml | 7 +++
8 files changed, 238 insertions(+), 2 deletions(-)
diff --git a/appendices/dependencies.xml b/appendices/dependencies.xml
index 0d69afa46..55f424c73 100644
--- a/appendices/dependencies.xml
+++ b/appendices/dependencies.xml
@@ -2584,7 +2584,7 @@
<segtitle>&dependencies;</segtitle>
<seglistitem>
<seg>Bash, Binutils, Coreutils, Gawk, GCC, Glibc, Grep, Make,
- and Sed</seg>
+ Sed, and Sqlite</seg>
</seglistitem>
</segmentedlist>
@@ -2909,6 +2909,47 @@
</seglistitem>
</segmentedlist>
+<!-- Begin Sqlite dependency info -->
+ <bridgehead renderas="sect2" id="Sqlite-dep">Pcre2</bridgehead>
+
+ <segmentedlist id="Sqlite-depends">
+ <segtitle>&dependencies;</segtitle>
+ <seglistitem>
+ <seg>Bash, Binutils, GCC, Glibc, Gzip, Make, Ncurses, and Readline</seg>
+ </seglistitem>
+ </segmentedlist>
+
+ <segmentedlist id="Sqlite-rundeps">
+ <segtitle>&runtime;</segtitle>
+ <seglistitem>
+ <seg>Glibc</seg>
+ </seglistitem>
+ </segmentedlist>
+
+ <segmentedlist id="Sqlite-testdeps">
+ <segtitle>&testsuites;</segtitle>
+ <seglistitem>
+ <seg>None</seg>
+ </seglistitem>
+ </segmentedlist>
+
+ <segmentedlist id="Sqlite-before">
+ <segtitle>&before;</segtitle>
+ <seglistitem>
+ <seg>Python</seg>
+ </seglistitem>
+ </segmentedlist>
+
+ <segmentedlist id="Sqlite-optdeps">
+ <segtitle>&external;</segtitle>
+ <seglistitem>
+ <seg>
+ <ulink url="&blfs-book;general/libarchive.html">libarchive</ulink> and
+ <ulink url="https://thrysoee.dk/editline/">libedit</ulink>
+ </seg>
+ </seglistitem>
+ </segmentedlist>
+
<!-- Begin Sysklogd dependency info -->
<bridgehead renderas="sect2" id="sysklogd-dep" revision="sysv">Sysklogd</bridgehead>
diff --git a/chapter01/changelog.xml b/chapter01/changelog.xml
index 5cd66724b..703788ee1 100644
--- a/chapter01/changelog.xml
+++ b/chapter01/changelog.xml
@@ -44,7 +44,11 @@
<para>2025-09-03</para>
<itemizedlist>
<listitem>
- <para>[bdubbs] - Add the pcre2 package. Fixes
+ <para>[bdubbs] - Add the sqlite-3.50.4 package. Fixes
+ <ulink url='&lfs-ticket-root;5784'>#5784</ulink>.</para>
+ </listitem>
+ <listitem>
+ <para>[bdubbs] - Add the pcre2-10.45 package. Fixes
<ulink url='&lfs-ticket-root;5782'>#5782</ulink>.</para>
</listitem>
<listitem>
diff --git a/chapter01/whatsnew.xml b/chapter01/whatsnew.xml
index 17fb72490..c92a5755b 100644
--- a/chapter01/whatsnew.xml
+++ b/chapter01/whatsnew.xml
@@ -293,6 +293,7 @@
<title>Added:</title>
<listitem><para></para></listitem> <!-- satisfy build -->
<listitem><para>pcre2</para></listitem>
+ <listitem><para>sqlite</para></listitem>
</itemizedlist>
<itemizedlist>
diff --git a/chapter03/packages.xml b/chapter03/packages.xml
index 68a1a6f05..2d5349db5 100644
--- a/chapter03/packages.xml
+++ b/chapter03/packages.xml
@@ -733,6 +733,30 @@
</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>
+ <term>Sqlite Documentation (&sqlite-version;) - <token>&sqlite-doc-size;</token>:</term>
+ <listitem>
+ <para>Home page: <ulink url="&sqlite-home;"/></para>
+ <para>Download: <ulink url="&sqlite-doc-url;"/></para>
+ <para>MD5 sum: <literal>&sqlite-doc-md5;</literal></para>
+
+ <note>
+ <para>The Linux From Scratch team generates its own tarball of the
+ documentation pages using the sqlite documentation zip file. This is done
+ in order to avoid unnecessary dependencies.</para>
+ </note>
+ </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 4e2d94a98..6d3207021 100644
--- a/chapter08/chapter08.xml
+++ b/chapter08/chapter08.xml
@@ -63,6 +63,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..e01eded51
--- /dev/null
+++ b/chapter08/sqlite.xml
@@ -0,0 +1,144 @@
+<?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 Sqlite 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>Unpack the documentation:</para>
+
+<screen><userinput remap="pre">tar -xf ../sqlite-doc-&sqlite-doc-version;.tar.xz</userinput></screen>
+
+ <para>Prepare Sqlite for compilation with:</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 make option:</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 CFLAGS or CPPFLAGS. We use
+ the latter so the default value (or any value set by the user) of
+ CFLAGS won't be affected. For further information on what can be
+ specified see https://www.sqlite.org/compile.html.</para>
+ </listitem>
+ </varlistentry>
+
+ </variablelist>
+
+ <para>Compile the package:</para>
+
+<screen><userinput remap="make">make</userinput></screen>
+
+ <para>This package does not come with a test suite.</para>
+
+ <para>Install the package:</para>
+
+<screen><userinput remap="install">make install</userinput></screen>
+
+ <para>If desired, install the documentation:</para>
+
+<screen><userinput remap="install">install -v -m755 -d /usr/share/doc/sqlite-&sqlite-short-version;
+cp -v -R sqlite-doc-&sqlite-doc-version;/* /usr/share/doc/sqlite-&sqlite-short-version;</userinput></screen>
+
+ </sect2>
+
+ <sect2 id="contents-sqlite" role="content">
+ <title>Contents of Sqlite</title>
+
+ <segmentedlist>
+ <segtitle>Installed programs</segtitle>
+ <segtitle>Installed libraries</segtitle>
+ <segtitle>Installed directories</segtitle>
+
+ <seglistitem>
+ <seg>sqlite3</seg>
+ <seg>libsqlite3.so</seg>
+ <seg>/usr/share/doc/sqlite-&sqlite-short-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 SQLite 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.so">
+ <term><filename class="libraryfile">libsqlite3.so</filename></term>
+ <listitem>
+ <para>contains the SQLite API functions</para>
+ <indexterm zone="ch-system-sqlite libsqlite3.so">
+ <primary sortas="c-libsqlite3.so">libsqlite3.so</primary>
+ </indexterm>
+ </listitem>
+ </varlistentry>
+
+ </variablelist>
+
+ </sect2>
+
+</sect1>
diff --git a/packages.ent b/packages.ent
index 256ea0b15..74bd854e3 100644
--- a/packages.ent
+++ b/packages.ent
@@ -663,6 +663,20 @@
<!ENTITY shadow-fin-du "115 MB">
<!ENTITY shadow-fin-sbu "0.1 SBU">
+<!ENTITY sqlite-version "3500400">
+<!ENTITY sqlite-short-version "3.50.4">
+<!ENTITY sqlite-year "2025">
+<!ENTITY sqlite-size "3,099 KB">
+<!ENTITY sqlite-url "https://sqlite.org/&sqlite-year;/sqlite-autoconf-&sqlite-version;.tar.gz">
+<!ENTITY sqlite-md5 "d74bbdca4ab1b2bd46d3b3f8dbb0f3db">
+<!ENTITY sqlite-home "https://sqlite.org">
+<!ENTITY sqlite-fin-du "71 MB">
+<!ENTITY sqlite-fin-sbu "0.4 SBU">
+<!ENTITY sqlite-doc-version "&sqlite-version;">
+<!ENTITY sqlite-doc-size "5,943 KB">
+<!ENTITY sqlite-doc-url "&anduin-sources;/sqlite-doc-&sqlite-doc-version;.tar.xz">
+<!ENTITY sqlite-doc-md5 "63a62af5b35913459954e6e66876f2b8">
+
<!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">
diff --git a/prologue/why.xml b/prologue/why.xml
index 45874dc51..28e3aca36 100644
--- a/prologue/why.xml
+++ b/prologue/why.xml
@@ -553,6 +553,13 @@
securely.</para>
</listitem>
+ <listitem>
+ <para>Sqlite</para>
+
+ <para>This package provides a serverless, zero-configuration,
+ transactional SQL database engine.</para>
+ </listitem>
+
<listitem revision="sysv">
<para>Sysklogd</para>
--
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