;;; 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 (gnu 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.39.3") (source (origin (method url-fetch) (uri (sqlite-uri version 2022)) (patches (search-patches "sqlite-hurd.patch")) (sha256 (base32 "1f922kq16g7f4h3gpzim78lvrp5xw9nvlvqw97s2qgxyh8qgns3q")))) (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.45.1") (source (origin (method url-fetch) (uri (sqlite-uri version 2024)) (sha256 (base32 "02lssjiwyvsrr80rp62n0msds0f7hq5y4lbni74k4nbs3f22g76d")))))) .1....Andreas Enge 2024-01-24gnu: singular: Update to 4.3.2p10....Andreas Enge 2024-01-19gnu: symengine: Update to 0.11.2....Vinicius Monego 2023-12-25gnu: Adjust to removing ed.scm and nano.scm...Efraim Flashner 2023-11-26gnu: fftw: Update to 3.3.10...mtekman 2023-11-03gnu: symengine: Update to 0.11.1....Vinicius Monego