HCoop / jackhill / guix / guix.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
gnu: Remove python2-mysqlclient.
[jackhill/guix/guix.git] / gnu / packages / databases.scm
CommitLineData
5f96f303 1;;; GNU Guix --- Functional package management for GNU
189be331 2;;; Copyright © 2012, 2013, 2014, 2015, 2016, 2018 Ludovic Courtès <ludo@gnu.org>
a8714bf6
RW		 3;;; Copyright © 2012, 2013, 2014, 2015, 2016 Andreas Enge <andreas@enge.fr>
4;;; Copyright © 2013, 2017 Cyril Roelandt <tipecaml@gmail.com>
218a2106 5;;; Copyright © 2014, 2016 David Thompson <davet@gnu.org>
b9ed5ef3 6;;; Copyright © 2014, 2015, 2016, 2018 Mark H Weaver <mhw@netris.org>
a8714bf6 7;;; Copyright © 2014, 2015 Eric Bavier <bavier@member.fsf.org>
da1f7a9e 8;;; Copyright © 2015, 2016 Sou Bunnbu <iyzsong@gmail.com>
b747a9db 9;;; Copyright © 2015 Leo Famulari <leo@famulari.name>
a8714bf6
RW		 10;;; Copyright © 2015 Eric Dvorsak <eric@dvorsak.fr>
11;;; Copyright © 2016 Hartmut Goebel <h.goebel@crazy-compilers.com>
12;;; Copyright © 2016 Christopher Allan Webber <cwebber@dustycloud.org>
9930beb8 13;;; Copyright © 2015, 2016, 2017, 2018, 2019, 2020 Efraim Flashner <efraim@flashner.co.il>
3c986a7d 14;;; Copyright © 2016, 2017 Nikita <nikita@n0.is>
6d09a7b5 15;;; Copyright © 2016, 2017, 2018 Roel Janssen <roel@gnu.org>
0e1b262e 16;;; Copyright © 2016 David Craven <david@craven.ch>
fe71eee0 17;;; Copyright © 2016 Jan Nieuwenhuizen <janneke@gnu.org>
62ea44fc 18;;; Copyright © 2016 Andy Patterson <ajpatter@uwaterloo.ca>
a8714bf6 19;;; Copyright © 2016 Danny Milosavljevic <dannym+a@scratchpost.org>
51d42caa 20;;; Copyright © 2016, 2017, 2018, 2019, 2020 Marius Bakke <mbakke@fastmail.com>
c336567d 21;;; Copyright © 2017, 2018 Julien Lepiller <julien@lepiller.eu>
7dc0f1d5 22;;; Copyright © 2017, 2020 Thomas Danckaert <post@thomasdanckaert.be>
a8714bf6
RW		 23;;; Copyright © 2017 Jelle Licht <jlicht@fsfe.org>
24;;; Copyright © 2017 Adriano Peluso <catonano@gmail.com>
d39a84e8 25;;; Copyright © 2017 Arun Isaac <arunisaac@systemreboot.net>
a8fa39cd 26;;; Copyright © 2017, 2018, 2019, 2020 Tobias Geerinckx-Rice <me@tobias.gr>
38abef12 27;;; Copyright © 2017, 2018 Alex Vong <alexvong1995@gmail.com>
19601e89 28;;; Copyright © 2017, 2018 Ben Woodcroft <donttrustben@gmail.com>
231123ee 29;;; Copyright © 2017 Rutger Helling <rhelling@mykolab.com>
7bcc3405 30;;; Copyright © 2017, 2018 Pierre Langlois <pierre.langlois@gmx.com>
e58d3a59 31;;; Copyright © 2015, 2017, 2018, 2019 Ricardo Wurmus <rekado@elephly.net>
16973071 32;;; Copyright © 2017 Kristofer Buffington <kristoferbuffington@gmail.com>
3926a099 33;;; Copyright © 2018 Amirouche Boubekki <amirouche@hypermove.net>
dae7661a 34;;; Copyright © 2018 Joshua Sierles, Nextjournal <joshua@nextjournal.com>
da602679 35;;; Copyright © 2018 Maxim Cournoyer <maxim.cournoyer@gmail.com>
9df78675 36;;; Copyright © 2019 Jack Hill <jackhill@jackhill.us>
a3abc3fd 37;;; Copyright © 2019 Alex Griffin <a@ajgrf.com>
91477def 38;;; Copyright © 2019 Gábor Boskovits <boskovits@gmail.com>
450d5dc2 39;;; Copyright © 2019 Pierre Langlois <pierre.langlois@gmx.com>
ae8a0184 40;;; Copyright © 2019 Guillaume Le Vaillant <glv@posteo.net>
2072bc08 41;;; Copyright © 2020 Pierre Neidhardt <mail@ambrevar.xyz>
659bc436 42;;; Copyright © 2020 Nicolò Balzarotti <nicolo@nixo.xyz>
1655e7be 43;;; Copyright © 2020 Tanguy Le Carrour <tanguy@bioneland.org>
ba0b249d 44;;; Copyright © 2020 Lars-Dominik Braun <ldb@leibniz-psychology.org>
8de54c63 45;;; Copyright © 2020 Guy Fleury Iteriteka <gfleury@disroot.org>
d343e0fe 46;;; Copyright © 2020 Michael Rohleder <mike@rohleder.de>
5f96f303
LC		 47;;;
48;;; This file is part of GNU Guix.
49;;;
50;;; GNU Guix is free software; you can redistribute it and/or modify it
51;;; under the terms of the GNU General Public License as published by
52;;; the Free Software Foundation; either version 3 of the License, or (at
53;;; your option) any later version.
54;;;
55;;; GNU Guix is distributed in the hope that it will be useful, but
56;;; WITHOUT ANY WARRANTY; without even the implied warranty of
57;;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
58;;; GNU General Public License for more details.
59;;;
60;;; You should have received a copy of the GNU General Public License
61;;; along with GNU Guix. If not, see <http://www.gnu.org/licenses/>.
62
63(define-module (gnu packages databases)
64 #:use-module (gnu packages)
58071723 65 #:use-module (gnu packages admin)
06a035db 66 #:use-module (gnu packages algebra)
4c6aa73b
RJ		 67 #:use-module (gnu packages autotools)
68 #:use-module (gnu packages avahi)
77e52190 69 #:use-module (gnu packages base)
b747a9db 70 #:use-module (gnu packages bash)
06a035db 71 #:use-module (gnu packages bison)
23bbd7dd 72 #:use-module (gnu packages boost)
06a035db 73 #:use-module (gnu packages check)
dae7661a 74 #:use-module (gnu packages cmake)
06a035db 75 #:use-module (gnu packages compression)
62ea44fc 76 #:use-module (gnu packages crypto)
06a035db
MB		 77 #:use-module (gnu packages curl)
78 #:use-module (gnu packages cyrus-sasl)
255d1bbe 79 #:use-module (gnu packages dbm)
06a035db 80 #:use-module (gnu packages emacs)
da602679 81 #:use-module (gnu packages flex)
2fa55c72 82 #:use-module (gnu packages gcc)
4c6aa73b
RJ		 83 #:use-module (gnu packages gettext)
84 #:use-module (gnu packages glib)
06a035db 85 #:use-module (gnu packages gnupg)
16973071 86 #:use-module (gnu packages guile)
da1f7a9e 87 #:use-module (gnu packages time)
33c88fcb 88 #:use-module (gnu packages golang)
06a035db 89 #:use-module (gnu packages jemalloc)
708155df 90 #:use-module (gnu packages language)
686144e9 91 #:use-module (gnu packages libevent)
5f96f303 92 #:use-module (gnu packages linux)
a50628bb 93 #:use-module (gnu packages logging)
d39a84e8 94 #:use-module (gnu packages man)
a50628bb 95 #:use-module (gnu packages maths)
5f96f303 96 #:use-module (gnu packages ncurses)
aace6f6d 97 #:use-module (gnu packages onc-rpc)
d3c6ad0a 98 #:use-module (gnu packages parallel)
77631745 99 #:use-module (gnu packages pcre)
06a035db 100 #:use-module (gnu packages perl)
5ccde207 101 #:use-module (gnu packages perl-check)
cabe8f18 102 #:use-module (gnu packages perl-web)
4c6aa73b 103 #:use-module (gnu packages pkg-config)
d3c6ad0a 104 #:use-module (gnu packages popt)
a50628bb 105 #:use-module (gnu packages protobuf)
06a035db 106 #:use-module (gnu packages python)
9763102b 107 #:use-module (gnu packages python-crypto)
450d5dc2 108 #:use-module (gnu packages python-web)
312ec128 109 #:use-module (gnu packages python-science)
44d10b1f 110 #:use-module (gnu packages python-xyz)
4c6aa73b 111 #:use-module (gnu packages rdf)
06a035db 112 #:use-module (gnu packages readline)
a50628bb
KCB		 113 #:use-module (gnu packages regex)
114 #:use-module (gnu packages rpc)
afcbb020 115 #:use-module (gnu packages ruby)
6bbbca90 116 #:use-module (gnu packages serialization)
9d0c291e 117 #:use-module (gnu packages sphinx)
cd0322a3 118 #:use-module (gnu packages sqlite)
06a035db 119 #:use-module (gnu packages tcl)
33c88fcb
CB		 120 #:use-module (gnu packages terminals)
121 #:use-module (gnu packages textutils)
06a035db 122 #:use-module (gnu packages tls)
6bbbca90 123 #:use-module (gnu packages valgrind)
dae7661a 124 #:use-module (gnu packages web)
77631745 125 #:use-module (gnu packages xml)
0e1b262e 126 #:use-module ((guix licenses) #:prefix license:)
5f96f303
LC		 127 #:use-module (guix packages)
128 #:use-module (guix download)
da602679 129 #:use-module (guix bzr-download)
16973071 130 #:use-module (guix git-download)
9df78675 131 #:use-module (guix build-system emacs)
5f96f303 132 #:use-module (guix build-system gnu)
58071723 133 #:use-module (guix build-system go)
274da61d 134 #:use-module (guix build-system perl)
4d98bfaf 135 #:use-module (guix build-system python)
afcbb020 136 #:use-module (guix build-system ruby)
77631745 137 #:use-module (guix build-system cmake)
6e385b76 138 #:use-module (guix build-system scons)
9077cf68 139 #:use-module (guix build-system trivial)
329d13b8 140 #:use-module (guix utils)
29cfbfca 141 #:use-module (srfi srfi-1)
5f96f303
LC		 142 #:use-module (srfi srfi-26)
143 #:use-module (ice-9 match))
144
4c6aa73b
RJ		 145(define-public 4store
146 (package
147 (name "4store")
148 (version "1.1.6")
149 (source (origin
50e20b8f
EF		 150 (method git-fetch)
151 (uri (git-reference
b0e7b699 152 (url "https://github.com/4store/4store")
50e20b8f
EF		 153 (commit (string-append "v" version))))
154 (file-name (git-file-name name version))
4c6aa73b 155 (sha256
50e20b8f 156 (base32 "1kzdfmwpzy64cgqlkcz5v4klwx99w0jk7afckyf7yqbqb4rydmpk"))
ea09f99f
RJ		 157 (patches (search-patches "4store-unset-preprocessor-directive.patch"
158 "4store-fix-buildsystem.patch"))))
4c6aa73b
RJ		 159 (build-system gnu-build-system)
160 (native-inputs
161 `(("perl" ,perl)
162 ("python" ,python-2)
163 ("autoconf" ,autoconf)
164 ("automake" ,automake)
b94a6ca0 165 ("gettext" ,gettext-minimal)
4c6aa73b 166 ("libtool" ,libtool)
74c8b174 167 ("pcre" ,pcre "bin") ;for 'pcre-config'
4c6aa73b
RJ		 168 ("pkg-config" ,pkg-config)))
169 (inputs
170 `(("glib" ,glib)
171 ("rasqal" ,rasqal)
172 ("libxml2" ,libxml2)
173 ("raptor2" ,raptor2)
174 ("readline" ,readline)
175 ("avahi" ,avahi)
4c6aa73b
RJ		 176 ("cyrus-sasl" ,cyrus-sasl)
177 ("openssl" ,openssl)
bb93042c 178 ("util-linux" ,util-linux "lib")))
4c6aa73b 179 ;; http://www.4store.org has been down for a while now.
bbf9092b 180 (home-page "https://github.com/4store/4store")
4c6aa73b
RJ		 181 (synopsis "Clustered RDF storage and query engine")
182 (description "4store is a RDF/SPARQL store written in C, supporting
183either single machines or networked clusters.")
ba8b9f8d 184 (license license:gpl3+)))
4c6aa73b 185
58071723
CB		 186(define-public go-gopkg.in-mgo.v2
187 (package
188 (name "go-gopkg.in-mgo.v2")
189 (version "2016.08.01")
190 (source (origin
191 (method git-fetch)
192 (uri (git-reference
193 (url "https://github.com/go-mgo/mgo")
194 (commit (string-append "r" version))))
195 (file-name (git-file-name name version))
196 (sha256
197 (base32
198 "0rwbi1z63w43b0z9srm8m7iz1fdwx7bq7n2mz862d6liiaqa59jd"))))
199 (build-system go-build-system)
200 (arguments
201 `(#:import-path "gopkg.in/mgo.v2"
202 ;; TODO: The tests fail as MongoDB fails to start
203 ;; Error parsing command line: unrecognised option '--chunkSize'
204 #:tests? #f
205 #:phases
206 (modify-phases %standard-phases
207 (delete 'reset-gzip-timestamps)
208 (add-before 'check 'start-mongodb
209 (lambda* (#:key tests? #:allow-other-keys)
96272e28
MW		 210 (when tests?
211 (with-directory-excursion "src/gopkg.in/mgo.v2"
212 (invoke "make" "startdb")))
213 #t))
58071723
CB		 214 (add-after 'check 'stop'mongodb
215 (lambda* (#:key tests? #:allow-other-keys)
96272e28
MW		 216 (when tests?
217 (with-directory-excursion "src/gopkg.in/mgo.v2"
218 (invoke "make" "stopdb")))
219 #t)))))
58071723
CB		 220 (native-inputs
221 `(("go-gopkg.in-check.v1" ,go-gopkg.in-check.v1)
222 ("mongodb" ,mongodb)
223 ("daemontools" ,daemontools)))
224 (synopsis "@code{mgo} offers a rich MongoDB driver for Go.")
225 (description
226 "@code{mgo} (pronounced as mango) is a MongoDB driver for the Go language.
227It implements a rich selection of features under a simple API following
228standard Go idioms.")
de1d778e 229 (home-page "https://labix.org/mgo")
58071723
CB		 230 (license license:bsd-2)))
231
6fc03fcc
CB		 232(define-public ephemeralpg
233 (package
234 (name "ephemeralpg")
6c54d06e 235 (version "3.0")
6fc03fcc
CB		 236 (source
237 (origin
238 (method url-fetch)
239 (uri (string-append
8e716256 240 "https://eradman.com/ephemeralpg/code/ephemeralpg-"
6fc03fcc
CB		 241 version ".tar.gz"))
242 (sha256
6c54d06e 243 (base32 "1j0g7g114ma7y7sadbng5p1ss1zsm9zpicm77qspym6565733vvh"))))
6fc03fcc
CB		 244 (build-system gnu-build-system)
245 (arguments
246 '(#:make-flags (list "CC=gcc"
247 (string-append "PREFIX=" %output))
248 #:phases
249 (modify-phases %standard-phases
6c54d06e 250 (delete 'configure) ; no configure script
6fc03fcc
CB		 251 (add-after 'install 'wrap
252 (lambda* (#:key inputs outputs #:allow-other-keys)
253 (let ((out (assoc-ref outputs "out")))
254 (wrap-program (string-append out "/bin/pg_tmp")
255 `("PATH" ":" prefix
256 (,(string-append (assoc-ref inputs "util-linux")
257 "/bin")
258 ,(string-append (assoc-ref inputs "postgresql")
259 "/bin")
fa8343de 260 ;; For getsocket.
6fc03fcc 261 ,(string-append out "/bin")))))
6c54d06e
TGR		 262 #t)))
263 #:test-target "test"))
6fc03fcc
CB		 264 (inputs
265 `(("postgresql" ,postgresql)
266 ("util-linux" ,util-linux)))
267 (native-inputs
6c54d06e 268 ;; For tests.
fa8343de
TGR		 269 `(("ruby" ,ruby)
270 ("which" ,which)))
8e716256 271 (home-page "https://eradman.com/ephemeralpg/")
6fc03fcc
CB		 272 (synopsis "Run temporary PostgreSQL databases")
273 (description
274 "@code{pg_tmp} creates temporary PostgreSQL databases, suitable for tasks
275like running software test suites. Temporary databases created with
276@code{pg_tmp} have a limited shared memory footprint and are automatically
277garbage-collected after a configurable number of seconds (the default is
27860).")
279 (license license:isc)))
280
afcbb020
CB		 281(define-public es-dump-restore
282 (package
283 (name "es-dump-restore")
284 (version "2.1.0")
285 (source
286 (origin
287 (method url-fetch)
288 (uri (rubygems-uri "es_dump_restore" version))
289 (sha256
290 (base32
291 "020yk7f1hw48clmf5501z3xv9shsdchyymcv0y2cci2c1xvr1mim"))))
292 (build-system ruby-build-system)
293 (arguments
0076f5a9 294 '(#:tests? #f)) ;; No testsuite.
afcbb020
CB		 295 (propagated-inputs
296 `(("ruby-httpclient" ,ruby-httpclient)
297 ("ruby-multi-json" ,ruby-multi-json)
298 ("ruby-progress_bar" ,ruby-progress_bar)
299 ("ruby-rubyzip" ,ruby-rubyzip)
300 ("ruby-thor" ,ruby-thor)))
301 (synopsis "Utility for dumping and restoring ElasticSearch indexes")
302 (description
303 "This package provides a utility for dumping the contents of an
304ElasticSearch index to a compressed file and restoring the dumpfile back to an
305ElasticSearch server")
306 (home-page "https://github.com/patientslikeme/es_dump_restore")
307 (license license:expat)))
308
b9f771a7
MB		 309(define-public leveldb
310 (package
311 (name "leveldb")
3a32be71 312 (version "1.22")
b9f771a7 313 (source (origin
ad7c77fd
MB		 314 (method git-fetch)
315 (uri (git-reference
316 (url "https://github.com/google/leveldb")
5cc013f0 317 (commit version)))
ad7c77fd 318 (file-name (git-file-name name version))
b9f771a7
MB		 319 (sha256
320 (base32
3a32be71 321 "0qrnhiyq7r4wa1a4wi82zgns35smj94mcjsc7kfs1k6ia9ys79z7"))))
5cc013f0 322 (build-system cmake-build-system)
b9f771a7 323 (arguments
5cc013f0 324 `(#:configure-flags '("-DBUILD_SHARED_LIBS=ON" "-DLEVELDB_BUILD_TESTS=ON")))
b9f771a7
MB		 325 (inputs
326 `(("snappy" ,snappy)))
fd423e4d 327 (home-page "https://github.com/google/leveldb")
b9f771a7
MB		 328 (synopsis "Fast key-value storage library")
329 (description
330 "LevelDB is a fast key-value storage library that provides an ordered
331mapping from string keys to string values.")
ba8b9f8d 332 (license license:bsd-3)))
b9f771a7 333
686144e9
CB		 334(define-public memcached
335 (package
336 (name "memcached")
973218a3 337 (version "1.5.20")
686144e9
CB		 338 (source
339 (origin
340 (method url-fetch)
341 (uri (string-append
342 "https://memcached.org/files/memcached-" version ".tar.gz"))
343 (sha256
973218a3 344 (base32 "1r511qr95q0ywdaql3pdjiwzkfqxhhfzb13ilvl7mznfm4iv1myg"))))
686144e9
CB		 345 (build-system gnu-build-system)
346 (inputs
347 `(("libevent" ,libevent)
348 ("cyrus-sasl" ,cyrus-sasl)))
349 (home-page "https://memcached.org/")
61d996b9
TGR		 350 (synopsis "In-memory caching service")
351 (description "Memcached is an in-memory key-value store. It has a small
686144e9
CB		 352and generic API, and was originally intended for use with dynamic web
353applications.")
354 (license license:bsd-3)))
355
da602679
MC		 356(define-public libmemcached
357 (package
358 (name "libmemcached")
359 (version "1.0.18")
360 ;; We build from the sources since we want to build the extra HTML
361 ;; documentation which is not included with the release.
362 (source (origin
363 (method bzr-fetch)
364 (uri (bzr-reference
365 (url "lp:libmemcached/1.0")
366 (revision (string-append "tag:" version))))
367 (file-name (string-append name "-" version "-checkout"))
368 (sha256
369 (base32
737a3c12
TGR		 370 "1842s4dxdh21gdr46q4dgxigidcs6dkqnbnqjwb9l8r0bqx5nb10"))
371 (patches
372 (search-patches "libmemcached-build-with-gcc7.patch"))))
da602679
MC		 373 (build-system gnu-build-system)
374 (native-inputs
375 `(("memcached" ,memcached)
376 ("libtool" ,libtool)
377 ("autoconf" ,autoconf)
378 ("automake" ,automake)
379 ("bison" ,bison)
380 ("flex" ,flex)
381 ("perl" ,perl)
382 ("python-sphinx" ,python-sphinx))) ;to build the HTML doc.
383 (inputs
384 `(("libevent" ,libevent)
385 ("cyrus-sasl" ,cyrus-sasl)))
386 (outputs '("out" "doc"))
387 (arguments
388 '(#:phases
389 (modify-phases %standard-phases
390 (add-before 'bootstrap 'fix-configure.ac
391 ;; Move the AC_CONFIG_AUX_DIR macro use under AC_INIT, otherwise we
392 ;; get the error ``configure: error: cannot find install-sh,
393 ;; install.sh, or shtool in "." "./.." "./../.."`` (see:
394 ;; https://debbugs.gnu.org/cgi/bugreport.cgi?bug=19539 and
395 ;; https://bugs.launchpad.net/libmemcached/+bug/1803922).
396 (lambda _
397 (delete-file "bootstrap.sh") ;not useful in the context of Guix
398 (substitute* "configure.ac"
399 (("^AC_CONFIG_AUX_DIR\\(\\[build-aux\\]\\).*") "")
400 (("(^AC_INIT.*)" anchor)
401 (string-append anchor "AC_CONFIG_AUX_DIR([build-aux])\n")))
402 #t))
403 (add-before 'bootstrap 'disable-failing-tests
404 ;; See: https://bugs.launchpad.net/libmemcached/+bug/1803926
405 (lambda _
406 ;; Mark some heavily failing test suites as expected to fail.
407 (substitute* "Makefile.am"
408 (("(XFAIL_TESTS =[^\n]*)" xfail_tests)
409 (string-append xfail_tests " tests/testudp"
410 " tests/libmemcached-1.0/testapp"
411 " tests/libmemcached-1.0/testsocket")))
412 ;; Disable two tests of the unittest test suite.
413 (substitute* "libtest/unittest.cc"
414 ((".*echo_fubar_BINARY \\},.*") "")
415 ((".*application_doesnotexist_BINARY \\},.*") ""))
416 #t))
417 (add-after 'disable-dns-tests 'build-and-install-html-doc
418 (lambda* (#:key outputs #:allow-other-keys)
419 (let ((html (string-append (assoc-ref outputs "doc")
420 "/share/doc/libmemcached/html/")))
421 (invoke "make" "install-html")
422 ;; Cleanup useless files.
423 (for-each delete-file-recursively
424 (map (lambda (x) (string-append html x))
425 '("_sources" ".doctrees" ".buildinfo"))))
426 #t)))))
427 (home-page "https://libmemcached.org/")
428 (synopsis "C++ library for memcached")
429 (description "libMemcached is a library to use memcached in C/C++
430applications. It comes with a complete reference guide and documentation of
431the API, and provides features such as:
432@itemize
433@item Asynchronous and synchronous transport support
434@item Consistent hashing and distribution
435@item Tunable hashing algorithm to match keys
436@item Access to large object support
437@item Local replication
438@end itemize")
439 (license license:bsd-3)))
440
063edf92
MC		 441(define-public python-pylibmc
442 (package
443 (name "python-pylibmc")
79bc9176 444 (version "1.6.1")
063edf92
MC		 445 (source
446 (origin
447 (method url-fetch)
448 (uri (pypi-uri "pylibmc" version))
449 (sha256
79bc9176 450 (base32 "1sg7d9j0v6g3xg3finf4l1hb72c13vcyyi6rqrc9shbx903d93ca"))))
063edf92
MC		 451 (build-system python-build-system)
452 (arguments
453 '(#:phases
454 (modify-phases %standard-phases
455 (add-before 'check 'start-memcached-daemon
456 ;; The test suite requires a memcached server.
457 (lambda _
458 (invoke "memcached" "-d"))))))
459 (native-inputs
460 `(("memcached" ,memcached)
461 ("python-nose" ,python-nose)))
462 (inputs
463 `(("libmemcached" ,libmemcached)
464 ("zlib" ,zlib)
465 ("cyrus-sasl" ,cyrus-sasl)))
79bc9176
TGR		 466 (home-page "http://sendapatch.se/projects/pylibmc/")
467 (synopsis "Python client for memcached")
063edf92
MC		 468 (description
469 "@code{pylibmc} is a client in Python for memcached. It is a wrapper
470around TangentOrg’s libmemcached library, and can be used as a drop-in
471replacement for the code@{python-memcached} library.")
472 (license license:bsd-3)))
473
474(define-public python2-pylibmc
475 (package-with-python2 python-pylibmc))
476
6bbbca90
CB		 477(define-public mongodb
478 (package
479 (name "mongodb")
f1c49e75 480 (version "3.4.10")
6bbbca90
CB		 481 (source (origin
482 (method url-fetch)
483 (uri (string-append "https://github.com/mongodb/mongo/archive/r"
484 version ".tar.gz"))
485 (file-name (string-append name "-" version ".tar.gz"))
486 (sha256
f1c49e75 487 (base32 "0676lvkljj7a5hdhv78dbykqnqrj9lbn9799mi84b8vbnzsq961r"))
51b0f09e
EF		 488 (modules '((guix build utils)))
489 (snippet
490 '(begin
491 (for-each (lambda (dir)
492 (delete-file-recursively
493 (string-append "src/third_party/" dir)))
494 '("pcre-8.41" "scons-2.5.0" "snappy-1.1.3"
495 "valgrind-3.11.0" "wiredtiger"
6cbee49d
MW		 496 "yaml-cpp-0.5.3" "zlib-1.2.8"))
497 #t))
6bbbca90
CB		 498 (patches
499 (list
500 (search-patch "mongodb-support-unknown-linux-distributions.patch")))))
6e385b76 501 (build-system scons-build-system)
6bbbca90 502 (inputs
9d67480a 503 `(("openssl" ,openssl-1.0)
6bbbca90 504 ("pcre" ,pcre)
319b52c3
EF		 505 ,@(match (%current-system)
506 ((or "x86_64-linux" "aarch64-linux" "mips64el-linux")
507 `(("wiredtiger" ,wiredtiger)))
508 (_ `()))
6bbbca90
CB		 509 ("yaml-cpp" ,yaml-cpp)
510 ("zlib" ,zlib)
51b0f09e 511 ("snappy" ,snappy)))
6bbbca90 512 (native-inputs
6e385b76 513 `(("valgrind" ,valgrind)
90205b62 514 ("perl" ,perl)
61506fe5 515 ("python" ,python-2)
90205b62
CB		 516 ("python2-pymongo" ,python2-pymongo)
517 ("python2-pyyaml" ,python2-pyyaml)
5a8ef3c1 518 ("tzdata" ,tzdata-for-tests)))
6bbbca90 519 (arguments
6e385b76
AI		 520 `(#:scons ,scons-python2
521 #:phases
6bbbca90
CB		 522 (let ((common-options
523 `(;; "--use-system-tcmalloc" TODO: Missing gperftools
524 "--use-system-pcre"
29cfbfca
EF		 525 ;; wiredtiger is 64-bit only
526 ,,(if (any (cute string-prefix? <> (or (%current-target-system)
527 (%current-system)))
528 '("i686-linux" "armhf-linux"))
529 ``"--wiredtiger=off"
319b52c3 530 ``"--use-system-wiredtiger")
6bbbca90
CB		 531 ;; TODO
532 ;; build/opt/mongo/db/fts/unicode/string.o failed: Error 1
533 ;; --use-system-boost
534 "--use-system-snappy"
535 "--use-system-zlib"
536 "--use-system-valgrind"
537 ;; "--use-system-stemmer" TODO: Missing relevant package
538 "--use-system-yaml"
539 "--disable-warnings-as-errors"
540 ,(format #f "--jobs=~a" (parallel-job-count))
541 "--ssl")))
542 (modify-phases %standard-phases
9d67480a
CB		 543 (add-after 'unpack 'patch
544 (lambda _
545 ;; Remove use of GNU extensions in parse_number_test.cpp, to
546 ;; allow compiling with GCC 7 or later
547 ;; https://jira.mongodb.org/browse/SERVER-28063
548 (substitute* "src/mongo/base/parse_number_test.cpp"
549 (("0xabcab\\.defdefP-10")
550 "687.16784283419838"))
551 #t))
6bbbca90
CB		 552 (add-after 'unpack 'scons-propagate-environment
553 (lambda _
554 ;; Modify the SConstruct file to arrange for
555 ;; environment variables to be propagated.
556 (substitute* "SConstruct"
557 (("^env = Environment\\(")
558 "env = Environment(ENV=os.environ, "))
559 #t))
560 (add-after 'unpack 'create-version-file
561 (lambda _
562 (call-with-output-file "version.json"
563 (lambda (port)
564 (display ,(simple-format #f "{
565 \"version\": \"~A\"
566}" version) port)))
567 #t))
568 (replace 'build
569 (lambda _
d9bcdfce 570 (apply invoke `("scons"
6bbbca90 571 ,@common-options
d9bcdfce 572 "mongod" "mongo" "mongos"))))
6bbbca90 573 (replace 'check
90205b62
CB		 574 (lambda* (#:key tests? inputs #:allow-other-keys)
575 (setenv "TZDIR"
576 (string-append (assoc-ref inputs "tzdata")
577 "/share/zoneinfo"))
96272e28
MW		 578 (when tests?
579 ;; Note that with the tests, especially the unittests, the
580 ;; build can take up to ~45GB of space, as many tests are
581 ;; individual executable files, with some being hundreds of
582 ;; megabytes in size.
583 (apply invoke `("scons" ,@common-options "dbtest" "unittests"))
584 (substitute* "build/unittests.txt"
585 ;; TODO: Don't run the async_stream_test, as it hangs
586 (("^build\\/opt\\/mongo\\/executor\\/async\\_stream\\_test\n$")
587 "")
588 ;; TODO: This test fails
589 ;; Expected 0UL != disks.size() (0 != 0) @src/mongo/util/procparser_test.cpp:476
590 (("^build\\/opt\\/mongo\\/util\\/procparser\\_test\n$")
591 ""))
592 (invoke "python" "buildscripts/resmoke.py"
593 "--suites=dbtest,unittests"
594 (format #f "--jobs=~a" (parallel-job-count))))
595 #t))
6bbbca90 596 (replace 'install
96272e28
MW		 597 (lambda* (#:key outputs #:allow-other-keys)
598 (let ((bin (string-append (assoc-ref outputs "out") "/bin")))
6bbbca90
CB		 599 (install-file "mongod" bin)
600 (install-file "mongos" bin)
601 (install-file "mongo" bin))
602 #t))))))
603 (home-page "https://www.mongodb.org/")
604 (synopsis "High performance and high availability document database")
605 (description
606 "Mongo is a high-performance, high availability, schema-free
607document-oriented database. A key goal of MongoDB is to bridge the gap
608between key/value stores (which are fast and highly scalable) and traditional
609RDBMS systems (which are deep in functionality).")
610 (license (list license:agpl3
611 ;; Some parts are licensed under the Apache License
612 license:asl2.0))))
613
8de54c63 614(define-public mycli
615 (package
616 (name "mycli")
ce13a54a 617 (version "1.22.2")
8de54c63 618 (source
619 (origin
620 (method url-fetch)
621 (uri (pypi-uri "mycli" version))
622 (sha256
ce13a54a 623 (base32 "1lq2x95553vdmhw13cxcgsd2g2i32izhsb7hxd4m1iwf9b3msbpv"))))
8de54c63 624 (build-system python-build-system)
625 (arguments
626 `(#:tests? #f)) ; tests expect a running MySQL
627 (propagated-inputs
628 `(("python-cli-helpers" ,python-cli-helpers)
629 ("python-click" ,python-click)
630 ("python-configobj" ,python-configobj)
631 ("python-cryptography" ,python-cryptography)
632 ("python-prompt-toolkit" ,python-prompt-toolkit)
633 ("python-pygments" ,python-pygments)
634 ("python-pymysql" ,python-pymysql)
635 ("python-sqlparse" ,python-sqlparse)))
636 (home-page "http://mycli.net")
637 (synopsis
638 "Terminal Client for MySQL with AutoCompletion and Syntax Highlighting")
639 (description
640 "MyCLI is a command line interface for MySQL, MariaDB, and Percona with
641auto-completion and syntax highlighting.")
642 (license license:bsd-3)))
643
7cbf06d8
TGR		 644;; XXX When updating, check whether boost-for-mysql is still needed.
645;; It might suffice to patch ‘cmake/boost.cmake’ as done in the past.
5f96f303
LC		 646(define-public mysql
647 (package
648 (name "mysql")
aace6f6d 649 (version "5.7.27")
5f96f303
LC		 650 (source (origin
651 (method url-fetch)
23bbd7dd 652 (uri (list (string-append
7fe3a57a 653 "https://dev.mysql.com/get/Downloads/MySQL-"
23bbd7dd
EF		 654 (version-major+minor version) "/"
655 name "-" version ".tar.gz")
656 (string-append
7fe3a57a 657 "https://downloads.mysql.com/archives/get/file/"
23bbd7dd 658 name "-" version ".tar.gz")))
5f96f303
LC		 659 (sha256
660 (base32
aace6f6d 661 "1fhv16zr46pxm1j8vb8x8mh3nwzglg01arz8gnazbmjqldr5idpq"))))
329d13b8
SB		 662 (build-system cmake-build-system)
663 (arguments
69419655 664 `(#:configure-flags
329d13b8
SB		 665 '("-DBUILD_CONFIG=mysql_release"
666 "-DWITH_SSL=system"
667 "-DWITH_ZLIB=system"
668 "-DDEFAULT_CHARSET=utf8"
669 "-DDEFAULT_COLLATION=utf8_general_ci"
670 "-DMYSQL_DATADIR=/var/lib/mysql"
671 "-DMYSQL_UNIX_ADDR=/run/mysqld/mysqld.sock"
672 "-DINSTALL_INFODIR=share/mysql/docs"
673 "-DINSTALL_MANDIR=share/man"
674 "-DINSTALL_PLUGINDIR=lib/mysql/plugin"
675 "-DINSTALL_SCRIPTDIR=bin"
676 "-DINSTALL_INCLUDEDIR=include/mysql"
677 "-DINSTALL_DOCREADMEDIR=share/mysql/docs"
678 "-DINSTALL_SUPPORTFILESDIR=share/mysql"
679 "-DINSTALL_MYSQLSHAREDIR=share/mysql"
680 "-DINSTALL_DOCDIR=share/mysql/docs"
681 "-DINSTALL_SHAREDIR=share/mysql"
682 ;; Get rid of test data.
683 "-DINSTALL_MYSQLTESTDIR="
3f289db6
LC		 684 "-DINSTALL_SQLBENCHDIR=")
685 #:phases (modify-phases %standard-phases
6a52df50
LC		 686 (add-after
687 'install 'remove-extra-binaries
688 (lambda* (#:key outputs #:allow-other-keys)
689 (let ((out (assoc-ref outputs "out")))
690 ;; Remove the 3 *_embedded files, which weigh in at
691 ;; 14 MiB each.
692 (for-each delete-file
693 (find-files (string-append out "/bin")
694 "_embedded$"))
7d099cbe 695 #t))))))
329d13b8
SB		 696 (native-inputs
697 `(("bison" ,bison)
aace6f6d
EF		 698 ("perl" ,perl)
699 ("pkg-config" ,pkg-config)))
5f96f303 700 (inputs
7cbf06d8 701 `(("boost" ,boost-for-mysql)
23bbd7dd 702 ("libaio" ,libaio)
aace6f6d 703 ("libtirpc" ,libtirpc)
23bbd7dd 704 ("ncurses" ,ncurses)
5f96f303 705 ("openssl" ,openssl)
aace6f6d 706 ("rpcsvc-proto" ,rpcsvc-proto) ; rpcgen
23bbd7dd 707 ("zlib" ,zlib)))
7fe3a57a 708 (home-page "https://www.mysql.com/")
9e771e3b 709 (synopsis "Fast, easy to use, and popular database")
5f96f303
LC		 710 (description
711 "MySQL is a fast, reliable, and easy to use relational database
712management system that supports the standardized Structured Query
713Language.")
ba8b9f8d 714 (license license:gpl2)))
5f96f303 715
77631745
SB		 716(define-public mariadb
717 (package
718 (name "mariadb")
e24e345c 719 (version "10.1.45")
77631745
SB		 720 (source (origin
721 (method url-fetch)
cc3c5fc5
MB		 722 (uri (string-append "https://downloads.mariadb.com/MariaDB"
723 "/mariadb-" version "/source/mariadb-"
724 version ".tar.gz"))
77631745
SB		 725 (sha256
726 (base32
e24e345c 727 "1mfs0x4c0z7d306n128dxdawk3llk25vxif5zwl20fv1z5qhz3wx"))
fb76ef84 728 (patches (search-patches "mariadb-client-test-32bit.patch"))
2001d2da
MB		 729 (modules '((guix build utils)))
730 (snippet
731 '(begin
732 ;; Delete bundled snappy and xz.
733 (delete-file-recursively "storage/tokudb/PerconaFT/third_party")
4333d48a
MB		 734 (substitute* "storage/tokudb/PerconaFT/CMakeLists.txt"
735 ;; This file checks that the bundled sources are present and
736 ;; declares build procedures for them.
737 (("^include\\(TokuThirdParty\\)") ""))
738 (substitute* "storage/tokudb/PerconaFT/ft/CMakeLists.txt"
739 ;; Don't attempt to use the procedures we just removed.
740 ((" build_lzma build_snappy") ""))
2001d2da
MB		 741
742 ;; Preserve CMakeLists.txt for these.
743 (for-each (lambda (file)
744 (unless (string-suffix? "CMakeLists.txt" file)
745 (delete-file file)))
746 (append (find-files "extra/yassl")
747 (find-files "pcre") (find-files "zlib")))
748 #t))))
77631745 749 (build-system cmake-build-system)
2b8491fb 750 (outputs '("out" "lib" "dev"))
77631745 751 (arguments
5193ae64 752 `(#:configure-flags
2b8491fb
JL		 753 (list
754 "-DBUILD_CONFIG=mysql_release"
6cf8e576
LF		 755 ;; Linking with libarchive fails, like this:
756
757 ;; ld: /gnu/store/...-libarchive-3.2.2/lib/libarchive.a(archive_entry.o):
758 ;; relocation R_X86_64_32 against `.bss' can not be used when
759 ;; making a shared object; recompile with -fPIC
760
761 ;; For now, disable the features that that use libarchive (xtrabackup).
762 "-DWITH_LIBARCHIVE=OFF"
763
bba7a77e
MB		 764 ;; Disable the TokuDB engine, because its test suite frequently fails,
765 ;; and loading it crashes the server: <https://bugs.gnu.org/35521>.
766 "-DTOKUDB_OK=OFF"
767
2001d2da
MB		 768 ;; Ensure the system libraries are used.
769 "-DWITH_JEMALLOC=yes"
770 "-DWITH_PCRE=system"
771 "-DWITH_SSL=system"
772 "-DWITH_ZLIB=system"
773
77631745
SB		 774 "-DDEFAULT_CHARSET=utf8"
775 "-DDEFAULT_COLLATION=utf8_general_ci"
776 "-DMYSQL_DATADIR=/var/lib/mysql"
777 "-DMYSQL_UNIX_ADDR=/run/mysqld/mysqld.sock"
2b8491fb
JL		 778 (string-append "-DCMAKE_INSTALL_PREFIX=" (assoc-ref %outputs "lib"))
779 (string-append "-DCMAKE_INSTALL_RPATH=" (assoc-ref %outputs "lib")
780 "/lib")
781 (string-append "-DINSTALL_INFODIR=" (assoc-ref %outputs "out")
782 "/share/mysql/docs")
783 (string-append "-DINSTALL_MANDIR=" (assoc-ref %outputs "out")
784 "/share/man")
785 (string-append "-DINSTALL_SCRIPTDIR=" (assoc-ref %outputs "out") "/bin")
786 (string-append "-DINSTALL_BINDIR=" (assoc-ref %outputs "out") "/bin")
787 "-DCMAKE_INSTALL_LIBDIR=lib"
77631745 788 "-DINSTALL_PLUGINDIR=lib/mysql/plugin"
2b8491fb
JL		 789 (string-append "-DINSTALL_INCLUDEDIR=" (assoc-ref %outputs "dev")
790 "/include/mysql")
791 (string-append "-DINSTALL_DOCREADMEDIR=" (assoc-ref %outputs "out")
792 "/share/mysql/docs")
793 (string-append "-DINSTALL_DOCDIR=" (assoc-ref %outputs "out")
794 "/share/mysql/docs")
795 (string-append "-DINSTALL_SUPPORTFILESDIR=" (assoc-ref %outputs "out")
796 "/share/mysql/support-files")
77631745 797 "-DINSTALL_MYSQLSHAREDIR=share/mysql"
4c27ea06 798 "-DINSTALL_SHAREDIR=share")
77631745
SB		 799 #:phases
800 (modify-phases %standard-phases
b859a1bf
MB		 801 ,@(if (string-prefix? "arm" (%current-system))
802 ;; XXX: Because of the GCC 5 input, we need to hide GCC 7 from
803 ;; CPLUS_INCLUDE_PATH so that its headers do not shadow GCC 5.
804 '((add-after 'set-paths 'hide-default-gcc
805 (lambda* (#:key inputs #:allow-other-keys)
806 (let ((gcc (assoc-ref inputs "gcc")))
807 (setenv "CPLUS_INCLUDE_PATH"
808 (string-join
809 (delete (string-append gcc "/include/c++")
810 (string-split (getenv "CPLUS_INCLUDE_PATH")
811 #\:))
812 ":"))
813 #t))))
814 '())
4333d48a 815 (add-after 'unpack 'fix-pcre-detection
2001d2da
MB		 816 (lambda _
817 ;; The bundled PCRE in MariaDB has a patch that was upstreamed
818 ;; in version 8.34. Unfortunately the upstream patch behaves
819 ;; slightly differently and the build system fails to detect it.
820 ;; See <https://bugs.exim.org/show_bug.cgi?id=2173>.
821 ;; XXX: Consider patching PCRE instead.
822 (substitute* "cmake/pcre.cmake"
823 ((" OR NOT PCRE_STACK_SIZE_OK") ""))
2001d2da 824 #t))
3869f39e
MB		 825 (add-after 'unpack 'adjust-tests
826 (lambda _
827 (let ((disabled-tests
828 '(;; These fail because root@hostname == root@localhost in
829 ;; the build environment, causing a user count mismatch.
830 ;; See <https://jira.mariadb.org/browse/MDEV-7761>.
831 "main.join_cache"
832 "main.explain_non_select"
e313327e 833 "main.stat_tables"
1d957c79 834 "main.stat_tables_innodb"
3418e43b 835 "roles.acl_statistics"
69fb26d4
MB		 836
837 ;; This file contains a time bomb which makes it fail after
0ce64334 838 ;; 2030-12-31. See <https://bugs.gnu.org/34351> for details.
38f77be4 839 "main.mysqldump"
69fb26d4 840
3418e43b
MB		 841 ;; FIXME: This test fails on i686:
842 ;; -myisampack: Can't create/write to file (Errcode: 17 "File exists")
843 ;; +myisampack: Can't create/write to file (Errcode: 17 "File exists)
844 ;; When running "myisampack --join=foo/t3 foo/t1 foo/t2"
845 ;; (all three tables must exist and be identical)
846 ;; in a loop it produces the same error around 1/240 times.
847 ;; montywi on #maria suggested removing the real_end check in
848 ;; "strings/my_vsnprintf.c" on line 503, yet it still does not
849 ;; reach the ending quote occasionally. Disable it for now.
62694caa
EF		 850 "main.myisampack"
851 ;; FIXME: This test fails on armhf-linux:
852 "mroonga/storage.index_read_multiple_double"))
3869f39e
MB		 853
854 ;; This file contains a list of known-flaky tests for this
855 ;; release. Append our own items.
856 (unstable-tests (open-file "mysql-test/unstable-tests" "a")))
857 (for-each (lambda (test)
858 (format unstable-tests "~a : ~a\n"
859 test "Disabled in Guix"))
860 disabled-tests)
861 (close-port unstable-tests)
862
ab0cb26f
MB		 863 ;; XXX: This test fails because it expects a latin1 charset and
864 ;; collation. See <https://jira.mariadb.org/browse/MDEV-21264>.
865 (substitute* "mysql-test/r/gis_notembedded.result"
866 (("latin1_swedish_ci") "utf8_general_ci")
867 (("\tlatin1") "\tutf8"))
868
e313327e
MB		 869 (substitute* "mysql-test/suite/binlog/t/binlog_mysqlbinlog_stop_never.test"
870 (("/bin/bash")
871 (which "bash")))
872
3869f39e
MB		 873 (substitute* "mysql-test/mysql-test-run.pl"
874 (("/bin/ls") (which "ls"))
875 (("/bin/sh") (which "sh")))
876 #t)))
5b4d2e40
MB		 877 (add-before 'configure 'disable-plugins
878 (lambda _
879 (let ((disable-plugin (lambda (name)
880 (call-with-output-file
881 (string-append "plugin/" name
882 "/CMakeLists.txt")
883 (lambda (port)
884 (format port "\n")))))
03335824 885 (disabled-plugins '(;; XXX: Causes a test failure.
3869f39e 886 "disks")))
5b4d2e40
MB		 887 (for-each disable-plugin disabled-plugins)
888 #t)))
3869f39e
MB		 889 (replace 'check
890 (lambda* (#:key (tests? #t) #:allow-other-keys)
891 (if tests?
892 (with-directory-excursion "mysql-test"
893 (invoke "./mtr" "--verbose"
3418e43b 894 "--retry=3"
71179b35
MB		 895 "--testcase-timeout=40"
896 "--suite-timeout=600"
3869f39e
MB		 897 "--parallel" (number->string (parallel-job-count))
898 "--skip-test-list=unstable-tests"))
899 (format #t "test suite not run~%"))
900 #t))
77631745
SB		 901 (add-after
902 'install 'post-install
939c5b2c 903 (lambda* (#:key inputs outputs #:allow-other-keys)
77631745 904 (let* ((out (assoc-ref outputs "out"))
2b8491fb 905 (dev (assoc-ref outputs "dev"))
939c5b2c
MB		 906 (lib (assoc-ref outputs "lib"))
907 (openssl (assoc-ref inputs "openssl")))
77631745
SB		 908 (substitute* (string-append out "/bin/mysql_install_db")
909 (("basedir=\"\"")
910 (string-append "basedir=\"" out "\"")))
911 ;; Remove unneeded files for testing.
2b8491fb 912 (with-directory-excursion lib
77631745 913 (for-each delete-file-recursively
2b8491fb 914 '("data" "mysql-test" "sql-bench"))
963157f1
MB		 915 ;; And static libraries.
916 (for-each delete-file (find-files "lib" "\\.a$")))
2b8491fb
JL		 917 (with-directory-excursion out
918 (delete-file "share/man/man1/mysql-test-run.pl.1")
919 ;; Delete huge and unnecessary executables.
920 (for-each delete-file (find-files "bin" "(test|embedded)")))
921 (mkdir-p (string-append dev "/share"))
922 (mkdir-p (string-append dev "/bin"))
923 (rename-file (string-append lib "/bin/mysqld")
924 (string-append out "/bin/mysqld"))
925 (rename-file (string-append lib "/share/pkgconfig")
926 (string-append dev "/share/pkgconfig"))
927 (rename-file (string-append out "/bin/mysql_config")
928 (string-append dev "/bin/mysql_config"))
939c5b2c 929
ca69163c
MB		 930
931 (substitute* (string-append out "/bin/mysql_install_db")
932 (("\\$basedir/share/mysql")
933 (string-append lib "/share/mysql")))
934
939c5b2c
MB		 935 ;; Embed an absolute reference to OpenSSL in mysql_config
936 ;; and the pkg-config file to avoid propagation.
937 (substitute* (list (string-append dev "/bin/mysql_config")
938 (string-append dev "/share/pkgconfig/mariadb.pc"))
939 (("-lssl -lcrypto" all)
940 (string-append "-L" openssl "/lib " all)))
941
841ee2a8 942 #t))))))
77631745
SB		 943 (native-inputs
944 `(("bison" ,bison)
2fa55c72
MB		 945 ;; XXX: On armhf, use GCC 5 to work around <https://bugs.gnu.org/37605>.
946 ,@(if (string-prefix? "armhf" (%current-system))
b859a1bf 947 `(("gcc@5", gcc-5))
2fa55c72 948 '())
03335824 949 ("perl" ,perl)))
77631745
SB		 950 (inputs
951 `(("jemalloc" ,jemalloc)
952 ("libaio" ,libaio)
953 ("libxml2" ,libxml2)
954 ("ncurses" ,ncurses)
939c5b2c 955 ("openssl" ,openssl-1.0)
ab0cb26f 956 ("pam" ,linux-pam)
77631745 957 ("pcre" ,pcre)
2001d2da 958 ("xz" ,xz)
77631745 959 ("zlib" ,zlib)))
3869f39e
MB		 960 ;; The test suite is very resource intensive and can take more than three
961 ;; hours on a x86_64 system. Give slow and busy machines some leeway.
962 (properties '((timeout . 64800))) ;18 hours
77631745
SB		 963 (home-page "https://mariadb.org/")
964 (synopsis "SQL database server")
965 (description
966 "MariaDB is a multi-user and multi-threaded SQL database server, designed
967as a drop-in replacement of MySQL.")
ba8b9f8d 968 (license license:gpl2)))
77631745 969
2072bc08
PN		 970(define-public mariadb-connector-c
971 (package
972 (name "mariadb-connector-c")
809a3f72 973 (version "3.1.9")
2072bc08
PN		 974 (source (origin
975 (method url-fetch)
976 (uri (string-append
977 "https://downloads.mariadb.org/f/connector-c-"
978 version "/mariadb-connector-c-"
979 version "-src.tar.gz"))
980 (sha256
981 (base32
809a3f72 982 "1izjzf7yzjqzlk8dkp327fa9lawsv2hnnlnr7g5lshyx5azrk38h"))))
9077cf68 983 (inputs
2072bc08
PN		 984 `(("openssl" ,openssl)))
985 (build-system cmake-build-system)
9077cf68 986 (arguments
87078871 987 '(#:tests? #f)) ; no tests
2072bc08
PN		 988 (home-page "https://mariadb.com/kb/en/mariadb-connector-c/")
989 (synopsis "Client library to connect to MySQL or MariaDB")
990 (description "The MariaDB Connector/C is used to connect applications
991developed in C/C++ to MariaDB and MySQL databases.")
992 (license license:lgpl2.1+)))
9077cf68 993
97dd1b15 994;; Don't forget to update the other postgresql packages when upgrading this one.
5f96f303
LC		 995(define-public postgresql
996 (package
997 (name "postgresql")
4cff2303 998 (version "10.13")
5f96f303
LC		 999 (source (origin
1000 (method url-fetch)
dbeaf8f2 1001 (uri (string-append "https://ftp.postgresql.org/pub/source/v"
9020890b 1002 version "/postgresql-" version ".tar.bz2"))
5f96f303
LC		 1003 (sha256
1004 (base32
4cff2303 1005 "1qal0yp7a90yzya7hl56gsmw5fvacplrdhpn7h9gnbyr1i2iyw2d"))
c336567d 1006 (patches (search-patches "postgresql-disable-resolve_symlinks.patch"))))
5f96f303 1007 (build-system gnu-build-system)
dd213082 1008 (arguments
8b7e6d00 1009 `(#:configure-flags '("--with-uuid=e2fs" "--with-openssl")
b7aa3f5d 1010 #:phases
dd213082
JD		 1011 (modify-phases %standard-phases
1012 (add-before 'configure 'patch-/bin/sh
1013 (lambda _
1014 ;; Refer to the actual shell.
1015 (substitute* '("src/bin/pg_ctl/pg_ctl.c"
1016 "src/bin/psql/command.c")
1017 (("/bin/sh") (which "sh")))
b7aa3f5d
DM		 1018 #t))
1019 (add-after 'build 'build-contrib
1020 (lambda _
1fbad3ad 1021 (invoke "make" "-C" "contrib")))
b7aa3f5d
DM		 1022 (add-after 'install 'install-contrib
1023 (lambda _
1fbad3ad 1024 (invoke "make" "-C" "contrib" "install"))))))
5f96f303
LC		 1025 (inputs
1026 `(("readline" ,readline)
bb93042c 1027 ("libuuid" ,util-linux "lib")
8b7e6d00 1028 ("openssl" ,openssl)
5f96f303 1029 ("zlib" ,zlib)))
d887f420 1030 (home-page "https://www.postgresql.org/")
5f96f303
LC		 1031 (synopsis "Powerful object-relational database system")
1032 (description
1033 "PostgreSQL is a powerful object-relational database system. It is fully
1034ACID compliant, has full support for foreign keys, joins, views, triggers, and
1035stored procedures (in multiple languages). It includes most SQL:2008 data
1036types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and
1037TIMESTAMP. It also supports storage of binary large objects, including
1038pictures, sounds, or video.")
ba8b9f8d 1039 (license (license:x11-style "file://COPYRIGHT"))))
5f96f303 1040
91477def
GB		 1041(define-public postgresql-11
1042 (package
1043 (inherit postgresql)
1044 (name "postgresql")
9d192665 1045 (version "11.6")
91477def
GB		 1046 (source (origin
1047 (method url-fetch)
1048 (uri (string-append "https://ftp.postgresql.org/pub/source/v"
1049 version "/postgresql-" version ".tar.bz2"))
1050 (sha256
1051 (base32
9d192665 1052 "0w1iq488kpzfgfnlw4k32lz5by695mpnkq461jrgsr99z5zlz4j9"))))))
91477def 1053
7658d89b
EF		 1054(define-public postgresql-9.6
1055 (package
1056 (inherit postgresql)
1057 (name "postgresql")
901c9930 1058 (version "9.6.16")
7658d89b
EF		 1059 (source (origin
1060 (method url-fetch)
1061 (uri (string-append "https://ftp.postgresql.org/pub/source/v"
1062 version "/postgresql-" version ".tar.bz2"))
1063 (sha256
1064 (base32
901c9930 1065 "1rr2dgv4ams8r2lp13w85c77rkmzpb88fjlc28mvlw6zq2fblv2w"))))))
7658d89b 1066
9763102b
TGR		 1067(define-public python-pymysql
1068 (package
1069 (name "python-pymysql")
4cb2f29e 1070 (version "0.9.3")
9763102b
TGR		 1071 (source
1072 (origin
1073 (method url-fetch)
1074 (uri (pypi-uri "PyMySQL" version))
1075 (sha256
4cb2f29e 1076 (base32 "1ry8lxgdc1p3k7gbw20r405jqi5lvhi5wk83kxdbiv8xv3f5kh6q"))))
9763102b
TGR		 1077 (build-system python-build-system)
1078 (native-inputs
1079 `(("python-unittest2" ,python-unittest2)))
1080 (inputs
1081 `(("python-cryptography" ,python-cryptography)))
1082 (arguments
1083 `(#:tests? #f)) ; tests expect a running MySQL
1084 (home-page "https://github.com/PyMySQL/PyMySQL/")
1085 (synopsis "Pure-Python MySQL driver")
1086 (description
1087 "PyMySQL is a pure-Python MySQL client library, based on PEP 249.
1088Most public APIs are compatible with @command{mysqlclient} and MySQLdb.")
1089 (license license:expat)))
1090
1091(define-public python2-pymysql
1092 (package-with-python2 python-pymysql))
1093
259a94e9
TD		 1094(define-public qdbm
1095 (package
1096 (name "qdbm")
1097 (version "1.8.78")
1098 (source
1099 (origin
1100 (method url-fetch)
1101 (uri (string-append "http://fallabs.com/" name "/"
1102 name "-" version ".tar.gz"))
1103 (sha256
1104 (base32
1105 "0gmpvhn02pkq280ffmn4da1g4mdr1xxz7l80b7y4n7km1mrzwrml"))))
1106 (build-system gnu-build-system)
1107 (arguments
7dc0f1d5
TD		 1108 `(#:configure-flags (list (string-append "LDFLAGS=-Wl,-rpath="
1109 (assoc-ref %outputs "out")
1110 "/lib"))
1111 #:make-flags (list "CFLAGS=-fPIC")))
d74647b0 1112 (home-page "https://fallabs.com/qdbm/")
259a94e9
TD		 1113 (synopsis "Key-value database")
1114 (description "QDBM is a library of routines for managing a
1115database. The database is a simple data file containing key-value
1116pairs. Every key and value is serial bytes with variable length.
1117Binary data as well as character strings can be used as a key or a
1118value. There is no concept of data tables or data types. Records are
1119organized in a hash table or B+ tree.")
1120 (license license:lgpl2.1+)))
1121
5f96f303
LC		 1122(define-public recutils
1123 (package
1124 (name "recutils")
c007e35d 1125 (version "1.8")
5f96f303
LC		 1126 (source (origin
1127 (method url-fetch)
1128 (uri (string-append "mirror://gnu/recutils/recutils-"
1129 version ".tar.gz"))
1130 (sha256
1131 (base32
c007e35d 1132 "14xiln4immfsw8isnvwvq0h23f6z0wilpgsc4qzabnrzb5lsx3nz"))))
5f96f303
LC		 1133 (build-system gnu-build-system)
1134
c007e35d 1135 (arguments '(#:configure-flags
b747a9db
LF		 1136 (list (string-append "--with-bash-headers="
1137 (assoc-ref %build-inputs "bash:include")
c007e35d 1138 "/include/bash"))))
5f96f303 1139
535a69e9 1140 (native-inputs `(("bc" ,bc)
b747a9db 1141 ("bash:include" ,bash "include")
c007e35d
EF		 1142 ("check" ,check)
1143 ("libuuid" ,util-linux)
1144 ("pkg-config" ,pkg-config)))
5f96f303
LC		 1145
1146 ;; TODO: Add more optional inputs.
5f96f303 1147 (inputs `(("curl" ,curl)
c007e35d 1148 ("libgcrypt" ,libgcrypt)))
5f96f303
LC		 1149 (synopsis "Manipulate plain text files as databases")
1150 (description
1151 "GNU Recutils is a set of tools and libraries for creating and
1152manipulating text-based, human-editable databases. Despite being text-based,
1153databases created with Recutils carry all of the expected features such as
c5779c93
LC		 1154unique fields, primary keys, time stamps and more. Many different field
1155types are supported, as is encryption.")
ba8b9f8d 1156 (license license:gpl3+)
6fd52309 1157 (home-page "https://www.gnu.org/software/recutils/")))
5f96f303 1158
9df78675
JH		 1159(define-public emacs-recutils
1160 (package
1161 (inherit recutils)
1162 (name "emacs-recutils")
1163 (build-system emacs-build-system)
1164 (arguments
1165 '(#:phases
1166 (modify-phases %standard-phases
1167 (add-after 'unpack 'change-directory
1168 (lambda _
1169 (chdir "etc")
1170 #t)))))
1171 (native-inputs '())
1172 (inputs '())
1173 (synopsis "Emacs mode for working with recutils database files")
1174 (description "This package provides an Emacs major mode @code{rec-mode}
1175for working with GNU Recutils text-based, human-editable databases. It
1176supports editing, navigation, and querying of recutils database files
1177including field and record folding.")))
1178
d3c6ad0a
MB		 1179(define-public rocksdb
1180 (package
1181 (name "rocksdb")
6a0f9c87 1182 (version "6.11.4")
d3c6ad0a 1183 (source (origin
8dd36658
MB		 1184 (method git-fetch)
1185 (uri (git-reference
1186 (url "https://github.com/facebook/rocksdb")
1187 (commit (string-append "v" version))))
1188 (file-name (git-file-name name version))
d3c6ad0a
MB		 1189 (sha256
1190 (base32
6a0f9c87 1191 "0n19p9cd13jg0lnibrzwkxs4xlrhyj3knypkd2ic41arbds0bdnl"))
d3c6ad0a
MB		 1192 (modules '((guix build utils)))
1193 (snippet
1194 '(begin
1195 ;; TODO: unbundle gtest.
1196 (delete-file "build_tools/gnu_parallel")
7fa9cca8
MB		 1197 (substitute* "Makefile"
1198 (("build_tools/gnu_parallel") "parallel"))
d3c6ad0a
MB		 1199 #t))))
1200 (build-system gnu-build-system)
1201 (arguments
7fa9cca8
MB		 1202 `(#:make-flags (list "CC=gcc" "V=1"
1203 ;; Ceph requires that RTTI is enabled.
1204 "USE_RTTI=1"
d3c6ad0a 1205 (string-append "INSTALL_PATH="
7fa9cca8
MB		 1206 (assoc-ref %outputs "out"))
1207
1208 ;; Running the full test suite takes hours and require
1209 ;; a lot of disk space. Instead we only run a subset
1210 ;; (see .travis.yml and Makefile).
1211 "ROCKSDBTESTS_END=db_tailing_iter_test")
1212 #:test-target "check_some"
d7b344c5
MB		 1213 ;; Many tests fail on 32-bit platforms. There are multiple reports about
1214 ;; this upstream, but it's not going to be supported any time soon.
1215 #:tests? (let ((system ,(or (%current-target-system)
1216 (%current-system))))
1217 (or (string-prefix? "x86_64-linux" system)
1218 (string-prefix? "aarch64-linux" system)))
d3c6ad0a
MB		 1219 #:phases
1220 (modify-phases %standard-phases
1221 (add-after 'unpack 'patch-Makefile
1222 (lambda _
1223 (substitute* "Makefile"
f91c677c
MB		 1224 ;; Don't depend on the static library when installing.
1225 (("install: install-static")
1226 "install: install-shared")
d3c6ad0a
MB		 1227 (("#!/bin/sh") (string-append "#!" (which "sh"))))
1228 #t))
1229 (delete 'configure)
d7b344c5
MB		 1230 ;; The default target is only needed for tests and built on demand.
1231 (delete 'build)
1232 (add-before 'check 'disable-optimizations
1233 (lambda _
1234 ;; Prevent the build from passing '-march=native' to the compiler.
1235 (setenv "PORTABLE" "1")
1236 #t))
d3c6ad0a
MB		 1237 (add-before 'check 'disable-failing-tests
1238 (lambda _
1239 (substitute* "Makefile"
1240 ;; These tests reliably fail due to "Too many open files".
1241 (("^[[:blank:]]+env_test[[:blank:]]+\\\\") "\\")
1242 (("^[[:blank:]]+persistent_cache_test[[:blank:]]+\\\\") "\\"))
1243 #t))
7fa9cca8 1244 (add-after 'check 'build
f91c677c 1245 ;; The default build target is a debug build for tests. The
7fa9cca8
MB		 1246 ;; install target depends on the "shared_lib" release target
1247 ;; so we build it here for clarity.
1248 (lambda* (#:key (make-flags '()) parallel-build? #:allow-other-keys)
1249 (apply invoke "make" "shared_lib"
1250 `(,@(if parallel-build?
1251 `("-j" ,(number->string (parallel-job-count)))
1252 '())
1253 ,@make-flags)))))))
d3c6ad0a
MB		 1254 (native-inputs
1255 `(("parallel" ,parallel)
1256 ("perl" ,perl)
1257 ("procps" ,procps)
77e52190
MB		 1258 ("python" ,python-2)
1259 ("which" ,which)))
d3c6ad0a
MB		 1260 (inputs
1261 `(("bzip2" ,bzip2)
1262 ("gflags" ,gflags)
1263 ("jemalloc" ,jemalloc)
1264 ("lz4" ,lz4)
1265 ("snappy" ,snappy)
1266 ("zlib" ,zlib)))
0087a250 1267 (home-page "https://rocksdb.org/")
d3c6ad0a
MB		 1268 (synopsis "Persistent key-value store for fast storage")
1269 (description
1270 "RocksDB is a library that forms the core building block for a fast
1271key-value server, especially suited for storing data on flash drives. It
1272has a @dfn{Log-Structured-Merge-Database} (LSM) design with flexible tradeoffs
1273between @dfn{Write-Amplification-Factor} (WAF), @dfn{Read-Amplification-Factor}
1274(RAF) and @dfn{Space-Amplification-Factor} (SAF). It has multi-threaded
1275compactions, making it specially suitable for storing multiple terabytes of
1276data in a single database. RocksDB is partially based on @code{LevelDB}.")
7fa9cca8
MB		 1277 ;; RocksDB is dual licensed under GPL2 and ASL 2.0. Some header
1278 ;; files carry the 3-clause BSD license.
1279 (license (list license:gpl2 license:asl2.0 license:bsd-3))))
d3c6ad0a 1280
b92d02d9
RJ		 1281(define-public sparql-query
1282 (package
1283 (name "sparql-query")
1284 (version "1.1")
1285 (source (origin
ce64b9d1
EF		 1286 (method git-fetch)
1287 (uri (git-reference
1288 (url "https://github.com/tialaramex/sparql-query")
1289 (commit version)))
b92d02d9 1290 (sha256
ce64b9d1
EF		 1291 (base32 "0a84a89idpjhj9w2y3fmvzv7ldps1cva1kxvfmh897k02kaniwxk"))
1292 (file-name (git-file-name name version))))
b92d02d9
RJ		 1293 (build-system gnu-build-system)
1294 (inputs
6914eea0 1295 `(("curl" ,curl)
b92d02d9
RJ		 1296 ("glib" ,glib)
1297 ("libxml2" ,libxml2)
6914eea0
EF		 1298 ("ncurses" ,ncurses)
1299 ("readline" ,readline)))
b92d02d9
RJ		 1300 (native-inputs
1301 `(("pkg-config" ,pkg-config)))
1302 (arguments
1303 `(#:make-flags '("CC=gcc")
1304 #:phases
1305 (modify-phases %standard-phases
1306 (delete 'configure)
1307 ;; The Makefile uses git to obtain versioning information. This phase
1308 ;; substitutes the git invocation with the package version.
1309 (add-after 'unpack 'remove-git-dependency
1310 (lambda _
1311 (substitute* "Makefile"
1312 (("^gitrev :=.*$")
96272e28
MW		 1313 (string-append "gitrev = \"v" ,version "\"")))
1314 #t))
b92d02d9
RJ		 1315 ;; The install phase of the Makefile assumes $PREFIX/usr/local/bin.
1316 ;; This replacement does the same thing, except for using $PREFIX/bin
1317 ;; instead.
1318 (replace 'install
1319 (lambda* (#:key outputs #:allow-other-keys)
1320 (let* ((out (assoc-ref outputs "out"))
1321 (bin (string-append out "/bin")))
1322 (install-file "sparql-query" bin)
96272e28
MW		 1323 (symlink (string-append bin "/sparql-query")
1324 (string-append bin "/sparql-update")))
1325 #t))
b92d02d9
RJ		 1326 (replace 'check
1327 (lambda* (#:key make-flags #:allow-other-keys)
96272e28
MW		 1328 (apply invoke "make" `(,@make-flags "scan-test"))
1329 (invoke "./scan-test"))))))
b92d02d9
RJ		 1330 (home-page "https://github.com/tialaramex/sparql-query/")
1331 (synopsis "Command-line tool for accessing SPARQL endpoints over HTTP")
1332 (description "Sparql-query is a command-line tool for accessing SPARQL
36a4366d 1333endpoints over HTTP. It has been intentionally designed to @code{feel} similar to
b92d02d9
RJ		 1334tools for interrogating SQL databases. For example, you can enter a query over
1335several lines, using a semi-colon at the end of a line to indicate the end of
1336your query. It also supports readline so that you can more easily recall and
1337edit previous queries, even across sessions. It can be used non-interactively,
1338for example from a shell script.")
1339 ;; Some files (like scan-sparql.c) contain a GPLv3+ license header, while
1340 ;; others (like sparql-query.c) contain a GPLv2+ license header.
ba8b9f8d 1341 (license (list license:gpl3+))))
b92d02d9 1342
cabe8f18
CB		 1343(define-public sqitch
1344 (package
1345 (name "sqitch")
adcad547 1346 (version "1.1.0")
cabe8f18
CB		 1347 (source
1348 (origin
1349 (method url-fetch)
1350 (uri (string-append
f64cd5d1
TGR		 1351 "mirror://cpan/authors/id/D/DW/DWHEELER/App-Sqitch-v"
1352 version ".tar.gz"))
cabe8f18 1353 (sha256
adcad547 1354 (base32 "1ayiwg9kh3w0nbacbcln7h944z94vq5vnnd5diz86033bpbnq57f"))))
cabe8f18
CB		 1355 (build-system perl-build-system)
1356 (arguments
1357 '(#:phases
1358 (modify-phases %standard-phases
1359 (add-before 'check 'set-check-environment
1360 (lambda _
1361 (setenv "TZ" "UTC")
1362 (setenv "HOME" "/tmp")
1363 #t))
1364 (add-after 'install 'wrap-program
1365 (lambda* (#:key outputs #:allow-other-keys)
1366 (let* ((out (assoc-ref outputs "out"))
1367 (path (getenv "PERL5LIB")))
1368 (wrap-program (string-append out "/bin/sqitch")
1369 `("PERL5LIB" ":" prefix
1370 (,(string-append out "/lib/perl5/site_perl"
1371 ":"
1372 path)))))
1373 #t)))))
1374 (native-inputs
1375 `(("perl-capture-tiny" ,perl-capture-tiny)
1376 ("perl-io-pager" ,perl-io-pager)
1377 ("perl-module-build" ,perl-module-build)
1378 ("perl-module-runtime" ,perl-module-runtime)
1379 ("perl-path-class" ,perl-path-class)
1380 ("perl-test-deep" ,perl-test-deep)
1381 ("perl-test-dir" ,perl-test-dir)
1382 ("perl-test-exception" ,perl-test-exception)
1383 ("perl-test-file" ,perl-test-file)
1384 ("perl-test-file-contents" ,perl-test-file-contents)
1385 ("perl-test-mockmodule" ,perl-test-mockmodule)
adcad547 1386 ("perl-test-mockobject" ,perl-test-mockobject)
cabe8f18
CB		 1387 ("perl-test-nowarnings" ,perl-test-nowarnings)
1388 ("perl-test-warn" ,perl-test-warn)))
1389 (inputs
1390 `(("perl-class-xsaccessor" ,perl-class-xsaccessor)
1391 ("perl-clone" ,perl-clone)
1392 ("perl-config-gitlike" ,perl-config-gitlike)
1393 ("perl-datetime" ,perl-datetime)
1394 ("perl-datetime-timezone" ,perl-datetime-timezone)
6a1c3a90 1395 ("perl-dbd-mysql" ,perl-dbd-mysql)
cabe8f18 1396 ("perl-dbd-pg" ,perl-dbd-pg)
6a1c3a90 1397 ("perl-dbd-sqlite" ,perl-dbd-sqlite)
cabe8f18
CB		 1398 ("perl-dbi" ,perl-dbi)
1399 ("perl-devel-stacktrace" ,perl-devel-stacktrace)
1400 ("perl-encode-locale" ,perl-encode-locale)
cabe8f18
CB		 1401 ("perl-hash-merge" ,perl-hash-merge)
1402 ("perl-ipc-run3" ,perl-ipc-run3)
1403 ("perl-ipc-system-simple" ,perl-ipc-system-simple)
1404 ("perl-libintl-perl" ,perl-libintl-perl)
1405 ("perl-list-moreutils" ,perl-list-moreutils)
1406 ("perl-moo" ,perl-moo)
1407 ("perl-mysql-config" ,perl-mysql-config)
1408 ("perl-namespace-autoclean" ,perl-namespace-autoclean)
1409 ("perl-path-class" ,perl-path-class)
1410 ("perl-perlio-utf8_strict" ,perl-perlio-utf8_strict)
1411 ("perl-string-formatter" ,perl-string-formatter)
1412 ("perl-string-shellquote" ,perl-string-shellquote)
1413 ("perl-sub-exporter" ,perl-sub-exporter)
1414 ("perl-template-tiny" ,perl-template-tiny)
1415 ("perl-template-toolkit" ,perl-template-toolkit)
1416 ("perl-throwable" ,perl-throwable)
1417 ("perl-try-tiny" ,perl-try-tiny)
1418 ("perl-type-tiny" ,perl-type-tiny)
1419 ("perl-type-tiny-xs" ,perl-type-tiny-xs)
1420 ("perl-uri" ,perl-uri)
1421 ("perl-uri-db" ,perl-uri-db)))
1422 (home-page "https://sqitch.org/")
1423 (synopsis "Database change management tool")
1424 (description
1425 "Sqitch is a standalone change management system for database schemas,
1426which uses SQL to describe changes.")
1427 (license license:x11)))
1428
311f06c9
TGR		 1429(define-public sqlcrush
1430 ;; Unfortunately, there is no proper upstream release and may never be.
1431 (let ((commit "b5f6868f189566a26eecc78d0f0659813c1aa98a")
1432 (revision "1"))
1433 (package
1434 (name "sqlcrush")
1435 (version (git-version "0.1.5" revision commit))
1436 (source (origin
1437 (method git-fetch)
1438 (uri (git-reference
b0e7b699 1439 (url "https://github.com/coffeeandscripts/sqlcrush")
311f06c9
TGR		 1440 (commit commit)))
1441 (file-name (git-file-name name version))
1442 (sha256
1443 (base32
1444 "0x3wy40r93p0jv3nbwj9a77wa4ff697d13r0wffmm7q9h3mzsww8"))))
1445 (build-system python-build-system)
1446 (inputs
1447 `(("python-cryptography" ,python-cryptography)
1448 ("python-psycopg2" ,python-psycopg2)
1449 ("python-pymysql" ,python-pymysql)
1450 ("python-sqlalchemy" ,python-sqlalchemy)))
1451 (home-page "https://github.com/coffeeandscripts/sqlcrush")
1452 (synopsis "Text console-based database viewer and editor")
1453 (description
1454 "SQLcrush lets you view and edit a database directly from the text
1455console through an ncurses interface. You can explore each table's structure,
1456browse and edit the contents, add and delete entries, all while tracking your
1457changes.")
1458 (license license:gpl3+)))) ; no headers, see README.md
1459
db60b1d9
LC		 1460(define-public tdb
1461 (package
1462 (name "tdb")
10f004f0 1463 (version "1.4.3")
db60b1d9
LC		 1464 (source (origin
1465 (method url-fetch)
ca473fc2 1466 (uri (string-append "https://www.samba.org/ftp/tdb/tdb-"
db60b1d9
LC		 1467 version ".tar.gz"))
1468 (sha256
1469 (base32
10f004f0 1470 "06waz0k50c7v3chd08mzp2rv7w4k4q9isbxx3vhlfpx1vy9q61f8"))))
db60b1d9
LC		 1471 (build-system gnu-build-system)
1472 (arguments
6ccb7814
EF		 1473 '(#:phases
1474 (modify-phases %standard-phases
1475 (replace 'configure
1476 (lambda* (#:key outputs #:allow-other-keys)
1477 (let ((out (assoc-ref outputs "out")))
1478 ;; The 'configure' script is a wrapper for Waf and
1479 ;; doesn't recognize things like '--enable-fast-install'.
96272e28
MW		 1480 (invoke "./configure"
1481 (string-append "--prefix=" out))))))))
db60b1d9
LC		 1482 (native-inputs
1483 `(;; TODO: Build the documentation.
1484 ;; ("docbook-xsl" ,docbook-xsl)
1485 ;; ("libxml2" ,libxml2)
1486 ;; ("libxslt" ,libxslt)
97dcedbd
MB		 1487 ("python" ,python) ;for the Waf build system
1488 ("which" ,which)))
1abd0904 1489 (home-page "https://tdb.samba.org/")
35b9e423 1490 (synopsis "Trivial database")
db60b1d9
LC		 1491 (description
1492 "TDB is a Trivial Database. In concept, it is very much like GDBM,
1493and BSD's DB except that it allows multiple simultaneous writers and uses
1494locking internally to keep writers from trampling on each other. TDB is also
1495extremely small.")
ba8b9f8d 1496 (license license:lgpl3+)))
274da61d
LC		 1497
1498(define-public perl-dbi
1499 (package
1500 (name "perl-dbi")
d0ed680b 1501 (version "1.643")
274da61d
LC		 1502 (source (origin
1503 (method url-fetch)
1504 (uri (string-append
1505 "mirror://cpan/authors/id/T/TI/TIMB/DBI-"
1506 version ".tar.gz"))
1507 (sha256
1508 (base32
d0ed680b 1509 "1yinx39960y241vf2sknxj0dfz82a5m9gvklq5rw78k0nlyrjawa"))))
274da61d
LC		 1510 (build-system perl-build-system)
1511 (synopsis "Database independent interface for Perl")
1512 (description "This package provides an database interface for Perl.")
9aba9b12 1513 (home-page "https://metacpan.org/release/DBI")
2f3108ad 1514 (license license:perl-license)))
274da61d 1515
feae3395
EB		 1516(define-public perl-dbix-class
1517 (package
1518 (name "perl-dbix-class")
23ec2a0e 1519 (version "0.082842")
feae3395
EB		 1520 (source
1521 (origin
1522 (method url-fetch)
1523 (uri (string-append "mirror://cpan/authors/id/R/RI/RIBASUSHI/"
1524 "DBIx-Class-" version ".tar.gz"))
1525 (sha256
23ec2a0e 1526 (base32 "1rh7idjjbibc1zmiaaarask434lh0lx7f2xyfwmy37k9fa0xcpmh"))))
feae3395
EB		 1527 (build-system perl-build-system)
1528 (native-inputs
1529 `(("perl-dbd-sqlite" ,perl-dbd-sqlite)
1530 ("perl-file-temp" ,perl-file-temp)
2f837cf7 1531 ("perl-module-install" ,perl-module-install)
feae3395
EB		 1532 ("perl-package-stash" ,perl-package-stash)
1533 ("perl-test-deep" ,perl-test-deep)
1534 ("perl-test-exception" ,perl-test-exception)
1535 ("perl-test-warn" ,perl-test-warn)))
1536 (propagated-inputs
1537 `(("perl-class-accessor-grouped" ,perl-class-accessor-grouped)
1538 ("perl-class-c3-componentised" ,perl-class-c3-componentised)
1539 ("perl-class-inspector" ,perl-class-inspector)
1540 ("perl-config-any" ,perl-config-any)
1541 ("perl-context-preserve" ,perl-context-preserve)
1542 ("perl-data-dumper-concise" ,perl-data-dumper-concise)
1543 ("perl-data-page" ,perl-data-page)
1544 ("perl-dbi" ,perl-dbi)
1545 ("perl-devel-globaldestruction" ,perl-devel-globaldestruction)
1546 ("perl-hash-merge" ,perl-hash-merge)
1547 ("perl-module-find" ,perl-module-find)
1548 ("perl-moo" ,perl-moo)
1549 ("perl-mro-compat" ,perl-mro-compat)
1550 ("perl-namespace-clean" ,perl-namespace-clean)
1551 ("perl-path-class" ,perl-path-class)
1552 ("perl-scalar-list-utils" ,perl-scalar-list-utils)
1553 ("perl-scope-guard" ,perl-scope-guard)
23ec2a0e 1554 ("perl-sql-abstract-classic" ,perl-sql-abstract-classic)
feae3395
EB		 1555 ("perl-sub-name" ,perl-sub-name)
1556 ("perl-text-balanced" ,perl-text-balanced)
1557 ("perl-try-tiny" ,perl-try-tiny)))
9aba9b12 1558 (home-page "https://metacpan.org/release/DBIx-Class")
feae3395
EB		 1559 (synopsis "Extensible and flexible object <-> relational mapper")
1560 (description "An SQL to OO mapper with an object API inspired by
1561Class::DBI (with a compatibility layer as a springboard for porting) and a
1562resultset API that allows abstract encapsulation of database operations. It
1563aims to make representing queries in your code as perl-ish as possible while
1564still providing access to as many of the capabilities of the database as
1565possible, including retrieving related records from multiple tables in a
1566single query, \"JOIN\", \"LEFT JOIN\", \"COUNT\", \"DISTINCT\", \"GROUP BY\",
1567\"ORDER BY\" and \"HAVING\" support.")
2f3108ad 1568 (license license:perl-license)))
e61fd0f0 1569
4e4039e5
EB		 1570(define-public perl-dbix-class-cursor-cached
1571 (package
1572 (name "perl-dbix-class-cursor-cached")
180cb81b 1573 (version "1.001004")
4e4039e5
EB		 1574 (source
1575 (origin
1576 (method url-fetch)
1577 (uri (string-append "mirror://cpan/authors/id/A/AR/ARCANEZ/"
1578 "DBIx-Class-Cursor-Cached-" version ".tar.gz"))
1579 (sha256
1580 (base32
180cb81b 1581 "09b2jahn2x12qm4f7qm1jzsxbz7qn1czp6a3fnl5l2i3l4r5421p"))))
4e4039e5
EB		 1582 (build-system perl-build-system)
1583 (native-inputs
1584 `(("perl-cache-cache" ,perl-cache-cache)
2f837cf7
MB		 1585 ("perl-dbd-sqlite" ,perl-dbd-sqlite)
1586 ("perl-module-install" ,perl-module-install)))
4e4039e5
EB		 1587 (propagated-inputs
1588 `(("perl-carp-clan" ,perl-carp-clan)
1589 ("perl-dbix-class" ,perl-dbix-class)))
9aba9b12 1590 (home-page "https://metacpan.org/release/DBIx-Class-Cursor-Cached")
4e4039e5
EB		 1591 (synopsis "Cursor with built-in caching support")
1592 (description "DBIx::Class::Cursor::Cached provides a cursor class with
1593built-in caching support.")
2f3108ad 1594 (license license:perl-license)))
4e4039e5 1595
e61fd0f0
EB		 1596(define-public perl-dbix-class-introspectablem2m
1597 (package
1598 (name "perl-dbix-class-introspectablem2m")
7a462b80 1599 (version "0.001002")
e61fd0f0
EB		 1600 (source
1601 (origin
1602 (method url-fetch)
68a9d6df 1603 (uri (string-append "mirror://cpan/authors/id/I/IL/ILMARI/"
e61fd0f0
EB		 1604 "DBIx-Class-IntrospectableM2M-" version ".tar.gz"))
1605 (sha256
1606 (base32
7a462b80 1607 "1w47rh2241iy5x3a9bqsyd5kdp9sk43dksr99frzv4qn4jsazfn6"))))
e61fd0f0 1608 (build-system perl-build-system)
2f837cf7
MB		 1609 (native-inputs
1610 `(("perl-module-install" ,perl-module-install)))
e61fd0f0
EB		 1611 (propagated-inputs
1612 `(("perl-dbix-class" ,perl-dbix-class)))
9aba9b12 1613 (home-page "https://metacpan.org/release/DBIx-Class-IntrospectableM2M")
e61fd0f0
EB		 1614 (synopsis "Introspect many-to-many relationships")
1615 (description "Because the many-to-many relationships are not real
1616relationships, they can not be introspected with DBIx::Class. Many-to-many
1617relationships are actually just a collection of convenience methods installed
1618to bridge two relationships. This DBIx::Class component can be used to store
1619all relevant information about these non-relationships so they can later be
1620introspected and examined.")
2f3108ad 1621 (license license:perl-license)))
708155df
EB		 1622
1623(define-public perl-dbix-class-schema-loader
1624 (package
1625 (name "perl-dbix-class-schema-loader")
1672e7e7 1626 (version "0.07049")
708155df
EB		 1627 (source
1628 (origin
1629 (method url-fetch)
1630 (uri (string-append "mirror://cpan/authors/id/I/IL/ILMARI/"
1631 "DBIx-Class-Schema-Loader-" version ".tar.gz"))
1632 (sha256
1633 (base32
1672e7e7 1634 "0r57fv71ypxafb85cpxph1hdqii7ipjwvc19yb6fpkvq2ggcssg8"))))
708155df
EB		 1635 (build-system perl-build-system)
1636 (native-inputs
1637 `(("perl-config-any" ,perl-config-any)
1638 ("perl-config-general" ,perl-config-general)
1639 ("perl-dbd-sqlite" ,perl-dbd-sqlite)
1640 ("perl-dbix-class-introspectablem2m" ,perl-dbix-class-introspectablem2m)
2f837cf7 1641 ("perl-module-install" ,perl-module-install)
708155df
EB		 1642 ("perl-moose" ,perl-moose)
1643 ("perl-moosex-markasmethods" ,perl-moosex-markasmethods)
1644 ("perl-moosex-nonmoose" ,perl-moosex-nonmoose)
1645 ("perl-namespace-autoclean" ,perl-namespace-autoclean)
1646 ("perl-test-deep" ,perl-test-deep)
1647 ("perl-test-differences" ,perl-test-differences)
1648 ("perl-test-exception" ,perl-test-exception)
1649 ("perl-test-pod" ,perl-test-pod)
1650 ("perl-test-warn" ,perl-test-warn)))
1651 (propagated-inputs
1652 `(("perl-class-unload" ,perl-class-unload)
1653 ("perl-class-inspector" ,perl-class-inspector)
1654 ("perl-class-accessor-grouped" ,perl-class-accessor-grouped)
1655 ("perl-class-c3-componentised" ,perl-class-c3-componentised)
1656 ("perl-carp-clan" ,perl-carp-clan)
1657 ("perl-data-dump" ,perl-data-dump)
1658 ("perl-dbix-class" ,perl-dbix-class)
1659 ("perl-hash-merge" ,perl-hash-merge)
1660 ("perl-list-moreutils" ,perl-list-moreutils)
1661 ("perl-lingua-en-inflect-phrase" ,perl-lingua-en-inflect-phrase)
1662 ("perl-lingua-en-inflect-number" ,perl-lingua-en-inflect-number)
1663 ("perl-lingua-en-tagger" ,perl-lingua-en-tagger)
1664 ("perl-namespace-clean" ,perl-namespace-clean)
1665 ("perl-mro-compat" ,perl-mro-compat)
1666 ("perl-scope-guard" ,perl-scope-guard)
1667 ("perl-string-camelcase" ,perl-string-camelcase)
1668 ("perl-string-toidentifier-en" ,perl-string-toidentifier-en)
1669 ("perl-sub-name" ,perl-sub-name)
1670 ("perl-try-tiny" ,perl-try-tiny)))
1671 (arguments `(#:tests? #f)) ;TODO: t/20invocations.t fails
9aba9b12 1672 (home-page "https://metacpan.org/release/DBIx-Class-Schema-Loader")
708155df
EB		 1673 (synopsis "Create a DBIx::Class::Schema based on a database")
1674 (description "DBIx::Class::Schema::Loader automates the definition of a
1675DBIx::Class::Schema by scanning database table definitions and setting up the
1676columns, primary keys, unique constraints and relationships.")
2f3108ad 1677 (license license:perl-license)))
274da61d 1678
186eb132
EB		 1679(define-public perl-dbd-pg
1680 (package
1681 (name "perl-dbd-pg")
8c078dde 1682 (version "3.7.4")
186eb132
EB		 1683 (source
1684 (origin
1685 (method url-fetch)
1686 (uri (string-append "mirror://cpan/authors/id/T/TU/TURNSTEP/"
1687 "DBD-Pg-" version ".tar.gz"))
1688 (sha256
1689 (base32
8c078dde 1690 "0gkqlvbmzbdm0g4k328nlkjdg3wrjm5i2n9jxj1i8sqxkm79rylz"))))
186eb132
EB		 1691 (build-system perl-build-system)
1692 (native-inputs
1693 `(("perl-dbi" ,perl-dbi)))
1694 (propagated-inputs
1695 `(("perl-dbi" ,perl-dbi)
1696 ("postgresql" ,postgresql)))
9aba9b12 1697 (home-page "https://metacpan.org/release/DBD-Pg")
186eb132 1698 (synopsis "DBI PostgreSQL interface")
f33e71fc
LC		 1699 (description "This package provides a PostgreSQL driver for the Perl5
1700@dfn{Database Interface} (DBI).")
2f3108ad 1701 (license license:perl-license)))
186eb132 1702
4b7857a4
RW		 1703(define-public perl-dbd-mysql
1704 (package
1705 (name "perl-dbd-mysql")
49596a54 1706 (version "4.050")
4b7857a4
RW		 1707 (source
1708 (origin
1709 (method url-fetch)
49596a54 1710 (uri (string-append "mirror://cpan/authors/id/D/DV/DVEEDEN/"
4b7857a4
RW		 1711 "DBD-mysql-" version ".tar.gz"))
1712 (sha256
49596a54 1713 (base32 "0y4djb048i09dk19av7mzfb3khr72vw11p3ayw2p82jsy4gm8j2g"))))
4b7857a4 1714 (build-system perl-build-system)
702a87f2
TGR		 1715 (arguments
1716 `(#:phases
1717 (modify-phases %standard-phases
1718 (add-before 'configure 'skip-library-detection
1719 ;; Avoid depencies on perl-devel-checklib, openssl, and zlib. They
1720 ;; are really only needed for the test suite; their absence does not
1721 ;; affect the build or the end result.
1722 (lambda _
1723 (substitute* "Makefile.PL"
1724 (("use Devel::CheckLib;" match)
1725 (string-append "# " match))
1726 (("assert_lib")
1727 "print"))
1728 #t)))
1729 ;; Tests require running MySQL server.
1730 #:tests? #f))
4b7857a4
RW		 1731 (propagated-inputs
1732 `(("perl-dbi" ,perl-dbi)
2b8491fb
JL		 1733 ("mysql" ,mariadb "lib")
1734 ("mysql-dev" ,mariadb "dev")))
9aba9b12 1735 (home-page "https://metacpan.org/release/DBD-mysql")
4b7857a4
RW		 1736 (synopsis "DBI MySQL interface")
1737 (description "This package provides a MySQL driver for the Perl5
1738@dfn{Database Interface} (DBI).")
2f3108ad 1739 (license license:perl-license)))
4b7857a4 1740
274da61d
LC		 1741(define-public perl-dbd-sqlite
1742 (package
1743 (name "perl-dbd-sqlite")
26aa1fd2 1744 (version "1.64")
274da61d
LC		 1745 (source (origin
1746 (method url-fetch)
1747 (uri (string-append
1748 "mirror://cpan/authors/id/I/IS/ISHIGAKI/DBD-SQLite-"
1749 version ".tar.gz"))
1750 (sha256
1751 (base32
26aa1fd2 1752 "00gz5aw3xrr92lf9nfk0dhmy7a8jzmxhznddd9b0a8w4a1xqzbpl"))))
274da61d
LC		 1753 (build-system perl-build-system)
1754 (inputs `(("sqlite" ,sqlite)))
1755 (propagated-inputs `(("perl-dbi" ,perl-dbi)))
1756 (synopsis "SQlite interface for Perl")
1757 (description "DBD::SQLite is a Perl DBI driver for SQLite, that includes
1758the entire thing in the distribution. So in order to get a fast transaction
1759capable RDBMS working for your Perl project you simply have to install this
1760module, and nothing else.")
2f3108ad 1761 (license license:perl-license)
9aba9b12 1762 (home-page "https://metacpan.org/release/DBD-SQLite")))
14e84b2d 1763
55916fa2
CB		 1764(define-public perl-mysql-config
1765 (package
1766 (name "perl-mysql-config")
1767 (version "1.04")
1768 (source
1769 (origin
1770 (method url-fetch)
1771 (uri (string-append
1772 "mirror://cpan/authors/id/D/DA/DARREN/MySQL-Config-"
1773 version
1774 ".tar.gz"))
1775 (sha256
1776 (base32
1777 "1svn7ccw2gc4cazvc58j84rxhnc9vs01zpird0l8460598j475qr"))))
1778 (build-system perl-build-system)
1779 (home-page "https://metacpan.org/release/MySQL-Config")
1780 (synopsis "Parse and utilize MySQL's /etc/my.cnf and ~/.my.cnf files")
1781 (description
1782 "@code{MySQL::Config} emulates the @code{load_defaults} function from
1783libmysqlclient. It will fill an aray with long options, ready to be parsed by
1784@code{Getopt::Long}.")
1785 (license license:perl-license)))
1786
dd90952e
EB		 1787(define-public perl-sql-abstract
1788 (package
1789 (name "perl-sql-abstract")
7a358c78 1790 (version "1.87")
dd90952e
EB		 1791 (source
1792 (origin
1793 (method url-fetch)
439980b7 1794 (uri (string-append "mirror://cpan/authors/id/I/IL/ILMARI/"
dd90952e
EB		 1795 "SQL-Abstract-" version ".tar.gz"))
1796 (sha256
7a358c78 1797 (base32 "0jhw91b23wc9bkfwcgvka4x5ddxk58m9bcp5ay7a3vx77nla09p9"))))
dd90952e
EB		 1798 (build-system perl-build-system)
1799 (native-inputs
9dab5017
MB		 1800 `(("perl-module-install" ,perl-module-install)
1801 ("perl-test-deep" ,perl-test-deep)
dd90952e
EB		 1802 ("perl-test-exception" ,perl-test-exception)
1803 ("perl-test-warn" ,perl-test-warn)))
1804 (propagated-inputs
1805 `(("perl-hash-merge" ,perl-hash-merge)
1806 ("perl-moo" ,perl-moo)
1807 ("perl-mro-compat" ,perl-mro-compat)
1808 ("perl-text-balanced" ,perl-text-balanced)))
9aba9b12 1809 (home-page "https://metacpan.org/release/SQL-Abstract")
dd90952e
EB		 1810 (synopsis "Generate SQL from Perl data structures")
1811 (description "This module was inspired by the excellent DBIx::Abstract.
1812While based on the concepts used by DBIx::Abstract, the concepts used have
1813been modified to make the SQL easier to generate from Perl data structures.
1814The underlying idea is for this module to do what you mean, based on the data
1815structures you provide it, so that you don't have to modify your code every
e881752c 1816time your data changes.")
2f3108ad 1817 (license license:perl-license)))
14e84b2d 1818
5d01aeba
TGR		 1819(define-public perl-sql-abstract-classic
1820 (package
1821 (name "perl-sql-abstract-classic")
1822 (version "1.91")
1823 (source
1824 (origin
1825 (method url-fetch)
1826 (uri (string-append "mirror://cpan/authors/id/R/RI/RIBASUSHI/"
1827 "SQL-Abstract-Classic-" version ".tar.gz"))
1828 (sha256
1829 (base32 "0a7g13hs3kdxrjn43sfli09mgsi9d6w0dfw6hlk268av17yisgaf"))))
1830 (build-system perl-build-system)
1831 (native-inputs
1832 `(("perl-test-deep" ,perl-test-deep)
1833 ("perl-test-exception" ,perl-test-exception)
1834 ("perl-test-warn" ,perl-test-warn)))
1835 (propagated-inputs
1836 `(("perl-mro-compat" ,perl-mro-compat)
1837 ("perl-sql-abstract" ,perl-sql-abstract)))
1838 (home-page "https://metacpan.org/release/SQL-Abstract-Classic")
1839 (synopsis "Generate SQL from Perl data structures")
1840 (description
1841 "This module is nearly identical to @code{SQL::Abstract} 1.81, and exists
1842to preserve the ability of users to opt into the new way of doing things in
1843later versions according to their own schedules.
1844
1845It is an abstract SQL generation module based on the concepts used by
1846@code{DBIx::Abstract}, with several important differences, especially when it
1847comes to @code{WHERE} clauses. These concepts were modified to make the SQL
1848easier to generate from Perl data structures.
1849
1850The underlying idea is for this module to do what you mean, based on the data
1851structures you provide it. You shouldn't have to modify your code every time
1852your data changes, as this module figures it out.")
1853 (license license:perl-license)))
1854
b4dcb026
EB		 1855(define-public perl-sql-splitstatement
1856 (package
1857 (name "perl-sql-splitstatement")
1858 (version "1.00020")
1859 (source
1860 (origin
1861 (method url-fetch)
1862 (uri (string-append "mirror://cpan/authors/id/E/EM/EMAZEP/"
1863 "SQL-SplitStatement-" version ".tar.gz"))
1864 (sha256
1865 (base32
1866 "0bqg45k4c9qkb2ypynlwhpvzsl4ssfagmsalys18s5c79ps30z7p"))))
1867 (build-system perl-build-system)
1868 (native-inputs
1869 `(("perl-test-exception" ,perl-test-exception)))
1870 (propagated-inputs
1871 `(("perl-class-accessor" ,perl-class-accessor)
1872 ("perl-list-moreutils" ,perl-list-moreutils)
1873 ("perl-regexp-common" ,perl-regexp-common)
1874 ("perl-sql-tokenizer" ,perl-sql-tokenizer)))
9aba9b12 1875 (home-page "https://metacpan.org/release/SQL-SplitStatement")
b4dcb026
EB		 1876 (synopsis "Split SQL code into atomic statements")
1877 (description "This module tries to split any SQL code, even including
1878non-standard extensions, into the atomic statements it is composed of.")
2f3108ad 1879 (license license:perl-license)))
b4dcb026 1880
718c89c1
EB		 1881(define-public perl-sql-tokenizer
1882 (package
1883 (name "perl-sql-tokenizer")
1884 (version "0.24")
1885 (source
1886 (origin
1887 (method url-fetch)
1888 (uri (string-append "mirror://cpan/authors/id/I/IZ/IZUT/"
1889 "SQL-Tokenizer-" version ".tar.gz"))
1890 (sha256
1891 (base32
1892 "1qa2dfbzdlr5qqdam9yn78z5w3al5r8577x06qan8wv58ay6ka7s"))))
1893 (build-system perl-build-system)
9aba9b12 1894 (home-page "https://metacpan.org/release/SQL-Tokenizer")
718c89c1
EB		 1895 (synopsis "SQL tokenizer")
1896 (description "SQL::Tokenizer is a tokenizer for SQL queries. It does not
1897claim to be a parser or query verifier. It just creates sane tokens from a
1898valid SQL query.")
2f3108ad 1899 (license license:perl-license)))
718c89c1 1900
14e84b2d
JD		 1901(define-public unixodbc
1902 (package
1903 (name "unixodbc")
8327ffcc 1904 (version "2.3.7")
14e84b2d
JD		 1905 (source (origin
1906 (method url-fetch)
e881752c 1907 (uri
14e84b2d 1908 (string-append
3fef0a2f
EF		 1909 "ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-"
1910 version ".tar.gz"))
14e84b2d 1911 (sha256
8327ffcc 1912 (base32 "0xry3sg497wly8f7715a7gwkn2k36bcap0mvzjw74jj53yx6kwa5"))))
14e84b2d
JD		 1913 (build-system gnu-build-system)
1914 (synopsis "Data source abstraction library")
1915 (description "Unixodbc is a library providing an API with which to access
1916data sources. Data sources include SQL Servers and any software with an ODBC
1917Driver.")
ba8b9f8d 1918 (license license:lgpl2.1+)
14e84b2d
JD		 1919 ;; COPYING contains copy of lgpl2.1 - but copyright notices just say "LGPL"
1920 (home-page "http://www.unixodbc.org")))
b4a9c924
EB		 1921
1922(define-public unqlite
1923 (package
1924 (name "unqlite")
1925 (version "1.1.6")
1926 (source (origin
1927 (method url-fetch)
1928 ;; Contains bug fixes against the official release, and has an
1929 ;; autotooled build system.
1930 (uri (string-append "https://github.com/aidin36/tocc/releases/"
1931 "download/v1.0.0/"
1932 "unqlite-unofficial-" version ".tar.gz"))
1933 (sha256
1934 (base32
1935 "1sbpvhg15gadq0mpcy16q7k3rkg4b4dicpnn5xifpkpn02sqik3s"))))
1936 (build-system gnu-build-system)
1937 (arguments `(#:tests? #f)) ;No check target
f50ef349 1938 (home-page "https://www.unqlite.org")
b4a9c924
EB		 1939 (synopsis "In-memory key/value and document store")
1940 (description
1941 "UnQLite is an in-process software library which implements a
1942self-contained, serverless, zero-configuration, transactional NoSQL
1943database engine. UnQLite is a document store database similar to
1944MongoDB, Redis, CouchDB, etc. as well as a standard Key/Value store
69b4ffcf 1945similar to BerkeleyDB, LevelDB, etc.")
ba8b9f8d 1946 (license license:bsd-2)))
463f6766
DT		 1947
1948(define-public redis
1949 (package
1950 (name "redis")
84032506 1951 (version "5.0.7")
463f6766
DT		 1952 (source (origin
1953 (method url-fetch)
1954 (uri (string-append "http://download.redis.io/releases/redis-"
1955 version".tar.gz"))
1956 (sha256
1957 (base32
84032506 1958 "0ax8sf3vw0yadr41kzc04917scrg5wir1d94zmbz00b8pzm79nv1"))))
463f6766
DT		 1959 (build-system gnu-build-system)
1960 (arguments
1961 '(#:tests? #f ; tests related to master/slave and replication fail
1962 #:phases (modify-phases %standard-phases
1963 (delete 'configure))
1964 #:make-flags `("CC=gcc"
1965 "MALLOC=libc"
b25f060f 1966 "LDFLAGS=-ldl"
463f6766
DT		 1967 ,(string-append "PREFIX="
1968 (assoc-ref %outputs "out")))))
1969 (synopsis "Key-value cache and store")
1970 (description "Redis is an advanced key-value cache and store. Redis
1971supports many data structures including strings, hashes, lists, sets, sorted
1972sets, bitmaps and hyperloglogs.")
5a3cbfce 1973 (home-page "https://redis.io/")
ba8b9f8d 1974 (license license:bsd-3)))
a65e2a02 1975
1976(define-public kyotocabinet
1977 (package
1978 (name "kyotocabinet")
9f304362 1979 (version "1.2.78")
a65e2a02 1980 (source (origin
1981 (method url-fetch)
7fc2ba2a
TGR		 1982 (uri (string-append "https://fallabs.com/kyotocabinet/pkg/"
1983 "kyotocabinet-" version ".tar.gz"))
a65e2a02 1984 (sha256
1985 (base32
9f304362 1986 "1bxkf9kmcavq9rqridb8mvmrk3hj4447ffi24m2admsbm61n6k29"))))
a65e2a02 1987 (build-system gnu-build-system)
1988 (arguments
1989 `(#:configure-flags
1990 (list
9d59023e 1991 "--disable-opt" ;"-march=native". XXX this also turns off -O0.
a65e2a02 1992 (string-append "LDFLAGS=-Wl,-rpath="
1993 (assoc-ref %outputs "out") "/lib"))))
1994 (inputs `(("zlib" ,zlib)))
7fc2ba2a 1995 (home-page "https://fallabs.com/kyotocabinet/")
a65e2a02 1996 (synopsis
1997 "Kyoto Cabinet is a modern implementation of the DBM database")
1998 (description
1999 "Kyoto Cabinet is a standalone file-based database that supports Hash
2000and B+ Tree data storage models. It is a fast key-value lightweight
2001database and supports many programming languages. It is a NoSQL database.")
ba8b9f8d 2002 (license license:gpl3+)))
6242b314 2003
bdc11dc4 2004(define-public tokyocabinet
2005 (package
2006 (name "tokyocabinet")
2007 (version "1.4.48")
2008 (source
2009 (origin
2010 (method url-fetch)
2011 (uri (string-append "http://fallabs.com/tokyocabinet/"
2012 name "-" version ".tar.gz"))
2013 (sha256
2014 (base32
2015 "140zvr0n8kvsl0fbn2qn3f2kh3yynfwnizn4dgbj47m975yg80x0"))))
2016 (build-system gnu-build-system)
2017 (arguments
2018 `(#:configure-flags
2019 (list "--enable-pthread" "--enable-off64" "--enable-fastest"
2020 (string-append "LDFLAGS=-Wl,-rpath="
2021 (assoc-ref %outputs "out") "/lib"))))
2022 (inputs
2023 `(("zlib" ,zlib)))
2024 (home-page "http://fallabs.com/tokyocabinet/")
2025 (synopsis "Tokyo Cabinet is a modern implementation of the DBM database")
2026 (description
2027 "Tokyo Cabinet is a library of routines for managing a database.
2028The database is a simple data file containing records, each is a pair of a
2029key and a value. Every key and value is serial bytes with variable length.
2030Both binary data and character string can be used as a key and a value.
2031There is neither concept of data tables nor data types. Records are
2032organized in hash table, B+ tree, or fixed-length array.")
2033 (license license:lgpl2.1+)))
2034
6242b314
SB		 2035(define-public wiredtiger
2036 (package
2037 (name "wiredtiger")
81e95821 2038 (version "2.9.1")
6242b314
SB		 2039 (source (origin
2040 (method url-fetch)
2041 (uri (string-append
2042 "http://source.wiredtiger.com/releases/wiredtiger-"
2043 version ".tar.bz2"))
2044 (sha256
2045 (base32
81e95821 2046 "0krwnb2zfbhvjaskwl875qzd3y626s84zcciq2mxr5c5riw3yh6s"))))
6242b314
SB		 2047 (build-system gnu-build-system)
2048 (arguments
a469c695 2049 '(#:configure-flags '("--enable-lz4" "--with-builtins=snappy,zlib")
6242b314
SB		 2050 #:phases
2051 (modify-phases %standard-phases
2052 (add-before 'check 'disable-test/fops
2053 (lambda _
2054 ;; XXX: timed out after 3600 seconds of silence
2055 (substitute* "Makefile"
2056 (("test/fops") ""))
2057 #t)))))
2058 (inputs
2059 `(("lz4" ,lz4)
3faa422d
CB		 2060 ("zlib" ,zlib)
2061 ("snappy" ,snappy)))
6242b314
SB		 2062 (home-page "http://source.wiredtiger.com/")
2063 (synopsis "NoSQL data engine")
2064 (description
2065 "WiredTiger is an extensible platform for data management. It supports
2066row-oriented storage (where all columns of a row are stored together),
2067column-oriented storage (where columns are stored in groups, allowing for
2068more efficient access and storage of column subsets) and log-structured merge
2069trees (LSM), for sustained throughput under random insert workloads.")
ba8b9f8d 2070 (license license:gpl3) ; or GPL-2
6242b314 2071 ;; configure.ac: WiredTiger requires a 64-bit build.
092b7b3e 2072 (supported-systems '("x86_64-linux" "mips64el-linux" "aarch64-linux"))))
90c2ee88 2073
4680fef7
AB		 2074(define-public wiredtiger-3
2075 (package
2076 (inherit wiredtiger)
2077 (name "wiredtiger")
2078 (version "3.1.0")
2079 (source (origin
2080 (method url-fetch)
2081 (uri (string-append "http://source.wiredtiger.com/releases/wiredtiger-"
2082 version ".tar.bz2"))
2083 (sha256
2084 (base32
2085 "014awypv579ascg4jbx4pndj2wld337m79yyzrzyr7hxrff139jx"))))))
2086
16973071
KB		 2087(define-public guile-wiredtiger
2088 (package
2089 (name "guile-wiredtiger")
b1e6b938 2090 (version "0.7.0")
16973071
KB		 2091 (source (origin
2092 (method git-fetch)
2093 (uri (git-reference
2094 (url "https://framagit.org/a-guile-mind/guile-wiredtiger.git")
b1e6b938 2095 (commit "340ad4bc2ff4dcc6216a2f5c6f9172ca320ac66b")))
16973071
KB		 2096 (file-name (string-append name "-" version "-checkout"))
2097 (sha256
2098 (base32
b1e6b938 2099 "15j36bvxxzil7qpwlmh1rffqpva3ynvrcpqhhqbj2c9208ayz595"))))
16973071
KB		 2100 (build-system gnu-build-system)
2101 (arguments
3926a099 2102 '(#:parallel-tests? #f ;; tests can't be run in parallel, yet.
16973071
KB		 2103 #:configure-flags
2104 (list (string-append "--with-libwiredtiger-prefix="
2105 (assoc-ref %build-inputs "wiredtiger")))
189be331 2106 #:make-flags '("GUILE_AUTO_COMPILE=0")))
16973071
KB		 2107 (native-inputs
2108 `(("autoconf" ,autoconf)
2109 ("automake" ,automake)
2110 ("pkg-config" ,pkg-config)))
2111 (inputs
b1e6b938 2112 `(("wiredtiger" ,wiredtiger-3)
16973071
KB		 2113 ("guile" ,guile-2.2)))
2114 (propagated-inputs
b1e6b938 2115 `(("guile-bytestructures" ,guile-bytestructures)))
3926a099 2116 (synopsis "WiredTiger bindings for GNU Guile")
16973071
KB		 2117 (description
2118 "This package provides Guile bindings to the WiredTiger ``NoSQL''
b1e6b938 2119database.")
16973071
KB		 2120 (home-page "https://framagit.org/a-guile-mind/guile-wiredtiger")
2121 (license license:gpl3+)))
2122
90c2ee88
DM		 2123(define-public perl-db-file
2124 (package
2125 (name "perl-db-file")
76899e92 2126 (version "1.853")
90c2ee88
DM		 2127 (source
2128 (origin
2129 (method url-fetch)
76899e92
TGR		 2130 (uri (string-append "mirror://cpan/authors/id/P/PM/PMQS/DB_File-"
2131 version ".tar.gz"))
90c2ee88 2132 (sha256
76899e92 2133 (base32 "1y967si45vj0skip1hnhicbv9da29fv6qcfwnsbnvj06n36mkj6h"))))
90c2ee88
DM		 2134 (build-system perl-build-system)
2135 (inputs `(("bdb" ,bdb)))
2136 (native-inputs `(("perl-test-pod" ,perl-test-pod)))
2137 (arguments
2138 `(#:phases (modify-phases %standard-phases
2139 (add-before
2140 'configure 'modify-config.in
2141 (lambda* (#:key inputs #:allow-other-keys)
2142 (substitute* "config.in"
2143 (("/usr/local/BerkeleyDB") (assoc-ref inputs "bdb")))
2144 #t)))))
9aba9b12 2145 (home-page "https://metacpan.org/release/DB_File")
90c2ee88
DM		 2146 (synopsis
2147 "Perl5 access to Berkeley DB version 1.x")
2148 (description
2149 "The DB::File module provides Perl bindings to the Berkeley DB version 1.x.")
2f3108ad 2150 (license license:perl-license)))
0e1b262e
DC		 2151
2152(define-public lmdb
2153 (package
2154 (name "lmdb")
66c1613e 2155 (version "0.9.26")
f167b432
TGR		 2156 (source
2157 (origin
2158 (method git-fetch)
2159 (uri (git-reference
8fc6059b 2160 (url "https://git.openldap.org/openldap/openldap.git")
f167b432
TGR		 2161 (commit (string-append "LMDB_" version))))
2162 (file-name (git-file-name name version))
2163 (sha256
66c1613e 2164 (base32 "0323xwb2rqyrr9vr6gbxc2kl89drhqw0ifmyh9pg9qgqmymyhxdx"))))
0e1b262e
DC		 2165 (build-system gnu-build-system)
2166 (arguments
2167 `(#:test-target "test"
2168 #:phases
2169 (modify-phases %standard-phases
2170 (replace 'configure
2171 (lambda* (#:key outputs #:allow-other-keys)
f167b432 2172 (chdir "libraries/liblmdb")
0e1b262e
DC		 2173 (substitute* "Makefile"
2174 (("/usr/local") (assoc-ref outputs "out")))
2175 #t)))))
669fde53 2176 (home-page "https://symas.com/lmdb/")
fda852ff
TGR		 2177 (synopsis "Lightning Memory-Mapped Database library")
2178 (description
2179 "The @dfn{Lightning Memory-Mapped Database} (LMDB) is a high-performance
2180transactional database. Unlike more complex relational databases, LMDB handles
2181only key-value pairs (stored as arbitrary byte arrays) and relies on the
2182underlying operating system for caching and locking, keeping the code small and
2183simple.
2184The use of ‘zero-copy’ memory-mapped files combines the persistence of classic
2185disk-based databases with high read performance that scales linearly over
2186multiple cores. The size of each database is limited only by the size of the
2187virtual address space — not physical RAM.")
0e1b262e 2188 (license license:openldap2.8)))
fe71eee0 2189
659bc436 2190(define-public lmdbxx
2191 (package
2192 (name "lmdbxx")
2193 (version "0.9.14.0")
2194 (source
2195 (origin
2196 (method git-fetch)
2197 (uri (git-reference
b0e7b699 2198 (url "https://github.com/drycpp/lmdbxx")
659bc436 2199 (commit version)))
2200 (file-name (git-file-name name version))
2201 (sha256
2202 (base32 "1jmb9wg2iqag6ps3z71bh72ymbcjrb6clwlkgrqf1sy80qwvlsn6"))))
2203 (arguments
2204 `(#:make-flags
2205 (list (string-append "PREFIX=" (assoc-ref %outputs "out")))
2206 #:phases
2207 (modify-phases %standard-phases
2208 (delete 'configure))))
2209 (build-system gnu-build-system)
2210 (inputs `(("lmdb" ,lmdb)))
2211 (home-page "http://lmdbxx.sourceforge.net")
2212 (synopsis "C++11 wrapper for the LMDB embedded B+ tree database library")
2213 (description "@code{lmdbxx} is a comprehensive @code{C++} wrapper for the
2214@code{LMDB} embedded database library, offering both an error-checked
2215procedural interface and an object-oriented resource interface with RAII
2216semantics.")
2217 (license license:unlicense)))
2218
fe71eee0
JN		 2219(define-public libpqxx
2220 (package
2221 (name "libpqxx")
2222 (version "4.0.1")
2223 (source (origin
2224 (method url-fetch)
2225 (uri (string-append
2226 "http://pqxx.org/download/software/libpqxx/"
2227 name "-" version ".tar.gz"))
2228 (sha256
2229 (base32
2230 "0f6wxspp6rx12fkasanb0z2g2gc8dhcfwnxagx8wwqbpg6ifsz09"))))
2231 (build-system gnu-build-system)
2232 (native-inputs
2233 `(("python" ,python-2)))
2234 (inputs `(("postgresql" ,postgresql)))
2235 (arguments
5ac097e2
MB		 2236 `(#:tests? #f ; # FAIL: 1
2237 #:phases
2238 (modify-phases %standard-phases
2239 (add-before 'configure 'fix-sed-command
2240 (lambda _
2241 ;; Newer sed versions error out if double brackets are not used.
2242 (substitute* "configure"
2243 (("\\[:space:\\]") "[[:space:]]"))
2244 #t)))))
fe71eee0
JN		 2245 (synopsis "C++ connector for PostgreSQL")
2246 (description
2247 "Libpqxx is a C++ library to enable user programs to communicate with the
2248PostgreSQL database back-end. The database back-end can be local or it may be
2249on another machine, accessed via TCP/IP.")
2250 (home-page "http://pqxx.org/")
2251 (license license:bsd-3)))
4d98bfaf
EF		 2252
2253(define-public python-peewee
2254 (package
2255 (name "python-peewee")
f5edd85d 2256 (version "3.9.6")
4d98bfaf
EF		 2257 (source
2258 (origin
2259 (method url-fetch)
2260 (uri (pypi-uri "peewee" version))
2261 (sha256
2262 (base32
f5edd85d 2263 "1j4sh946k0736m7pd54z0y6i2hjhgg3kdllx1pwq8xkzzcgrx1xw"))))
4d98bfaf
EF		 2264 (build-system python-build-system)
2265 (arguments
2266 `(#:tests? #f)) ; Fails to import test data
2267 (native-inputs
2268 `(("python-cython" ,python-cython)))
2269 (home-page "https://github.com/coleifer/peewee/")
2270 (synopsis "Small object-relational mapping utility")
2271 (description
2272 "Peewee is a simple and small ORM (object-relation mapping) tool. Peewee
2273handles converting between pythonic values and those used by databases, so you
2274can use Python types in your code without having to worry. It has built-in
2275support for sqlite, mysql and postgresql. If you already have a database, you
2276can autogenerate peewee models using @code{pwiz}, a model generator.")
2277 (license license:expat)))
2278
2279(define-public python2-peewee
2280 (package-with-python2 python-peewee))
62ea44fc 2281
1110a421
LDB		 2282(define-public python-tortoise-orm
2283 (package
2284 (name "python-tortoise-orm")
b9d96ed7 2285 (version "0.16.7")
1110a421
LDB		 2286 (source
2287 (origin
2288 (method url-fetch)
2289 (uri (pypi-uri "tortoise-orm" version))
2290 (sha256
2291 (base32
b9d96ed7 2292 "0wr7p4v0b16ypm9fcpwpl99kf491m6w3jkd13xcsgq13fy73fbqc"))))
1110a421
LDB		 2293 (build-system python-build-system)
2294 ;; Disable tests for now. They pull in a lot of dependencies.
2295 (arguments `(#:tests? #f))
2296 (native-inputs
b9d96ed7 2297 `(("python-asynctest" ,python-asynctest)
1110a421
LDB		 2298 ("python-nose2" ,python-nose2)))
2299 (propagated-inputs
2300 `(("python-aiosqlite" ,python-aiosqlite)
2301 ("python-pypika" ,python-pypika)
b9d96ed7 2302 ("python-ciso8601" ,python-ciso8601)
1110a421
LDB		 2303 ("python-typing-extensions"
2304 ,python-typing-extensions)))
2305 (home-page
2306 "https://github.com/tortoise/tortoise-orm")
2307 (synopsis
2308 "Easy async ORM for python, built with relations in mind")
2309 (description
2310 "Tortoise ORM is an easy-to-use asyncio ORM (Object Relational Mapper)
2311inspired by Django. Tortoise ORM was build with relations in mind and
2312admiration for the excellent and popular Django ORM. It’s engraved in its
2313design that you are working not with just tables, you work with relational
2314data.")
2315 (license license:asl2.0)))
2316
62ea44fc
AP		 2317(define-public sqlcipher
2318 (package
2319 (name "sqlcipher")
682c2918 2320 (version "3.4.2")
62ea44fc
AP		 2321 (source
2322 (origin
2323 (method url-fetch)
2324 (uri (string-append "https://github.com/sqlcipher/" name
2325 "/archive/v" version ".tar.gz"))
2326 (sha256
682c2918 2327 (base32 "1nxarwbci8jx99f1d0y1ivxcv25s78l1p7q6qy28lkpkcx8pm2b9"))
62ea44fc
AP		 2328 (file-name (string-append name "-" version ".tar.gz"))))
2329 (build-system gnu-build-system)
2330 (inputs
2331 `(("libcrypto" ,openssl)
2332 ("libtcl8.6" ,tcl))) ; required for running the tests
2333 (native-inputs
2334 `(("tcl" ,tcl)))
2335 (arguments
2336 '(#:configure-flags
2337 '("--enable-tempstore=yes"
2338 "CFLAGS=-DSQLITE_HAS_CODEC -DSQLITE_ENABLE_FTS3"
2339 "LDFLAGS=-lcrypto -ltcl8.6"
2340 "--disable-tcl")
2341 ;; tests cannot be run from the Makefile
2342 ;; see: <https://github.com/sqlcipher/sqlcipher/issues/172>
2343 #:test-target "testfixture"
2344 #:phases
2345 (modify-phases %standard-phases
2346 (add-before 'check 'build-test-runner
2347 (assoc-ref %standard-phases 'check))
2348 (replace 'check
2349 (lambda _
96272e28 2350 (invoke "./testfixture" "test/crypto.test"))))))
62ea44fc
AP		 2351 (home-page "https://www.zetetic.net/sqlcipher/")
2352 (synopsis
2353 "Library providing transparent encryption of SQLite database files")
2354 (description "SQLCipher is an implementation of SQLite, extended to
2355provide transparent 256-bit AES encryption of database files. Pages are
2356encrypted before being written to disk and are decrypted when read back. It’s
2357well suited for protecting embedded application databases and for mobile
2358development.")
2359 ;; The source files
2360 ;; src/{crypto.c,crypto_impl.c,crypto.h,crypto_cc.c,crypto_libtomcrypt.c},
2361 ;; src/{crypto_openssl.c,sqlcipher.h}, tool/crypto-speedtest.tcl,
2362 ;; test/crypto.test are licensed under a 3-clause BSD license. All other
2363 ;; source files are in the public domain.
2364 (license (list license:public-domain license:bsd-3))))
98d403bb
DM		 2365
2366(define-public python-pyodbc-c
2367 (package
2368 (name "python-pyodbc-c")
c6b6a74e 2369 (version "3.1.4")
98d403bb
DM		 2370 (source
2371 (origin
2372 (method url-fetch)
2373 (uri (string-append "https://gitlab.com/daym/pyodbc-c/repository/"
2374 "archive.tar.gz?ref=v" version))
2375 (sha256
2376 (base32
c6b6a74e 2377 "05aq2297k779xidmxcwkrrxjvj1bh2q7d9a1rcjv6zr15y764ga9"))
98d403bb
DM		 2378 (file-name (string-append name "-" version ".tar.gz"))))
2379 (build-system python-build-system)
2380 (inputs
2381 `(("unixodbc" ,unixodbc)))
2382 (arguments
2383 `(;; No unit tests exist.
2384 #:tests? #f))
2385 (home-page "https://github.com/mkleehammer/pyodbc")
2386 (synopsis "Python ODBC Library")
2387 (description "@code{python-pyodbc-c} provides a Python DB-API driver
2388for ODBC.")
2389 (license (license:x11-style "file://LICENSE.TXT"))))
2390
2391(define-public python2-pyodbc-c
2392 (package-with-python2 python-pyodbc-c))
d39a84e8 2393
41916bea
DM		 2394(define-public python-pyodbc
2395 (package
2396 (name "python-pyodbc")
dbc8a6e7 2397 (version "4.0.30")
41916bea
DM		 2398 (source
2399 (origin
2400 (method url-fetch)
2401 (uri (pypi-uri "pyodbc" version))
2402 (sha256
dbc8a6e7 2403 (base32 "0skjpraar6hcwsy82612bpj8nw016ncyvvq88j5syrikxgp5saw5"))
41916bea
DM		 2404 (file-name (string-append name "-" version ".tar.gz"))))
2405 (build-system python-build-system)
2406 (inputs
2407 `(("unixodbc" ,unixodbc)))
2408 (arguments
d5be746a 2409 `(#:tests? #f)) ; no unit tests exist
41916bea
DM		 2410 (home-page "https://github.com/mkleehammer/pyodbc")
2411 (synopsis "Python ODBC Library")
2412 (description "@code{python-pyodbc} provides a Python DB-API driver
2413for ODBC.")
2414 (license (license:x11-style "file:///LICENSE.TXT"))))
2415
2416(define-public python2-pyodbc
2417 (package-with-python2 python-pyodbc))
2418
d39a84e8
AI		 2419(define-public mdbtools
2420 (package
2421 (name "mdbtools")
2422 (version "0.7.1")
2423 (source
2424 (origin
f1f1cebd
RW		 2425 (method git-fetch)
2426 (uri (git-reference
b0e7b699 2427 (url "https://github.com/brianb/mdbtools")
f1f1cebd
RW		 2428 (commit version)))
2429 (file-name (git-file-name name version))
d39a84e8
AI		 2430 (sha256
2431 (base32
f1f1cebd 2432 "0gwcpp9y09xhs21g7my2fs8ncb8i6ahlyixcx8jd3q97jbzj441l"))))
d39a84e8
AI		 2433 (build-system gnu-build-system)
2434 (inputs
2435 `(("glib" ,glib)))
2436 (native-inputs
2437 `(("autoconf" ,autoconf)
2438 ("automake" ,automake)
2439 ("libtool" ,libtool)
2440 ("pkg-config" ,pkg-config)
2441 ("txt2man" ,txt2man)
2442 ("which" ,which)))
d39a84e8
AI		 2443 (home-page "http://mdbtools.sourceforge.net/")
2444 (synopsis "Read Microsoft Access databases")
2445 (description "MDB Tools is a set of tools and applications to read the
2446proprietary MDB file format used in Microsoft's Access database package. This
2447includes programs to export schema and data from Microsoft's Access database
2448file format to other databases such as MySQL, Oracle, Sybase, PostgreSQL,
2449etc., and an SQL engine for performing simple SQL queries.")
2450 (license (list license:lgpl2.0
2451 license:gpl2+))))
07041d95
TGR		 2452
2453(define-public python-lmdb
2454 (package
2455 (name "python-lmdb")
ade5a616 2456 (version "0.99")
07041d95
TGR		 2457 (source (origin
2458 (method url-fetch)
2459 (uri (pypi-uri "lmdb" version))
2460 (sha256
2461 (base32
ade5a616 2462 "12fwlzfd82471ss9xzbqwcqc6f5miy51y72y2yya9j5cm9589szr"))
07041d95
TGR		 2463 (modules '((guix build utils)))
2464 (snippet
2465 ;; Delete bundled lmdb source files.
6cbee49d
MW		 2466 '(begin
2467 (for-each delete-file (list "lib/lmdb.h"
2468 "lib/mdb.c"
2469 "lib/midl.c"
2470 "lib/midl.h"))
2471 #t))))
07041d95
TGR		 2472 (build-system python-build-system)
2473 (inputs
2474 `(("lmdb" ,lmdb)))
2475 (arguments
2476 `(#:phases
2477 (modify-phases %standard-phases
2478 (add-before 'build 'use-system-lmdb
2479 (lambda* (#:key inputs #:allow-other-keys)
2480 (let ((lmdb (assoc-ref inputs "lmdb")))
2481 (setenv "LMDB_FORCE_SYSTEM" "set")
2482 (setenv "LMDB_INCLUDEDIR" (string-append lmdb "/include"))
2483 (setenv "LMDB_LIBDIR" (string-append lmdb "/lib"))
2484 #t))))
2485 ;; Tests fail with: ‘lmdb.tool: Please specify environment (--env)’.
2486 #:tests? #f))
2487 (home-page "https://github.com/dw/py-lmdb")
2488 (synopsis "Python binding for the ‘Lightning’ database (LMDB)")
2489 (description
2490 "python-lmdb or py-lmdb is a Python binding for the @dfn{Lightning
2491Memory-Mapped Database} (LMDB), a high-performance key-value store.")
2492 (license
2493 (list license:openldap2.8
2494 ;; ‘lib/win32/inttypes.h’ and ‘lib/win32-stdint/stdint.h’ are BSD-3,
2495 ;; but not actually needed on platforms currently supported by Guix.
2496 license:bsd-3))))
2497
da1f7a9e
BW		 2498(define-public python-orator
2499 (package
2500 (name "python-orator")
51d42caa 2501 (version "0.9.9")
da1f7a9e
BW		 2502 (source (origin
2503 (method url-fetch)
2504 (uri (pypi-uri "orator" version))
2505 (sha256
2506 (base32
51d42caa 2507 "0mbgybz63ryhr9p1f4glnls5c57jp6il3dw0kf97f3pj80687rvg"))))
da1f7a9e 2508 (build-system python-build-system)
51d42caa
MB		 2509 ;; FIXME: Tests are not distributed with PyPI, and the repository
2510 ;; does not contain setup.py. How to test?
2511 (arguments '(#:tests? #f))
da1f7a9e
BW		 2512 (propagated-inputs
2513 `(("python-backpack" ,python-backpack)
2514 ("python-blinker" ,python-blinker)
2515 ("python-cleo" ,python-cleo)
2516 ("python-faker" ,python-faker)
2517 ("python-inflection" ,python-inflection)
2518 ("python-lazy-object-proxy" ,python-lazy-object-proxy)
2519 ("python-pendulum" ,python-pendulum)
2520 ("python-pyaml" ,python-pyaml)
2521 ("python-pygments" ,python-pygments)
51d42caa 2522 ("python-pyyaml" ,python-pyyaml)
da1f7a9e
BW		 2523 ("python-simplejson" ,python-simplejson)
2524 ("python-six" ,python-six)
2525 ("python-wrapt" ,python-wrapt)))
2526 (home-page "https://orator-orm.com/")
2527 (synopsis "ActiveRecord ORM for Python")
2528 (description
2529 "Orator provides a simple ActiveRecord-like Object Relational Mapping
2530implementation for Python.")
2531 (license license:expat)
2532 (properties `((python2-variant . ,(delay python2-orator))))))
2533
2534(define-public python2-orator
2535 (package-with-python2 (strip-python2-variant python-orator)))
61ce0998
RJ		 2536
2537(define-public virtuoso-ose
2538 (package
2539 (name "virtuoso-ose")
e63da346 2540 (version "7.2.5")
61ce0998
RJ		 2541 (source
2542 (origin
2543 (method url-fetch)
2544 (uri (string-append
2545 "https://github.com/openlink/virtuoso-opensource/releases/"
2546 "download/v" version "/virtuoso-opensource-" version ".tar.gz"))
2547 (sha256
e63da346 2548 (base32 "0r1xakclkfi69pzh8z2k16z3x0m49pxp764icj0ad4w4bb97fr42"))))
61ce0998
RJ		 2549 (build-system gnu-build-system)
2550 (arguments
6d09a7b5
RJ		 2551 `(#:tests? #f ; Tests require a network connection.
2552 ;; TODO: Removing the libsrc/zlib source directory breaks the build.
2553 ;; This indicates that the internal zlib code may still be used.
2554 #:configure-flags '("--without-internal-zlib"
d26bf529
RJ		 2555 "--with-readline"
2556 "--enable-static=no")
2557 #:phases
2558 (modify-phases %standard-phases
2559 ;; Even with "--enable-static=no", "libvirtuoso-t.a" is left in
2560 ;; the build output. The following phase removes it.
2561 (add-after 'install 'remove-static-libs
2562 (lambda* (#:key outputs #:allow-other-keys)
2563 (let ((lib (string-append (assoc-ref outputs "out") "/lib")))
2564 (for-each (lambda (file)
2565 (delete-file (string-append lib "/" file)))
2566 '("libvirtuoso-t.a"
2567 "libvirtuoso-t.la"))))))))
61ce0998 2568 (inputs
95c633e0 2569 `(("openssl" ,openssl-1.0)
6d09a7b5
RJ		 2570 ("net-tools" ,net-tools)
2571 ("readline" ,readline)
2572 ("zlib" ,zlib)))
61ce0998
RJ		 2573 (home-page "http://vos.openlinksw.com/owiki/wiki/VOS/")
2574 (synopsis "Multi-model database system")
2575 (description "Virtuoso is a scalable cross-platform server that combines
2576relational, graph, and document data management with web application server
2577and web services platform functionality.")
48b68c61
EF		 2578 ;; configure: error: ... can only be build on 64bit platforms
2579 (supported-systems '("x86_64-linux" "mips64el-linux" "aarch64-linux"))
61ce0998 2580 (license license:gpl2)))
74248d22 2581
a8714bf6
RW		 2582(define-public python-ccm
2583 (package
2584 (name "python-ccm")
2585 (version "2.1.6")
2586 (source
2587 (origin
2588 (method url-fetch)
2589 (uri (pypi-uri "ccm" version))
2590 (sha256
2591 (base32
2592 "177dfxsmk3k4cih6fh6v8d91bh4nqx7ns6pc07w7m7i3cvdx3c8n"))))
2593 (build-system python-build-system)
2594 (propagated-inputs
2595 `(("python-pyyaml" ,python-pyyaml)
2596 ;; Not listed in setup.py, but used in ccmlib/node.py for full
2597 ;; functionality
2598 ("python-psutil" ,python-psutil)
2599 ("python-six" ,python-six)))
2600 (home-page "https://github.com/pcmanus/ccm")
2601 (synopsis "Cassandra Cluster Manager for Apache Cassandra clusters on
2602localhost")
2603 (description "Cassandra Cluster Manager is a development tool for testing
2604local Cassandra clusters. It creates, launches and removes Cassandra clusters
2605on localhost.")
2606 (license license:asl2.0)))
2607
2608(define-public python2-ccm
2609 (package-with-python2 python-ccm))
2610
2611(define-public python2-pysqlite
2612 (package
2613 (name "python2-pysqlite")
2614 (version "2.8.3")
2615 (source
2616 (origin
2617 (method url-fetch)
2618 (uri (pypi-uri "pysqlite" version))
2619 (sha256
2620 (base32
2621 "1424gwq9sil2ffmnizk60q36vydkv8rxs6m7xs987kz8cdc37lqp"))))
2622 (build-system python-build-system)
2623 (inputs
2624 `(("sqlite" ,sqlite)))
2625 (arguments
2626 `(#:python ,python-2 ; incompatible with Python 3
2627 #:tests? #f)) ; no test target
2628 (home-page "https://github.com/ghaering/pysqlite")
2629 (synopsis "SQLite bindings for Python")
2630 (description
2631 "Pysqlite provides SQLite bindings for Python that comply to the
2632Database API 2.0T.")
2633 (license license:zlib)))
2634
2635(define-public python-sqlalchemy
2636 (package
2637 (name "python-sqlalchemy")
fadc633a 2638 (version "1.3.18")
a8714bf6
RW		 2639 (source
2640 (origin
2641 (method url-fetch)
aeec4a8f 2642 (uri (pypi-uri "SQLAlchemy" version))
a8714bf6 2643 (sha256
fadc633a 2644 (base32 "1rwc6ss1cnz3kxx0p9p6xw0w79r8qw03lcc29k31yb3rcigvfbys"))))
a8714bf6
RW		 2645 (build-system python-build-system)
2646 (native-inputs
6d04f694 2647 `(("python-cython" ,python-cython) ; for C extensions
a8714bf6 2648 ("python-pytest" ,python-pytest)
6d04f694 2649 ("python-mock" ,python-mock))) ; for tests
a8714bf6
RW		 2650 (arguments
2651 `(#:phases
2652 (modify-phases %standard-phases
2653 (replace 'check
9871a896 2654 (lambda _ (invoke "py.test"))))))
5cfe650b 2655 (home-page "https://www.sqlalchemy.org")
a8714bf6
RW		 2656 (synopsis "Database abstraction library")
2657 (description
2658 "SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that
2659gives application developers the full power and flexibility of SQL. It
2660provides a full suite of well known enterprise-level persistence patterns,
2661designed for efficient and high-performing database access, adapted into a
2662simple and Pythonic domain language.")
2663 (license license:x11)))
2664
2665(define-public python2-sqlalchemy
2666 (package-with-python2 python-sqlalchemy))
2667
2668(define-public python-sqlalchemy-utils
2669 (package
2670 (name "python-sqlalchemy-utils")
53ae35e4 2671 (version "0.32.21")
a8714bf6
RW		 2672 (source
2673 (origin
2674 (method url-fetch)
2675 (uri (pypi-uri "SQLAlchemy-Utils" version))
2676 (sha256
2677 (base32
53ae35e4 2678 "1myn71dn8j74xglyh46f12sh8ywb7j0j732rzwq70kvwwnq32m73"))))
a8714bf6
RW		 2679 (build-system python-build-system)
2680 (arguments
2681 '(#:tests? #f)) ; FIXME: Many tests require a running database server.
2682 ;; #:phases
2683 ;; (modify-phases %standard-phases
2684 ;; (replace 'check
2685 ;; (lambda _
2686 ;; (zero? (system* "py.test" "sqlalchemy_utils" "tests")))))
2687 (propagated-inputs
2688 `(("python-six" ,python-six)
2689 ("python-sqlalchemy" ,python-sqlalchemy)))
2690 (native-inputs
2691 `(("python-dateutil" ,python-dateutil)
2692 ("python-flexmock" ,python-flexmock)
2693 ("python-psycopg2" ,python-psycopg2)
2694 ("python-pytest" ,python-pytest)
2695 ("python-pytz" ,python-pytz)))
2696 (home-page "https://github.com/kvesteri/sqlalchemy-utils")
2697 (synopsis "Various utility functions for SQLAlchemy")
2698 (description
2699 "SQLAlchemy-utils provides various utility functions and custom data types
2700for SQLAlchemy. SQLAlchemy is an SQL database abstraction library for Python.
2701
2702You might also want to install the following optional dependencies:
2703@enumerate
2704@item @code{python-passlib}
2705@item @code{python-babel}
2706@item @code{python-cryptography}
2707@item @code{python-pytz}
2708@item @code{python-psycopg2}
2709@item @code{python-furl}
2710@item @code{python-flask-babel}
2711@end enumerate
2712")
2713 (license license:bsd-3)))
2714
2715(define-public python2-sqlalchemy-utils
2716 (package-with-python2 python-sqlalchemy-utils))
2717
de84d3b1
MB		 2718(define-public python-alchemy-mock
2719 (package
2720 (name "python-alchemy-mock")
2721 (version "0.4.3")
2722 (home-page "https://github.com/miki725/alchemy-mock")
2723 (source (origin
2724 (method url-fetch)
2725 (uri (pypi-uri "alchemy-mock" version))
2726 (sha256
2727 (base32
2728 "0ylxygl3bcdapzz529n8wgk7vx9gjwb3ism564ypkpd7dbsw653r"))))
2729 (build-system python-build-system)
2730 (arguments
2731 '(#:phases (modify-phases %standard-phases
2732 (replace 'check
2733 (lambda _
2734 ;; Create pytest.ini that adds doctest options to
2735 ;; prevent test failure. Taken from tox.ini.
2736 (call-with-output-file "pytest.ini"
2737 (lambda (port)
2738 (format port "[pytest]
2739doctest_optionflags=IGNORE_EXCEPTION_DETAIL
2740")))
2741 (invoke "pytest" "-vv" "--doctest-modules"
2742 "alchemy_mock/"))))))
2743 (native-inputs
2744 `(("python-mock" ,python-mock)
2745 ("python-pytest" ,python-pytest)))
2746 (propagated-inputs
2747 `(("python-six" ,python-six)
2748 ("python-sqlalchemy" ,python-sqlalchemy)))
2749 (synopsis "Mock helpers for SQLAlchemy")
2750 (description
2751 "This package provides mock helpers for SQLAlchemy that makes it easy
2752to mock an SQLAlchemy session while preserving the ability to do asserts.
2753
2754Normally Normally SQLAlchemy's expressions cannot be easily compared as
2755comparison on binary expression produces yet another binary expression, but
2756this library provides functions to facilitate such comparisons.")
2757 (license license:expat)))
2758
a8714bf6
RW		 2759(define-public python-alembic
2760 (package
2761 (name "python-alembic")
007000ac 2762 (version "1.4.2")
a8714bf6
RW		 2763 (source
2764 (origin
2765 (method url-fetch)
2766 (uri (pypi-uri "alembic" version))
2767 (sha256
007000ac 2768 (base32 "1gsdrzx9h7wfva200qvvsc9sn4w79mk2vs0bbnzjhxi1jw2b0nh3"))))
a8714bf6 2769 (build-system python-build-system)
45ebd90c
MB		 2770 (arguments
2771 '(#:phases (modify-phases %standard-phases
2772 (replace 'check
2773 (lambda _
2774 (invoke "pytest" "-vv"))))))
a8714bf6
RW		 2775 (native-inputs
2776 `(("python-mock" ,python-mock)
2777 ("python-pytest-cov" ,python-pytest-cov)))
2778 (propagated-inputs
2779 `(("python-dateutil" ,python-dateutil)
2780 ("python-sqlalchemy" ,python-sqlalchemy)
2781 ("python-mako" ,python-mako)
2782 ("python-editor" ,python-editor)))
a7f27da7 2783 (home-page "https://bitbucket.org/zzzeek/alembic")
6743080c 2784 (synopsis "Database migration tool for SQLAlchemy")
a8714bf6
RW		 2785 (description
2786 "Alembic is a lightweight database migration tool for usage with the
2787SQLAlchemy Database Toolkit for Python.")
2788 (license license:expat)))
2789
2790(define-public python2-alembic
2791 (package-with-python2 python-alembic))
2792
2793(define-public python-pickleshare
2794 (package
2795 (name "python-pickleshare")
f825faa5 2796 (version "0.7.5")
a8714bf6
RW		 2797 (source
2798 (origin
2799 (method url-fetch)
ed519b3c 2800 (uri (pypi-uri "pickleshare" version))
a8714bf6 2801 (sha256
f825faa5 2802 (base32 "1jmghg3c53yp1i8cm6pcrm280ayi8621rwyav9fac7awjr3kss47"))))
a8714bf6 2803 (build-system python-build-system)
ff856cfd
MB		 2804 (arguments
2805 `(#:phases (modify-phases %standard-phases
2806 (replace 'check
2807 (lambda _
2808 (invoke "pytest"))))))
2809 (native-inputs
2810 `(("python-pytest" ,python-pytest)))
a8714bf6
RW		 2811 (home-page "https://github.com/vivainio/pickleshare")
2812 (synopsis "Tiny key value database with concurrency support")
2813 (description
2814 "PickleShare is a small ‘shelve’-like datastore with concurrency support.
2815Like shelve, a PickleShareDB object acts like a normal dictionary. Unlike
2816shelve, many processes can access the database simultaneously. Changing a
2817value in database is immediately visible to other processes accessing the same
2818database. Concurrency is possible because the values are stored in separate
2819files. Hence the “database” is a directory where all files are governed by
2820PickleShare.")
ed519b3c 2821 (properties `((python2-variant . ,(delay python2-pickleshare))))
a8714bf6
RW		 2822 (license license:expat)))
2823
2824(define-public python2-pickleshare
ed519b3c
MB		 2825 (let ((pickleshare (package-with-python2
2826 (strip-python2-variant python-pickleshare))))
2827 (package (inherit pickleshare)
2828 (propagated-inputs `(("python2-pathlib2" ,python2-pathlib2)
2829 ,@(package-propagated-inputs pickleshare))))))
a8714bf6
RW		 2830
2831(define-public python-apsw
2832 (package
2833 (name "python-apsw")
d05e3b08 2834 (version "3.31.1-r1")
a8714bf6
RW		 2835 (source
2836 (origin
2837 (method url-fetch)
9930beb8
EF		 2838 (uri (string-append "https://github.com/rogerbinns/apsw/releases"
2839 "/download/" version "/apsw-" version ".zip"))
a8714bf6
RW		 2840 (sha256
2841 (base32
d05e3b08 2842 "1gap5lr6c7bp134nzvfwr693i6d0fqyaysg3ms2cayjldv616yfx"))))
a8714bf6 2843 (build-system python-build-system)
9930beb8
EF		 2844 (native-inputs
2845 `(("unzip" ,unzip)))
a8714bf6 2846 (inputs
c553b08b 2847 `(("sqlite" ,sqlite)))
a8714bf6
RW		 2848 (arguments
2849 `(#:phases
2850 (modify-phases %standard-phases
2851 (replace 'build
2852 (lambda _
c553b08b
EF		 2853 (invoke "python" "setup.py" "build" "--enable-all-extensions")
2854 #t))
a8714bf6
RW		 2855 (add-after 'build 'build-test-helper
2856 (lambda _
c553b08b
EF		 2857 (invoke "gcc" "-fPIC" "-shared" "-o" "./testextension.sqlext"
2858 "-I." "-Isqlite3" "src/testextension.c")
2859 #t))
53a9970e 2860 (replace 'check
a8714bf6
RW		 2861 (lambda* (#:key inputs outputs #:allow-other-keys)
2862 (add-installed-pythonpath inputs outputs)
c553b08b
EF		 2863 (invoke "python" "setup.py" "test")
2864 #t)))))
a8714bf6
RW		 2865 (home-page "https://github.com/rogerbinns/apsw/")
2866 (synopsis "Another Python SQLite Wrapper")
2867 (description "APSW is a Python wrapper for the SQLite
2868embedded relational database engine. In contrast to other wrappers such as
2869pysqlite it focuses on being a minimal layer over SQLite attempting just to
2870translate the complete SQLite API into Python.")
2871 (license license:zlib)))
2872
2873(define-public python2-apsw
2874 (package-with-python2 python-apsw))
2875
ba0b249d
LDB		 2876(define-public python-aiosqlite
2877 (package
2878 (name "python-aiosqlite")
4b800bff 2879 (version "0.12.0")
ba0b249d
LDB		 2880 (source
2881 (origin
2882 (method url-fetch)
2883 (uri (pypi-uri "aiosqlite" version))
2884 (sha256
2885 (base32
4b800bff 2886 "1w8248yz85xyzvvh4jaxnc59fqil45aka6h82kn1rcih4rjxbnn1"))))
ba0b249d
LDB		 2887 (build-system python-build-system)
2888 (native-inputs
2889 `(("python-aiounittest" ,python-aiounittest)))
2890 (home-page "https://github.com/jreese/aiosqlite")
2891 (synopsis
2892 "Asyncio bridge for sqlite3")
2893 (description
2894 "The package aiosqlite replicates the standard sqlite3 module, but with
2895async versions of all the standard connection and cursor methods, and context
2896managers for automatically closing connections.")
2897 (license license:expat)))
2898
a8714bf6
RW		 2899(define-public python2-neo4j-driver
2900 (package
2901 (name "python2-neo4j-driver")
2902 ;; NOTE: When upgrading to 1.5.0, please add a python3 variant.
2903 (version "1.4.0")
2904 (source (origin
2905 (method url-fetch)
2906 (uri (pypi-uri "neo4j-driver" version))
2907 (sha256
2908 (base32
2909 "011r1vh182p8mm83d8dz9rfnc3l7rf7fd00cyrbyfzi71jmc4g98"))))
2910 (build-system python-build-system)
2911 (arguments
2912 `(#:python ,python-2))
2913 (home-page "https://neo4j.com/developer/python/")
2914 (synopsis "Neo4j driver code written in Python")
2915 (description "This package provides the Neo4j Python driver that connects
2916to the database using Neo4j's binary protocol. It aims to be minimal, while
2917being idiomatic to Python.")
2918 (license license:asl2.0)))
2919
2920(define-public python2-py2neo
2921 (package
2922 (name "python2-py2neo")
2923 (version "3.1.2")
2924 (source (origin
2925 (method url-fetch)
2926 (uri (pypi-uri "py2neo" version))
2927 (sha256
2928 (base32
2929 "1f1q95vqcvlc3nsc33p841swnjdcjazddlq2dzi3qfnjqjrajxw1"))))
2930 (build-system python-build-system)
2931 (arguments
2932 `(#:python ,python-2))
1084e86b 2933 (home-page "https://py2neo.org")
a8714bf6
RW		 2934 (synopsis "Library and toolkit for working with Neo4j in Python")
2935 (description "This package provides a client library and toolkit for
2936working with Neo4j from within Python applications and from the command
2937line. The core library has no external dependencies and has been carefully
2938designed to be easy and intuitive to use.")
2939 (license license:asl2.0)))
2940
2941(define-public python-psycopg2
2942 (package
2943 (name "python-psycopg2")
dc2f0e70 2944 (version "2.8.6")
a8714bf6
RW		 2945 (source
2946 (origin
2947 (method url-fetch)
2948 (uri (pypi-uri "psycopg2" version))
2949 (sha256
dc2f0e70 2950 (base32 "0hzmk6b1hb5riqkljr5xics6p4zbvmis6knbczb7zhq7273zc8zv"))))
a8714bf6
RW		 2951 (build-system python-build-system)
2952 (arguments
2953 ;; Tests would require a postgresql database "psycopg2_test"
2954 ;; and a running postgresql database management service.
2955 `(#:tests? #f)) ; TODO re-enable after providing a test-db.
2956 (inputs
2957 `(("postgresql" ,postgresql))) ; libpq
2958 (home-page "http://initd.org/psycopg/")
2959 (synopsis "Python PostgreSQL adapter")
2960 (description
19601e89
BW		 2961 "psycopg2 is a thread-safe PostgreSQL adapter that implements DB-API
29622.0.")
a8714bf6
RW		 2963 (license license:lgpl3+)))
2964
2965(define-public python2-psycopg2
2966 (package-with-python2 python-psycopg2))
2967
2968(define-public python-sadisplay
2969 (package
2970 (name "python-sadisplay")
bcdc5cae 2971 (version "0.4.8")
a8714bf6
RW		 2972 (source
2973 (origin
2974 (method url-fetch)
2975 (uri (pypi-uri "sadisplay" version))
2976 (sha256
2977 (base32
bcdc5cae 2978 "01d9lxhmgpb68gy8rd6zj6fcwp84n2qq210n1qsk3qbsir79bzh4"))))
a8714bf6
RW		 2979 (build-system python-build-system)
2980 (propagated-inputs
2981 `(("python-sqlalchemy" ,python-sqlalchemy)))
2982 (native-inputs
bcdc5cae 2983 ;; For tests.
a8714bf6
RW		 2984 `(("python-nose" ,python-nose)))
2985 (home-page "https://bitbucket.org/estin/sadisplay")
2986 (synopsis "SQLAlchemy schema displayer")
2987 (description "This package provides a program to build Entity
2988Relationship diagrams from a SQLAlchemy model (or directly from the
2989database).")
2990 (license license:bsd-3)))
2991
2992(define-public python2-sadisplay
2993 (package-with-python2 python-sadisplay))
2994
2995(define-public python-mysqlclient
2996 (package
2997 (name "python-mysqlclient")
28635e52 2998 (version "1.3.13")
a8714bf6
RW		 2999 (source
3000 (origin
3001 (method url-fetch)
3002 (uri (pypi-uri "mysqlclient" version))
3003 (sha256
3004 (base32
28635e52 3005 "0kv4a1icwdav8jpl7qvnr931lw5h3v22ids6lwq6qpi1hjzf33pz"))))
a8714bf6
RW		 3006 (build-system python-build-system)
3007 (native-inputs
f94051e6 3008 `(("nose" ,python-nose)
a8714bf6
RW		 3009 ("mock" ,python-mock)
3010 ("py.test" ,python-pytest)))
3011 (inputs
2b8491fb
JL		 3012 `(("mysql" ,mariadb "lib")
3013 ("mysql-dev" ,mariadb "dev")
a8714bf6
RW		 3014 ("libz" ,zlib)
3015 ("openssl" ,openssl)))
3016 (home-page "https://github.com/PyMySQL/mysqlclient-python")
3017 (synopsis "MySQLdb is an interface to the popular MySQL database server for Python")
3018 (description "MySQLdb is an interface to the popular MySQL database server
3019for Python. The design goals are:
3020@enumerate
3021@item Compliance with Python database API version 2.0 [PEP-0249],
3022@item Thread-safety,
3023@item Thread-friendliness (threads will not block each other).
3024@end enumerate")
3025 (license license:gpl2)))
3026
a8714bf6
RW		 3027(define-public python-hiredis
3028 (package
3029 (name "python-hiredis")
3030 (version "0.2.0")
3031 (source
3032 (origin
3033 (method url-fetch)
3034 (uri (pypi-uri "hiredis" version))
3035 (sha256
3036 (base32
3037 "1dfm2k9l9zar9nw9fwmm74zrgraxdxs04vx9li56fjcf289qx5fa"))))
3038 (build-system python-build-system)
3039 (arguments
3040 ;; no tests
3041 `(#:tests? #f))
3042 (home-page "https://github.com/redis/hiredis-py")
3043 (synopsis "Python extension that wraps protocol parsing code in hiredis")
3044 (description "Python-hiredis is a python extension that wraps protocol
3045parsing code in hiredis. It primarily speeds up parsing of multi bulk replies.")
3046 (license license:bsd-3)))
3047
3048(define-public python2-hiredis
3049 (package-with-python2 python-hiredis))
3050
3051(define-public python-fakeredis
3052 (package
3053 (name "python-fakeredis")
1655e7be 3054 (version "1.2.1")
a8714bf6
RW		 3055 (source
3056 (origin
3057 (method url-fetch)
3058 (uri (pypi-uri "fakeredis" version))
3059 (sha256
3060 (base32
1655e7be 3061 "1s12mn4q4hz7402139khn9fx56kibj7nn0d6w81hn0zs07b90wpc"))))
a8714bf6
RW		 3062 (build-system python-build-system)
3063 (arguments
3064 ;; no tests
3065 `(#:tests? #f))
1655e7be
TLC		 3066 (propagated-inputs
3067 `(("python-sortedcontainers" ,python-sortedcontainers)))
a8714bf6
RW		 3068 (home-page "https://github.com/jamesls/fakeredis")
3069 (synopsis "Fake implementation of redis API for testing purposes")
a4764ff0
TGR		 3070 (description
3071 "Fakeredis is a pure-Python implementation of the redis-py Python client
3072that simulates talking to a redis server. It was created for a single purpose:
3073to write unit tests.
3074
3075Setting up redis is not hard, but one often wants to write unit tests that don't
3076talk to an external server such as redis. This module can be used as a
3077reasonable substitute.")
a8714bf6
RW		 3078 (license license:bsd-3)))
3079
3080(define-public python2-fakeredis
3081 (package-with-python2 python-fakeredis))
3082
3083(define-public python-redis
3084 (package
3085 (name "python-redis")
d87252e6 3086 (version "3.5.3")
a8714bf6
RW		 3087 (source
3088 (origin
3089 (method url-fetch)
3090 (uri (pypi-uri "redis" version))
3091 (sha256
d87252e6 3092 (base32 "18h5b87g15x3j6pb1h2q27ri37p2qpvc9n2wgn5yl3b6m3y0qzhf"))))
a8714bf6 3093 (build-system python-build-system)
a263a976 3094 ;; Tests require a running Redis server.
a8714bf6
RW		 3095 (arguments '(#:tests? #f))
3096 ;; As long as we are not running test, we do not need this input :-)
3097 ;;(native-inputs
3098 ;; `(("python-pytest" ,python-pytest)))
3099 (home-page "https://github.com/andymccurdy/redis-py")
3100 (synopsis "Redis Python client")
3101 (description
3102 "This package provides a Python interface to the Redis key-value store.")
3103 (license license:expat)))
3104
3105(define-public python2-redis
3106 (package-with-python2 python-redis))
3107
3108(define-public python-rq
3109 (package
3110 (name "python-rq")
b462caaf 3111 (version "1.5.1")
a8714bf6
RW		 3112 (source
3113 (origin
b462caaf
MB		 3114 (method git-fetch)
3115 (uri (git-reference
3116 (url "https://github.com/rq/rq")
3117 (commit (string-append "v" version))))
3118 (file-name (git-file-name name version))
a8714bf6 3119 (sha256
b462caaf 3120 (base32 "0i7yyw828wdvl7ap4gb7jhm4p94502is3xxrgrdgwwp0l1rac004"))))
a8714bf6 3121 (build-system python-build-system)
b462caaf
MB		 3122 (arguments
3123 '(#:phases (modify-phases %standard-phases
3124 (add-before 'check 'start-redis
3125 (lambda _
3126 (invoke "redis-server" "--daemonize" "yes")))
3127 (replace 'check
3128 (lambda* (#:key outputs #:allow-other-keys)
3129 (let ((out (assoc-ref outputs "out")))
3130 ;; Drop test that needs the SDK for Sentry.io.
3131 (delete-file "tests/test_sentry.py")
3132 ;; Ensure 'rq' and 'rqworker' ends up on PATH.
3133 (setenv "PATH" (string-append out "/bin:"
3134 (getenv "PATH")))
3135 (invoke "pytest" "-vv")))))))
3136 (native-inputs
3137 `(("python-mock" ,python-mock)
3138 ("python-pytest" ,python-pytest)
3139 ("redis" ,redis)))
a8714bf6
RW		 3140 (propagated-inputs
3141 `(("python-click" ,python-click)
3142 ("python-redis" ,python-redis)))
4e5ad79e 3143 (home-page "https://python-rq.org/")
a8714bf6
RW		 3144 (synopsis "Simple job queues for Python")
3145 (description
3146 "RQ (Redis Queue) is a simple Python library for queueing jobs and
3147processing them in the background with workers. It is backed by Redis and it
3148is designed to have a low barrier to entry.")
3149 (license license:bsd-2)))
3150
3151(define-public python2-rq
3152 (package-with-python2 python-rq))
3153
8a88efce
MB		 3154(define-public python-rq-scheduler
3155 (package
3156 (name "python-rq-scheduler")
3157 (version "0.10.0")
3158 (home-page "https://github.com/rq/rq-scheduler")
3159 (source (origin
3160 (method git-fetch)
3161 (uri (git-reference
3162 (url home-page)
3163 (commit (string-append "v" version))))
3164 (file-name (git-file-name name version))
3165 (sha256
3166 (base32
3167 "0xg6yazqs5kbr2ayvhvljs1h5vgx5k5dds613fmhswln7gglf9hk"))))
3168 (build-system python-build-system)
3169 (arguments
3170 '(#:phases (modify-phases %standard-phases
3171 (add-before 'check 'start-redis
3172 (lambda _
3173 (invoke "redis-server" "--daemonize" "yes")))
3174 (replace 'check
3175 (lambda _
3176 (substitute* "run_tests.py"
3177 (("/usr/bin/env")
3178 (which "env")))
3179 (invoke "./run_tests.py"))))))
3180 (native-inputs
3181 `(("redis" ,redis)
3182 ("which" ,which)))
3183 (propagated-inputs
3184 `(("python-croniter" ,python-croniter)
3185 ("python-rq" ,python-rq)))
3186 (synopsis "Job scheduling capabilities for RQ (Redis Queue)")
3187 (description
3188 "This package provides job scheduling capabilities to @code{python-rq}
3189(Redis Queue).")
3190 (license license:expat)))
3191
a8714bf6
RW		 3192(define-public python-trollius-redis
3193 (package
3194 (name "python-trollius-redis")
3195 (version "0.1.4")
3196 (source
3197 (origin
3198 (method url-fetch)
3199 (uri (pypi-uri "trollius_redis" version))
3200 (sha256
3201 (base32
3202 "0k3vypszmgmaipgw9xscvgm79h2zd6p6ci8gdp5sxl6g5kbqr9fy"))))
3203 (build-system python-build-system)
3204 ;; TODO: Tests require packaging 'hiredis'.
3205 (arguments '(#:tests? #f))
3206 (home-page "https://github.com/benjolitz/trollius-redis")
3207 (synopsis "Port of asyncio-redis to trollius")
3208 (description "@code{trollius-redis} is a Redis client for Python
d087a3a6 3209 trollius. It is an asynchronous IO (PEP 3156) implementation of the
a8714bf6
RW		 3210 Redis protocol.")
3211 (license license:bsd-2)))
3212
3213(define-public python2-trollius-redis
3214 (package-with-python2 python-trollius-redis))
3215
3216(define-public python-sqlparse
3217 (package
3218 (name "python-sqlparse")
d343e0fe 3219 (version "0.3.1")
a8714bf6
RW		 3220 (source (origin
3221 (method url-fetch)
3222 (uri (pypi-uri "sqlparse" version))
3223 (sha256
3224 (base32
d343e0fe 3225 "0j652a6z7bdf6c77aczfn8m8b2nsr1bcqq48wzghf8vi6wvj0qp1"))))
a8714bf6
RW		 3226 (build-system python-build-system)
3227 (arguments
3228 `(#:phases
3229 (modify-phases %standard-phases
3230 (replace 'check
96272e28 3231 (lambda _ (invoke "py.test"))))))
a8714bf6
RW		 3232 (native-inputs
3233 `(("python-pytest" ,python-pytest)))
3234 (home-page "https://github.com/andialbrecht/sqlparse")
3235 (synopsis "Non-validating SQL parser")
3236 (description "Sqlparse is a non-validating SQL parser for Python. It
3237provides support for parsing, splitting and formatting SQL statements.")
3238 (license license:bsd-3)))
3239
3240(define-public python2-sqlparse
3241 (package-with-python2 python-sqlparse))
3242
3243(define-public python-sql
3244 (package
3245 (name "python-sql")
909404b5 3246 (version "1.0.0")
a8714bf6
RW		 3247 (source
3248 (origin
3249 (method url-fetch)
3250 (uri (pypi-uri "python-sql" version))
3251 (sha256
909404b5 3252 (base32 "05ni936y0ia9xmryl7mlhbj9i80nnvq1bi4zxhb96rv7yvpb3fqb"))))
a8714bf6
RW		 3253 (build-system python-build-system)
3254 (home-page "https://python-sql.tryton.org/")
3255 (synopsis "Library to write SQL queries in a pythonic way")
3256 (description "@code{python-sql} is a library to write SQL queries, that
3257transforms idiomatic python function calls to well-formed SQL queries.")
3258 (license license:bsd-3)))
3259
3260(define-public python2-sql
3261 (package-with-python2 python-sql))
33c88fcb 3262
c8fdf86d
LDB		 3263(define-public python-pypika
3264 (package
3265 (name "python-pypika")
510472f8 3266 (version "0.37.2")
c8fdf86d 3267 (source
510472f8
LDB		 3268 (origin (method git-fetch)
3269 (uri (git-reference
b0e7b699 3270 (url "https://github.com/kayak/pypika")
510472f8
LDB		 3271 (commit (string-append "v" version))))
3272 (file-name (git-file-name name version))
3273 (sha256
3274 (base32
3275 "089z1c778q1fwhzsc88ws8j5gm2hgxknibabn4wpax8rz2bfs3ck"))))
c8fdf86d
LDB		 3276 (build-system python-build-system)
3277 (native-inputs
3278 `(("python-parameterized" ,python-parameterized)))
3279 (home-page "https://github.com/kayak/pypika")
3280 (synopsis "SQL query builder API for Python")
3281 (description
3282 "PyPika is a python SQL query builder that exposes the full richness of
3283the SQL language using a syntax that reflects the resulting query.")
3284 (license license:asl2.0)))
3285
33c88fcb
CB		 3286(define-public mongo-tools
3287 (package
3288 (name "mongo-tools")
3289 (version "3.4.0")
3290 (source
3291 (origin (method git-fetch)
3292 (uri (git-reference
3293 (url "https://github.com/mongodb/mongo-tools")
3294 (commit (string-append "r" version))))
3295 (file-name (git-file-name name version))
3296 (sha256
3297 (base32
9b32bf6e 3298 "1bcsz5cvj39a7nsxsfqmz9igrw33j6yli9kffigqyscs52amw7x1"))))
33c88fcb
CB		 3299 (build-system go-build-system)
3300 (arguments
9b32bf6e
CB		 3301 `(#:import-path "github.com/mongodb/mongo-tools"
3302 #:modules ((srfi srfi-1)
3303 (guix build go-build-system)
3304 (guix build utils))
e3900a4d 3305 #:install-source? #f
33c88fcb 3306 #:phases
9b32bf6e
CB		 3307 (let ((all-tools
3308 '("bsondump" "mongodump" "mongoexport" "mongofiles"
3309 "mongoimport" "mongooplog" "mongorestore"
3310 "mongostat" "mongotop")))
3311 (modify-phases %standard-phases
3312 (add-after 'unpack 'delete-bundled-source-code
3313 (lambda _
3314 (delete-file-recursively
3315 "src/github.com/mongodb/mongo-tools/vendor")
3316 #t))
fe596965
CB		 3317 (add-after 'delete-bundled-source-code 'patch-source
3318 (lambda _
3319 ;; Remove a redundant argument that causes compilation to fail.
3320 (substitute*
3321 "src/github.com/mongodb/mongo-tools/mongorestore/filepath.go"
3322 (("skipping restore of system.profile collection\", db)")
3323 "skipping restore of system.profile collection\")"))
3324 #t))
9b32bf6e
CB		 3325 (replace 'build
3326 (lambda _
96272e28
MW		 3327 (for-each (lambda (tool)
3328 (let ((command
3329 `("go" "build"
3330 ;; This is where the tests expect to find the
3331 ;; executables
3332 "-o" ,(string-append
3333 "src/github.com/mongodb/mongo-tools/bin/"
3334 tool)
3335 "-v"
3336 "-tags=\"ssl sasl\""
3337 "-ldflags"
3338 "-extldflags=-Wl,-z,now,-z,relro"
3339 ,(string-append
3340 "src/github.com/mongodb/mongo-tools/"
3341 tool "/main/" tool ".go"))))
3342 (simple-format #t "build: running ~A\n"
3343 (string-join command))
3344 (apply invoke command)))
3345 all-tools)
3346 #t))
9b32bf6e
CB		 3347 (replace 'check
3348 (lambda _
3349 (with-directory-excursion "src"
96272e28
MW		 3350 (for-each (lambda (tool)
3351 (invoke
3352 "go" "test" "-v"
3353 (string-append "github.com/mongodb/mongo-tools/"
3354 tool)))
3355 all-tools))
3356 #t))
9b32bf6e
CB		 3357 (replace 'install
3358 (lambda* (#:key outputs #:allow-other-keys)
3359 (for-each (lambda (tool)
3360 (install-file
96272e28
MW		 3361 (string-append "src/github.com/mongodb/mongo-tools/bin/"
3362 tool)
9b32bf6e
CB		 3363 (string-append (assoc-ref outputs "out")
3364 "/bin")))
96272e28
MW		 3365 all-tools)
3366 #t))))))
33c88fcb
CB		 3367 (native-inputs
3368 `(("go-github.com-howeyc-gopass" ,go-github.com-howeyc-gopass)
3369 ("go-github.com-jessevdk-go-flags" ,go-github.com-jessevdk-go-flags)
561d391b 3370 ("go-golang-org-x-crypto" ,go-golang-org-x-crypto)
33c88fcb
CB		 3371 ("go-gopkg.in-mgo.v2" ,go-gopkg.in-mgo.v2)
3372 ("go-gopkg.in-tomb.v2" ,go-gopkg.in-tomb.v2)
9b32bf6e
CB		 3373 ("go-github.com-nsf-termbox-go" ,go-github.com-nsf-termbox-go)
3374 ("go-github.com-smartystreets-goconvey" ,go-github.com-smartystreets-goconvey)))
33c88fcb
CB		 3375 (home-page "https://github.com/mongodb/mongo-tools")
3376 (synopsis "Various tools for interacting with MongoDB and BSON")
3377 (description
3378 "This package includes a collection of tools related to MongoDB.
3379@table @code
3380@item bsondump
3381Display BSON files in a human-readable format
3382@item mongoimport
3383Convert data from JSON, TSV or CSV and insert them into a collection
3384@item mongoexport
3385Write an existing collection to CSV or JSON format
3386@item mongodump/mongorestore
3387Dump MongoDB backups to disk in the BSON format
3388@item mongorestore
3389Read MongoDB backups in the BSON format, and restore them to a live database
3390@item mongostat
3391Monitor live MongoDB servers, replica sets, or sharded clusters
3392@item mongofiles
3393Read, write, delete, or update files in GridFS
3394@item mongooplog
3395Replay oplog entries between MongoDB servers
3396@item mongotop
3397Monitor read/write activity on a mongo server
3398@end table")
3399 (license license:asl2.0)))
dae7661a 3400
a50628bb
KCB		 3401;; There are many wrappers for this in other languages. When touching, please
3402;; be sure to ensure all dependencies continue to build.
dae7661a
LF		 3403(define-public apache-arrow
3404 (package
3405 (name "apache-arrow")
a50628bb 3406 (version "0.17.1")
dae7661a 3407 (source
a50628bb
KCB		 3408 (origin
3409 (method git-fetch)
3410 (uri (git-reference
3411 (url "https://github.com/apache/arrow")
3412 (commit (string-append "apache-arrow-" version))))
3413 (file-name (git-file-name name version))
3414 (sha256
3415 (base32
3416 "02r6yx3yhywzikd3b0vfkjgddhfiriyx2vpm3jf5880wq59x798a"))))
dae7661a
LF		 3417 (build-system cmake-build-system)
3418 (arguments
3419 `(#:tests? #f
3420 #:phases
3421 (modify-phases %standard-phases
3422 (add-before 'configure 'enter-source-directory
3423 (lambda _ (chdir "cpp") #t))
3424 (add-after 'unpack 'set-env
3425 (lambda _
3426 (setenv "BOOST_ROOT" (assoc-ref %build-inputs "boost"))
3427 (setenv "BROTLI_HOME" (assoc-ref %build-inputs "brotli"))
3428 (setenv "FLATBUFFERS_HOME" (assoc-ref %build-inputs "flatbuffers"))
dae7661a
LF		 3429 (setenv "RAPIDJSON_HOME" (assoc-ref %build-inputs "rapidjson"))
3430 #t)))
3def739d 3431 #:build-type "Release"
dae7661a 3432 #:configure-flags
3def739d 3433 (list "-DARROW_PYTHON=ON"
a50628bb
KCB		 3434 "-DARROW_GLOG=ON"
3435 ;; Parquet options
3436 "-DARROW_PARQUET=ON"
3437 "-DPARQUET_BUILD_EXECUTABLES=ON"
3438 ;; The maintainers disallow using system versions of
3439 ;; jemalloc:
3440 ;; https://issues.apache.org/jira/browse/ARROW-3507. This
3441 ;; is unfortunate because jemalloc increases performance:
3442 ;; https://arrow.apache.org/blog/2018/07/20/jemalloc/.
3443 "-DARROW_JEMALLOC=OFF"
3444
3445 ;; The CMake option ARROW_DEPENDENCY_SOURCE is a global
3446 ;; option that instructs the build system how to resolve
3447 ;; each dependency. SYSTEM = Finding the dependency in
3448 ;; system paths using CMake's built-in find_package
3449 ;; function, or using pkg-config for packages that do not
3450 ;; have this feature
3451 "-DARROW_DEPENDENCY_SOURCE=SYSTEM"
3452
3453 ;; Split output into its component packages.
3454 (string-append "-DCMAKE_INSTALL_PREFIX="
3455 (assoc-ref %outputs "lib"))
3456 (string-append "-DCMAKE_INSTALL_RPATH="
3457 (assoc-ref %outputs "lib")
dae7661a 3458 "/lib")
a50628bb
KCB		 3459 (string-append "-DCMAKE_INSTALL_BINDIR="
3460 (assoc-ref %outputs "out")
3461 "/bin")
3462 (string-append "-DCMAKE_INSTALL_INCLUDEDIR="
3463 (assoc-ref %outputs "include")
3464 "/share/include")
3465
3466
3467 "-DARROW_WITH_SNAPPY=ON"
3468 "-DARROW_WITH_ZLIB=ON"
3469 "-DARROW_WITH_ZSTD=ON"
3470 "-DARROW_WITH_LZ4=ON"
3471 "-DARROW_COMPUTE=ON"
3472 "-DARROW_CSV=ON"
3473 "-DARROW_DATASET=ON"
3474 "-DARROW_FILESYSTEM=ON"
3475 "-DARROW_HDFS=ON"
3476 "-DARROW_JSON=ON"
3477 ;; Arrow Python C++ integration library (required for
3478 ;; building pyarrow). This library must be built against
3479 ;; the same Python version for which you are building
3480 ;; pyarrow. NumPy must also be installed. Enabling this
3481 ;; option also enables ARROW_COMPUTE, ARROW_CSV,
3482 ;; ARROW_DATASET, ARROW_FILESYSTEM, ARROW_HDFS, and
3483 ;; ARROW_JSON.
3484 "-DARROW_PYTHON=ON"
dae7661a
LF		 3485
3486 ;; Building the tests forces on all the
3487 ;; optional features and the use of static
3488 ;; libraries.
3489 "-DARROW_BUILD_TESTS=OFF"
a50628bb
KCB		 3490 "-DBENCHMARK_ENABLE_GTEST_TESTS=OFF"
3491 ;;"-DBENCHMARK_ENABLE_TESTING=OFF"
dae7661a
LF		 3492 "-DARROW_BUILD_STATIC=OFF")))
3493 (inputs
3494 `(("boost" ,boost)
dae7661a 3495 ("brotli" ,google-brotli)
a50628bb
KCB		 3496 ("double-conversion" ,double-conversion)
3497 ("snappy" ,snappy)
3498 ("gflags" ,gflags)
3499 ("glog" ,glog)
3500 ("apache-thrift" ,apache-thrift "lib")
3501 ("protobuf" ,protobuf)
3502 ("rapidjson" ,rapidjson)
3503 ("zlib" ,zlib)
3504 ("bzip2" ,bzip2)
3505 ("lz4" ,lz4)
3506 ("zstd" ,zstd "lib")
3507 ("re2" ,re2)
3508 ("grpc" ,grpc)
dae7661a
LF		 3509 ("python-3" ,python)
3510 ("python-numpy" ,python-numpy)))
a50628bb
KCB		 3511 (native-inputs
3512 `(("pkg-config" ,pkg-config)))
3513 (outputs '("out" "lib" "include"))
dae7661a
LF		 3514 (home-page "https://arrow.apache.org/")
3515 (synopsis "Columnar in-memory analytics")
3516 (description "Apache Arrow is a columnar in-memory analytics layer
a50628bb 3517designed to accelerate big data. It houses a set of canonical in-memory
dae7661a 3518representations of flat and hierarchical data along with multiple
a50628bb 3519language-bindings for structure manipulation. It also provides IPC and common
dae7661a
LF		 3520algorithm implementations.")
3521 (license license:asl2.0)))
5e5ac710
LF		 3522
3523(define-public python-pyarrow
3524 (package
a50628bb 3525 (inherit apache-arrow)
5e5ac710 3526 (name "python-pyarrow")
5e5ac710
LF		 3527 (build-system python-build-system)
3528 (arguments
a50628bb 3529 '(#:tests? #f ; XXX There are no tests in the "python" directory
5e5ac710
LF		 3530 #:phases
3531 (modify-phases %standard-phases
0fa926c2 3532 (delete 'build) ; XXX the build is performed again during the install phase
5e5ac710
LF		 3533 (add-after 'unpack 'enter-source-directory
3534 (lambda _ (chdir "python") #t))
a50628bb 3535 (add-after 'unpack 'make-git-checkout-writable
5e5ac710 3536 (lambda _
a50628bb 3537 (for-each make-file-writable (find-files "."))
5e5ac710
LF		 3538 #t)))))
3539 (propagated-inputs
a50628bb 3540 `(("apache-arrow" ,apache-arrow "lib")
5e5ac710
LF		 3541 ("python-numpy" ,python-numpy)
3542 ("python-pandas" ,python-pandas)
3543 ("python-six" ,python-six)))
3544 (native-inputs
c69959f0 3545 `(("cmake" ,cmake-minimal)
a50628bb 3546 ("pkg-config" ,pkg-config)
5e5ac710
LF		 3547 ("python-cython" ,python-cython)
3548 ("python-pytest" ,python-pytest)
0fa926c2 3549 ("python-pytest-runner" ,python-pytest-runner)
5e5ac710 3550 ("python-setuptools-scm" ,python-setuptools-scm)))
a50628bb 3551 (outputs '("out"))
5e5ac710
LF		 3552 (home-page "https://arrow.apache.org/docs/python/")
3553 (synopsis "Python bindings for Apache Arrow")
a50628bb
KCB		 3554 (description
3555 "This library provides a Pythonic API wrapper for the reference Arrow C++
3556implementation, along with tools for interoperability with pandas, NumPy, and
3557other traditional Python scientific computing packages.")
5e5ac710
LF		 3558 (license license:asl2.0)))
3559
3560(define-public python2-pyarrow
3561 (package-with-python2 python-pyarrow))
450d5dc2
PL		 3562
3563(define-public python-crate
3564 (package
3565 (name "python-crate")
19181820 3566 (version "0.23.2")
450d5dc2
PL		 3567 (source (origin
3568 (method url-fetch)
3569 (uri (pypi-uri "crate" version))
3570 (sha256
3571 (base32
19181820 3572 "0ngmlvi320c5gsxab0s7qgq0ck4jdlcwvb6lbjhnfprafdp56vvx"))))
450d5dc2
PL		 3573 (build-system python-build-system)
3574 (propagated-inputs
3575 `(("python-urllib3" ,python-urllib3)))
3576 (home-page "https://github.com/crate/crate-python")
3577 (synopsis "CrateDB Python client")
3578 (description
3579 "This package provides a Python client library for CrateDB.
3580It implements the Python DB API 2.0 specification and includes support for
3581SQLAlchemy.")
3582 (license license:asl2.0)))
ae8a0184
GLV		 3583
3584(define-public libdbi
3585 (package
3586 (name "libdbi")
3587 (version "0.9.0")
3588 (source (origin
3589 (method url-fetch)
3590 (uri (string-append "mirror://sourceforge/libdbi/libdbi/libdbi-"
3591 version "/libdbi-" version ".tar.gz"))
3592 (sha256
3593 (base32
3594 "00s5ra7hdlq25iv23nwf4h1v3kmbiyzx0v9bhggjiii4lpf6ryys"))))
3595 (build-system gnu-build-system)
3596 (synopsis "Database independent abstraction layer in C")
3597 (description
3598 "This library implements a database independent abstraction layer in C,
3599similar to the DBI/DBD layer in Perl. Writing one generic set of code,
3600programmers can leverage the power of multiple databases and multiple
3601simultaneous database connections by using this framework.")
3602 (home-page "http://libdbi.sourceforge.net/")
3603 (license license:lgpl2.1+)))
df81de86
GLV		 3604
3605(define-public libdbi-drivers
3606 (package
3607 (name "libdbi-drivers")
3608 (version "0.9.0")
3609 (source (origin
3610 (method url-fetch)
3611 (uri (string-append "mirror://sourceforge/libdbi-drivers/"
3612 "libdbi-drivers/libdbi-drivers-" version
3613 "/libdbi-drivers-" version ".tar.gz"))
3614 (sha256
3615 (base32
3616 "0m680h8cc4428xin4p733azysamzgzcmv4psjvraykrsaz6ymlj3"))))
3617 (build-system gnu-build-system)
3618 (native-inputs
9077cf68
MB		 3619 `(;; For tests.
3620 ("inetutils" ,inetutils)
3621 ("glibc-locales" ,glibc-locales)
ca69163c 3622 ("mariadb" ,mariadb)))
df81de86
GLV		 3623 (inputs
3624 `(("libdbi" ,libdbi)
9077cf68
MB		 3625 ("mariadb:dev" ,mariadb "dev")
3626 ("mariadb:lib" ,mariadb "lib")
df81de86
GLV		 3627 ("postgresql" ,postgresql)
3628 ("sqlite" ,sqlite)))
3629 (arguments
3630 `(#:configure-flags
3631 (let ((libdbi (assoc-ref %build-inputs "libdbi"))
9077cf68
MB		 3632 (mysql:inc (assoc-ref %build-inputs "mariadb:dev"))
3633 (mysql:lib (assoc-ref %build-inputs "mariadb:lib"))
df81de86
GLV		 3634 (postgresql (assoc-ref %build-inputs "postgresql"))
3635 (sqlite (assoc-ref %build-inputs "sqlite")))
3636 (list "--disable-docs"
3637 (string-append "--with-dbi-incdir=" libdbi "/include")
3638 (string-append "--with-dbi-libdir=" libdbi "/lib")
3639 "--with-mysql"
9077cf68
MB		 3640 (string-append "--with-mysql-incdir=" mysql:inc "/include/mysql")
3641 (string-append "--with-mysql-libdir=" mysql:lib "/lib")
df81de86
GLV		 3642 "--with-pgsql"
3643 (string-append "--with-pgsql-incdir=" postgresql "/include")
3644 (string-append "--with-pgsql-libdir=" postgresql "/lib")
3645 "--with-sqlite3"
3646 (string-append "--with-sqlite-incdir=" sqlite "/include")
3647 (string-append "--with-sqlite-libdir=" sqlite "/lib")))
3648 #:phases
3649 (modify-phases %standard-phases
3650 (add-after 'unpack 'fix-tests
3651 (lambda* (#:key inputs #:allow-other-keys)
3652 (substitute* "tests/test_mysql.sh"
3653 (("^MYMYSQLD=.*")
3654 (string-append "MYMYSQLD="
9077cf68 3655 (assoc-ref inputs "mariadb")
df81de86
GLV		 3656 "/bin/mysqld")))
3657 #t))
3658 (add-after 'install 'remove-empty-directories
3659 (lambda* (#:key outputs #:allow-other-keys)
3660 (let ((var (string-append (assoc-ref outputs "out") "/var")))
3661 (delete-file-recursively var))
3662 #t)))))
3663 (synopsis "Database drivers for the libdbi framework")
3664 (description
3665 "The @code{libdbi-drivers} library provides the database specific drivers
3666for the @code{libdbi} framework.
3667
3668The drivers officially supported by @code{libdbi} are:
3669@itemize
3670@item MySQL,
3671@item PostgreSQL,
3672@item SQLite.
3673@end itemize")
3674 (home-page "http://libdbi-drivers.sourceforge.net/")
3675 (license license:lgpl2.1+)))
6d26ee3b
PN		 3676
3677(define-public soci
3678 (package
3679 (name "soci")
3680 (version "4.0.0")
3681 (source (origin
3682 (method git-fetch)
3683 (uri (git-reference
3684 (url "https://github.com/SOCI/soci/")
3685 (commit version)))
3686 (file-name (git-file-name name version))
3687 (sha256
3688 (base32
3689 "06faswdxd2frqr9xnx6bxc7zwarlzsbdi3bqpz7kwdxsjvq41rnb"))))
3690 (build-system cmake-build-system)
3691 (inputs
3692 `(("postgresql" ,postgresql)
3693 ("sqlite" ,sqlite)
3694 ("odbc" ,unixodbc)
3695 ("boost" ,boost)
1ce65f5c
MB		 3696 ("mariadb:dev" ,mariadb "dev")
3697 ("mariadb:lib" ,mariadb "lib")))
6d26ee3b
PN		 3698 (arguments
3699 `(#:tests? #f ; Tests may require running database management systems.
3700 #:phases
3701 (modify-phases %standard-phases
3702 (add-after 'unpack 'fix-lib-path
3703 (lambda _
3704 (substitute* "CMakeLists.txt"
85a906dc
MB		 3705 (("set\\(SOCI_LIBDIR \"lib64\"\\)") ""))
3706 #t)))))
6d26ee3b
PN		 3707 (synopsis "C++ Database Access Library")
3708 (description
3709 "SOCI is an abstraction layer for several database backends, including
3710PostreSQL, SQLite, ODBC and MySQL.")
3711 (home-page "http://soci.sourceforge.net/")
3712 (license license:boost1.0)))
jackhill's copy of GNU Guix: https://guix.gnu.org/