diff options
Diffstat (limited to 'nixpkgs/pkgs/development/libraries/sqlite')
4 files changed, 153 insertions, 0 deletions
diff --git a/nixpkgs/pkgs/development/libraries/sqlite/analyzer.nix b/nixpkgs/pkgs/development/libraries/sqlite/analyzer.nix new file mode 100644 index 000000000000..38eb1b158c89 --- /dev/null +++ b/nixpkgs/pkgs/development/libraries/sqlite/analyzer.nix @@ -0,0 +1,31 @@ +{ stdenv, fetchurl, unzip, sqlite, tcl }: + +let + archiveVersion = import ./archive-version.nix stdenv.lib; +in + +stdenv.mkDerivation rec { + pname = "sqlite-analyzer"; + version = "3.31.1"; + + src = assert version == sqlite.version; fetchurl { + url = "https://sqlite.org/2020/sqlite-src-${archiveVersion version}.zip"; + sha256 = "0n7f3w59gr80s6k4l5a9bp2s97dlfapfbhb3qdhak6axhn127p7j"; + }; + + nativeBuildInputs = [ unzip ]; + buildInputs = [ tcl ]; + + makeFlags = [ "sqlite3_analyzer" ]; + + installPhase = "install -Dt $out/bin sqlite3_analyzer"; + + meta = with stdenv.lib; { + description = "A tool that shows statistics about SQLite databases"; + downloadPage = http://sqlite.org/download.html; + homepage = https://www.sqlite.org; + license = licenses.publicDomain; + maintainers = with maintainers; [ pesterhazy ]; + platforms = platforms.unix; + }; +} 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..a59325ba6caf --- /dev/null +++ b/nixpkgs/pkgs/development/libraries/sqlite/default.nix @@ -0,0 +1,84 @@ +{ stdenv, fetchurl, zlib, interactive ? false, readline ? null, ncurses ? null }: + +assert interactive -> readline != null && ncurses != null; + +with stdenv.lib; + +let + archiveVersion = import ./archive-version.nix stdenv.lib; +in + +stdenv.mkDerivation rec { + pname = "sqlite"; + version = "3.31.1"; + + # NB! Make sure to update analyzer.nix src (in the same directory). + src = fetchurl { + url = "https://sqlite.org/2020/sqlite-autoconf-${archiveVersion version}.tar.gz"; + sha256 = "1bj936svd8i5g25xd1bj52hj4zca01fgl3sqkj86z9q5pkz4wa32"; + }; + + 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 + + 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..739dfc3bc5b4 --- /dev/null +++ b/nixpkgs/pkgs/development/libraries/sqlite/sqlar.nix @@ -0,0 +1,27 @@ +{ 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" ]; + + installPhase = '' + install -D -t $out/bin sqlar sqlarfs + ''; + + meta = with stdenv.lib; { + homepage = https://sqlite.org/sqlar; + description = "SQLite Archive utilities"; + license = licenses.bsd2; + platforms = platforms.all; + maintainers = with maintainers; [ dtzWill ]; + }; +} |