packages: Add sqlite module.

* New module: sqlite.

1 files changed, 125 insertions, 0 deletions

diff --git a/hecate/packages/sqlite.scm b/hecate/packages/sqlite.scm
new file mode 100644
index 0000000..bfb91f0
--- /dev/null
+++ b/hecate/packages/sqlite.scm
@@ -0,0 +1,125 @@
+;;; GNU Guix --- Functional package management for GNU
+;;; Copyright © 2013, 2015, 2018, 2020 Ludovic Courtès <[email protected]>
+;;; Copyright © 2014, 2015, 2016, 2018 Mark H Weaver <[email protected]>
+;;; Copyright © 2014 Sree Harsha Totakura <[email protected]>
+;;; Copyright © 2015, 2016 Sou Bunnbu <[email protected]>
+;;; Copyright © 2016 Efraim Flashner <[email protected]>
+;;; Copyright © 2016 Ben Woodcroft <[email protected]>
+;;; Copyright © 2016 David Craven <[email protected]>
+;;; Copyright © 2016, 2017, 2018, 2019, 2020, 2021 Marius Bakke <[email protected]>
+;;; Copyright © 2017 Ricardo Wurmus <[email protected]>
+;;; Copyright © 2017 Jelle Licht <[email protected]>
+;;; Copyright © 2018 Tobias Geerinckx-Rice <[email protected]>
+;;; Copyright © 2018 Alex Vong <[email protected]>
+;;; Copyright © 2020 Jan (janneke) Nieuwenhuizen <[email protected]>
+;;; Copyright © 2022 Matthew James Kraai <[email protected]>
+;;; Copyright © 2024 Zhu Zihao <[email protected]>
+;;;
+;;; This file is part of GNU Guix.
+;;;
+;;; GNU Guix is free software; you can redistribute it and/or modify it
+;;; under the terms of the GNU General Public License as published by
+;;; the Free Software Foundation; either version 3 of the License, or (at
+;;; your option) any later version.
+;;;
+;;; GNU Guix is distributed in the hope that it will be useful, but
+;;; WITHOUT ANY WARRANTY; without even the implied warranty of
+;;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+;;; GNU General Public License for more details.
+;;;
+;;; You should have received a copy of the GNU General Public License
+;;; along with GNU Guix.  If not, see <http://www.gnu.org/licenses/>.
+
+(define-module (hecate packages sqlite)
+  #:use-module (gnu packages)
+  #:use-module (gnu packages hurd)
+  #:use-module (gnu packages readline)
+  #:use-module ((guix licenses) #:prefix license:)
+  #:use-module (guix packages)
+  #:use-module (guix download)
+  #:use-module (guix build-system gnu)
+  #:use-module (guix utils)
+  #:use-module (guix deprecation)
+  #:use-module (ice-9 match)
+  #:use-module (srfi srfi-26))
+
+;;; Commentary:
+;;;
+;;; This module has been separated from (gnu packages databases) to reduce the
+;;; number of module references for core packages.
+
+(define (sqlite-uri version year)
+  (let ((numeric-version
+         (match (string-split version #\.)
+           ((first-digit other-digits ...)
+            (string-append first-digit
+                           (string-pad-right
+                            (string-concatenate
+                             (map (cut string-pad <> 2 #\0)
+                                  other-digits))
+                            6 #\0))))))
+    (string-append "https://sqlite.org/" (number->string year)
+                   "/sqlite-autoconf-" numeric-version ".tar.gz")))
+
+(define-public sqlite
+  (package
+   (name "sqlite")
+   (version "3.46.0")
+   (source (origin
+            (method url-fetch)
+            (uri (sqlite-uri version 2024))
+            (patches (search-patches "sqlite-hurd.patch"))
+            (sha256
+             (base32
+              "0zbs853s8ly693qdg0l7vs4shwn3plmvdczr2s478wsj6dxnm3kg"))))
+   (build-system gnu-build-system)
+   (inputs (list readline))
+   (outputs '("out" "static"))
+   (arguments
+    `(#:configure-flags
+      ;; Add -DSQLITE_SECURE_DELETE, -DSQLITE_ENABLE_FTS3,
+      ;; -DSQLITE_ENABLE_UNLOCK_NOTIFY and -DSQLITE_ENABLE_DBSTAT_VTAB
+      ;; to CFLAGS.  GNU Icecat will refuse to use the system SQLite
+      ;; unless these options are enabled.
+      (list (string-append "CFLAGS=-O2 -g -DSQLITE_SECURE_DELETE "
+                           "-DSQLITE_ENABLE_FTS3 "
+                           "-DSQLITE_ENABLE_UNLOCK_NOTIFY "
+                           "-DSQLITE_ENABLE_DBSTAT_VTAB "
+                           ;; Column metadata is required by GNU Jami and Qt, et.al.
+                           "-DSQLITE_ENABLE_COLUMN_METADATA"))
+      #:phases (modify-phases %standard-phases
+                 (add-after 'install 'move-static-library
+                   (lambda* (#:key outputs #:allow-other-keys)
+                     (let* ((out    (assoc-ref outputs "out"))
+                            (static (assoc-ref outputs "static"))
+                            (source (string-append out "/lib/libsqlite3.a")))
+                       (mkdir-p (string-append static "/lib"))
+                       (link source (string-append static "/lib/libsqlite3.a"))
+                       (delete-file source)
+
+                       ;; Remove reference to the static library from the .la file
+                       ;; so that Libtool looks for it in the usual places.
+                       (substitute* (string-append out "/lib/libsqlite3.la")
+                         (("^old_library=.*")
+                          "old_library=''\n"))
+                       #t))))))
+   (home-page "https://www.sqlite.org/")
+   (synopsis "The SQLite database management system")
+   (description
+    "SQLite is a software library that implements a self-contained, serverless,
+zero-configuration, transactional SQL database engine.  SQLite is the most
+widely deployed SQL database engine in the world.  The source code for SQLite
+is in the public domain.")
+   (license license:public-domain)))
+
+;; Newer version required for e.g. fossil.
+(define-public sqlite-next
+  (package
+    (inherit sqlite)
+    (version "3.46.0")
+    (source (origin
+              (method url-fetch)
+              (uri (sqlite-uri version 2024))
+              (sha256
+               (base32
+                "0zbs853s8ly693qdg0l7vs4shwn3plmvdczr2s478wsj6dxnm3kg"))))))