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]