From 340494c477345c102747f3b6aa4075f43bf97670 Mon Sep 17 00:00:00 2001 From: Thanos Apollo Date: Sun, 21 Jul 2024 10:12:18 +0300 Subject: packages: Add sqlite module. * New module: sqlite. --- hecate/packages/sqlite.scm | 125 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 125 insertions(+) create mode 100644 hecate/packages/sqlite.scm 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 +;;; Copyright © 2014, 2015, 2016, 2018 Mark H Weaver +;;; Copyright © 2014 Sree Harsha Totakura +;;; Copyright © 2015, 2016 Sou Bunnbu +;;; Copyright © 2016 Efraim Flashner +;;; Copyright © 2016 Ben Woodcroft +;;; Copyright © 2016 David Craven +;;; Copyright © 2016, 2017, 2018, 2019, 2020, 2021 Marius Bakke +;;; Copyright © 2017 Ricardo Wurmus +;;; Copyright © 2017 Jelle Licht +;;; Copyright © 2018 Tobias Geerinckx-Rice +;;; Copyright © 2018 Alex Vong +;;; Copyright © 2020 Jan (janneke) Nieuwenhuizen +;;; Copyright © 2022 Matthew James Kraai +;;; Copyright © 2024 Zhu Zihao +;;; +;;; 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 . + +(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")))))) -- cgit v1.2.3