Something went wrong. Try again.
What happens if I push all of nixpkgs
Something went wrong. Try again.
5.1 kB · 171 lines
Nix
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172{ lib, stdenv, fetchurl, unzip, zlib, readline, ncurses,
# for tests python3Packages, sqldiff, sqlite-analyzer, sqlite-rsync, tinysparql,
# uses readline & ncurses for a better interactive experience if set to true interactive ? false,
gitUpdater, buildPackages,}:
let archiveVersion = import ./archive-version.nix lib;in
stdenv.mkDerivation rec { pname = "sqlite${lib.optionalString interactive "-interactive"}"; version = "3.50.2";
# nixpkgs-update: no auto update # NB! Make sure to update ./tools.nix src (in the same directory). src = fetchurl { url = "https://sqlite.org/2025/sqlite-autoconf-${archiveVersion version}.tar.gz"; hash = "sha256-hKYW/9MXOORZC2W6uzqeHvk3DzY4422yIO4Oc/itIVY="; }; docsrc = fetchurl { url = "https://sqlite.org/2025/sqlite-doc-${archiveVersion version}.zip"; hash = "sha256-n4uitTo6oskWbUagLZEbhdO4sLhAxJHTIdX8YhUONBk="; };
outputs = [ "bin" "dev" "man" "doc" "out" ]; separateDebugInfo = stdenv.hostPlatform.isLinux;
depsBuildBuild = [ buildPackages.stdenv.cc ];
nativeBuildInputs = [ unzip ]; buildInputs = [ zlib ] ++ lib.optionals interactive [ readline ncurses ];
# required for aarch64 but applied for all arches for simplicity preConfigure = '' patchShebangs configure '';
# sqlite relies on autosetup now; so many of the # previously-understood flags are gone. They should instead be set # on a per-output basis. setOutputFlags = false;
configureFlags = [ "--bindir=${placeholder "bin"}/bin" "--includedir=${placeholder "dev"}/include" "--libdir=${placeholder "out"}/lib" ] ++ lib.optional (!interactive) "--disable-readline" # autosetup only looks up readline.h in predefined set of directories. ++ lib.optional interactive "--with-readline-header=${lib.getDev readline}/include/readline/readline.h" ++ lib.optional (stdenv.hostPlatform.isStatic) "--disable-shared";
env.NIX_CFLAGS_COMPILE = toString [ "-DSQLITE_ENABLE_COLUMN_METADATA" "-DSQLITE_ENABLE_DBSTAT_VTAB" "-DSQLITE_ENABLE_JSON1" "-DSQLITE_ENABLE_FTS3" "-DSQLITE_ENABLE_FTS3_PARENTHESIS" "-DSQLITE_ENABLE_FTS3_TOKENIZER" "-DSQLITE_ENABLE_FTS4" "-DSQLITE_ENABLE_FTS5" "-DSQLITE_ENABLE_GEOPOLY" "-DSQLITE_ENABLE_MATH_FUNCTIONS" "-DSQLITE_ENABLE_PREUPDATE_HOOK" "-DSQLITE_ENABLE_RBU" "-DSQLITE_ENABLE_RTREE" "-DSQLITE_ENABLE_SESSION" "-DSQLITE_ENABLE_STMT_SCANSTATUS" "-DSQLITE_ENABLE_UNLOCK_NOTIFY" "-DSQLITE_SOUNDEX" "-DSQLITE_SECURE_DELETE" "-DSQLITE_MAX_VARIABLE_NUMBER=250000" "-DSQLITE_MAX_EXPR_DEPTH=10000" ];
# Test for features which may not be available at compile time preBuild = '' # Use pread(), pread64(), pwrite(), pwrite64() functions for better performance if they are available. if cc -Werror=implicit-function-declaration -x c - -o "$TMPDIR/pread_pwrite_test" <<< \ ''$'#include <unistd.h>\nint main()\n{\n pread(0, NULL, 0, 0);\n pwrite(0, NULL, 0, 0);\n return 0;\n}'; then export NIX_CFLAGS_COMPILE="$NIX_CFLAGS_COMPILE -DUSE_PREAD" fi if cc -Werror=implicit-function-declaration -x c - -o "$TMPDIR/pread64_pwrite64_test" <<< \ ''$'#include <unistd.h>\nint main()\n{\n pread64(0, NULL, 0, 0);\n pwrite64(0, NULL, 0, 0);\n return 0;\n}'; then export NIX_CFLAGS_COMPILE="$NIX_CFLAGS_COMPILE -DUSE_PREAD64" elif cc -D_LARGEFILE64_SOURCE -Werror=implicit-function-declaration -x c - -o "$TMPDIR/pread64_pwrite64_test" <<< \ ''$'#include <unistd.h>\nint main()\n{\n pread64(0, NULL, 0, 0);\n pwrite64(0, NULL, 0, 0);\n return 0;\n}'; then export NIX_CFLAGS_COMPILE="$NIX_CFLAGS_COMPILE -DUSE_PREAD64 -D_LARGEFILE64_SOURCE" fi
# Necessary for FTS5 on Linux export NIX_CFLAGS_LINK="$NIX_CFLAGS_LINK -lm"
echo "" echo "NIX_CFLAGS_COMPILE = $NIX_CFLAGS_COMPILE" echo "" '';
postInstall = '' mkdir -p $doc/share/doc unzip $docsrc mv sqlite-doc-${archiveVersion version} $doc/share/doc/sqlite '';
doCheck = false; # fails to link against tcl
passthru = { tests = { inherit (python3Packages) sqlalchemy; inherit sqldiff sqlite-analyzer sqlite-rsync tinysparql ; };
updateScript = gitUpdater { # No nicer place to look for latest version. url = "https://github.com/sqlite/sqlite.git"; # Expect tags like "version-3.43.0". rev-prefix = "version-"; }; };
meta = with lib; { changelog = "https://www.sqlite.org/releaselog/${lib.replaceStrings [ "." ] [ "_" ] version}.html"; description = "Self-contained, serverless, zero-configuration, transactional SQL database engine"; downloadPage = "https://sqlite.org/download.html"; homepage = "https://www.sqlite.org/"; license = licenses.publicDomain; mainProgram = "sqlite3"; maintainers = with maintainers; [ np ]; platforms = platforms.unix ++ platforms.windows; pkgConfigModules = [ "sqlite3" ]; };}