diff options
Diffstat (limited to 'nixpkgs/pkgs/development/libraries/sqlite')
4 files changed, 171 insertions, 0 deletions
diff --git a/nixpkgs/pkgs/development/libraries/sqlite/archive-version.nix b/nixpkgs/pkgs/development/libraries/sqlite/archive-version.nix new file mode 100644 index 000000000000..75d70680fbf9 --- /dev/null +++ b/nixpkgs/pkgs/development/libraries/sqlite/archive-version.nix @@ -0,0 +1,11 @@ +lib: version: + +with lib; + +let + fragments = splitVersion version; + major = head fragments; + minor = concatMapStrings (fixedWidthNumber 2) (tail fragments); +in + +major + minor + "00" diff --git a/nixpkgs/pkgs/development/libraries/sqlite/default.nix b/nixpkgs/pkgs/development/libraries/sqlite/default.nix new file mode 100644 index 000000000000..50b52b905a92 --- /dev/null +++ b/nixpkgs/pkgs/development/libraries/sqlite/default.nix @@ -0,0 +1,90 @@ +{ lib, stdenv, fetchurl, zlib, interactive ? false, readline ? null, ncurses ? null +, python3Packages +}: + +assert interactive -> readline != null && ncurses != null; + +with lib; + +let + archiveVersion = import ./archive-version.nix lib; +in + +stdenv.mkDerivation rec { + pname = "sqlite"; + version = "3.35.2"; + + # NB! Make sure to update ./tools.nix src (in the same directory). + src = fetchurl { + url = "https://sqlite.org/2021/sqlite-autoconf-${archiveVersion version}.tar.gz"; + sha256 = "1bfczv5006ycwr1vw7xbq7cmys0jvfr8awmx7wi1b40zyj0yss8j"; + }; + + outputs = [ "bin" "dev" "out" ]; + separateDebugInfo = stdenv.isLinux; + + buildInputs = [ zlib ] ++ optionals interactive [ readline ncurses ]; + + configureFlags = [ "--enable-threadsafe" ] ++ optional interactive "--enable-readline"; + + 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_RTREE" + "-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_LDFLAGS="$NIX_LDFLAGS -lm" + + echo "" + echo "NIX_CFLAGS_COMPILE = $NIX_CFLAGS_COMPILE" + echo "" + ''; + + postInstall = '' + # Do not contaminate dependent libtool-based projects with sqlite dependencies. + sed -i $out/lib/libsqlite3.la -e "s/dependency_libs=.*/dependency_libs='''/" + ''; + + doCheck = false; # fails to link against tcl + + passthru.tests = { + inherit (python3Packages) sqlalchemy; + }; + + meta = { + description = "A self-contained, serverless, zero-configuration, transactional SQL database engine"; + downloadPage = "https://sqlite.org/download.html"; + homepage = "https://www.sqlite.org/"; + license = licenses.publicDomain; + maintainers = with maintainers; [ eelco np ]; + platforms = platforms.unix ++ platforms.windows; + }; +} diff --git a/nixpkgs/pkgs/development/libraries/sqlite/sqlar.nix b/nixpkgs/pkgs/development/libraries/sqlite/sqlar.nix new file mode 100644 index 000000000000..0828f2f45543 --- /dev/null +++ b/nixpkgs/pkgs/development/libraries/sqlite/sqlar.nix @@ -0,0 +1,27 @@ +{ lib, stdenv, fetchurl, fuse, zlib }: + +stdenv.mkDerivation { + pname = "sqlar"; + version = "2018-01-07"; + + src = fetchurl { + url = "https://www.sqlite.org/sqlar/tarball/4824e73896/sqlar-src-4824e73896.tar.gz"; + sha256 = "09pikkbp93gqypn3da9zi0dzc47jyypkwc9vnmfzhmw7kpyv8nm9"; + }; + + buildInputs = [ fuse zlib ]; + + buildFlags = [ "sqlar" "sqlarfs" "CFLAGS=-Wno-error" ]; + + installPhase = '' + install -D -t $out/bin sqlar sqlarfs + ''; + + meta = with lib; { + homepage = "https://sqlite.org/sqlar"; + description = "SQLite Archive utilities"; + license = licenses.bsd2; + platforms = platforms.all; + maintainers = with maintainers; [ dtzWill ]; + }; +} diff --git a/nixpkgs/pkgs/development/libraries/sqlite/tools.nix b/nixpkgs/pkgs/development/libraries/sqlite/tools.nix new file mode 100644 index 000000000000..d260c4211ec9 --- /dev/null +++ b/nixpkgs/pkgs/development/libraries/sqlite/tools.nix @@ -0,0 +1,43 @@ +{ lib, stdenv, fetchurl, unzip, sqlite, tcl, Foundation }: + +let + archiveVersion = import ./archive-version.nix lib; + mkTool = { pname, makeTarget, description, homepage }: stdenv.mkDerivation rec { + inherit pname; + version = "3.35.2"; + + src = assert version == sqlite.version; fetchurl { + url = "https://sqlite.org/2021/sqlite-src-${archiveVersion version}.zip"; + sha256 = "00w7qggrdxpcrs4rfpqkjhcghi8pcx6zzjim9wlz6vsrxlr9dwva"; + }; + + nativeBuildInputs = [ unzip ]; + buildInputs = [ tcl ] ++ lib.optional stdenv.isDarwin Foundation; + + makeFlags = [ makeTarget ]; + + installPhase = "install -Dt $out/bin ${makeTarget}"; + + meta = with lib; { + inherit description homepage; + downloadPage = http://sqlite.org/download.html; + license = licenses.publicDomain; + maintainers = with maintainers; [ pesterhazy johnazoidberg ]; + platforms = platforms.unix; + }; + }; +in +{ + sqldiff = mkTool { + pname = "sqldiff"; + makeTarget = "sqldiff"; + description = "A tool that displays the differences between SQLite databases"; + homepage = "https://www.sqlite.org/sqldiff.html"; + }; + sqlite-analyzer = mkTool { + pname = "sqlite-analyzer"; + makeTarget = "sqlite3_analyzer"; + description = "A tool that shows statistics about SQLite databases"; + homepage = "https://www.sqlite.org/sqlanalyze.html"; + }; +} |