bibsql and bibtosql:
BibTeX interfaces to
Structured Query Language (SQL)
relational databases
Last updates:
Thu Jul 23 17:13:25 2009
Thu Mar 25 11:50:54 2010
Fri Mar 18 12:51:36 2011
Mon Jun 24 08:03:25 2013
Tue Oct 21 12:24:01 2014
Sat Dec 29 11:47:55 2018
Sat Jan 19 17:48:34 2019
Sat Feb 9 08:48:35 2019
This package is available in several functionally-equivalent distribution formats with identical contents: .jar (Java archive), .shar (Unix shar archive), .shar.bz2 (bzip2'ed Unix shar archive), .shar.gz (gzipped Unix shar archive), .shar.xz (xz'ed Unix shar archive), .tar.bz2 (bzip2'ed UNIX tar archive), .tar.gz (gzipped UNIX tar archive), .tar.xz (xz'ed UNIX tar archive), .zip (InfoZip), and .zoo (zoo), together with companion contents listings ending in -lst. Each unpacks into a subdirectory named by the basename of the distribution file, e.g., bibsql-0.00.
On a machine in a nearby building, the downloads, installation, and first successful search took less than 30 seconds with these steps:
wget http://www.math.utah.edu/pub/bibsql/bibsql-0.09.tar.xz
tar xf bibsql-0.09.tar.xz
cd bibsql-0.09
./configure && make all check install
cd ..
wget http://www.math.utah.edu/pub/tex/bib/history-journals.db
bibsql -d history-journals
sqlite> select count(*) from bibtab;
226482
Prerequisites:
- an SQL database (at least one of MariaDB, MySQL, PostgreSQL, or SQLite3);
- a Unix or Unix-like (e.g., Cygwin on Microsoft Windows) environment;
- a collection of one or more BibTeX files whose entries you wish to store in an SQL database for subsequent retrievals;
- preferably, the bibclean and biborder utilities for cleaning up, syntax checking, and ordering fields of entries in BibTeX files.
Except possibly for very large collections of data (millions of BibTeX entries), the simplest approach is to use SQLite3, a highly-portable public-domain SQL database system that requires only a single platform-independent database file.
- MD5SUM MD5 128-bit checksums
- MD5SUM.asc digitally-signed MD5 128-bit checksums
- RIPEMD-160 RIPEMD-160 160-bit checksums
- RIPEMD-160.asc digitally-signed RIPEMD-160 160-bit checksums
- SHA1SUM SHA1 160-bit checksums
- SHA1SUM.asc digitally-signed SHA1 160-bit checksums
- bibsql paper (TUGboat 30(2), 252--271 (2009))
- bibsql benchmark report
- bibsql-0.00 [2008-10-28] [.html, .jar, .jar-lst, .shar, .shar.bz2, .shar.gz, .shar.xz, .tar.bz2, .tar.gz, .tar.xz, .tar-lst, .zip, .zip-lst, .zoo, .zoo-lst]
- bibsql-0.01 [2010-03-24] [.html, .jar, .jar-lst, .shar, .shar.bz2, .shar.gz, .shar.xz, .tar.bz2, .tar.gz, .tar.xz, .tar-lst, .zip, .zip-lst, .zoo, .zoo-lst]
- bibsql-0.02 [2010-10-26] [.html, .jar, .jar-lst, .shar, .shar.bz2, .shar.gz, .shar.xz, .tar.bz2, .tar.gz, .tar.xz, .tar-lst, .zip, .zip-lst, .zoo, .zoo-lst]
- bibsql-0.03 [2011-06-18] [.html, .jar, .jar-lst, .shar, .shar.bz2, .shar.gz, .shar.xz, .tar.bz2, .tar.gz, .tar.xz, .tar-lst, .zip, .zip-lst, .zoo, .zoo-lst]
- bibsql-0.04 [2011-09-12] [.html, .jar, .jar-lst, .shar, .shar.bz2, .shar.gz, .shar.xz, .tar.bz2, .tar.gz, .tar.xz, .tar-lst, .zip, .zip-lst, .zoo, .zoo-lst]
- bibsql-0.05 [2013-05-14] [.html, .jar, .jar-lst, .shar, .shar.bz2, .shar.gz, .shar.xz, .tar.bz2, .tar.gz, .tar.xz, .tar-lst, .zip, .zip-lst, .zoo, .zoo-lst]
- bibsql-0.06 [2014-07-16] [.html, .jar, .jar-lst, .shar, .shar.bz2, .shar.gz, .shar.xz, .tar.bz2, .tar.gz, .tar.xz, .tar-lst, .zip, .zip-lst, .zoo, .zoo-lst, bibtosql-0.06.html]
- bibsql-0.07 [2016-09-30] [.html, .jar, .jar-lst, .shar, .shar.bz2, .shar.gz, .shar.xz, .tar.bz2, .tar.gz, .tar.xz, .tar-lst, .zip, .zip-lst, .zoo, .zoo-lst, bibtosql-0.07.html]
- bibsql-0.08 [19-Jan-2019] [.html, .jar, .jar-lst, .shar, .shar.bz2, .shar.gz, .shar.xz, .tar.bz2, .tar.gz, .tar.xz, .tar-lst, .zip, .zip-lst, .zoo, .zoo-lst, bibtosql-0.08.html]
-
bibsql-0.09 [08-Feb-2019]
[.html,
.jar,
.jar-lst,
.shar,
.shar.bz2,
.shar.gz,
.shar.xz,
.tar.bz2,
.tar.gz,
.tar.xz,
.tar-lst,
.zip,
.zip-lst,
.zoo,
.zoo-lst,
bibtosql-0.09.html]