BibTeX interfaces to Structured Query Language (SQL) relational databases (original) (raw)

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>]