I have and extensive database with references in form of an SQL database. How can I use this information in BibTeX?
-
1I'd thought about asking the exact same thing myself... – David Z Aug 3 '10 at 1:04
-
2Some clarification questions: 1) Do you want BibTeX to get the information directly from the database, or are you prepared to extract it yourself in .bib format? 2) Do you already have the information in a database in a specific format and want to use only that, or would you be happy converting to another bibliographic database system? – Andrew Stacey Aug 3 '10 at 7:23
-
1I assume your database must have some particular schema; it would probably have been a good idea to mention what schema you are using or what tool you used to generate it... – SamB Nov 30 '10 at 2:17
Nelson Beebe gave a talk at TUG 2009 on using SQL databases for bibliographic purposes as a replacement for BibTeX. The program is bibsql and looks very promising, but I haven't used it myself.
You can read more details and examples in his paper in TUGboat 30(2).
One idea would be to use one of the many python APIs for SQL, and pipe that to one of the python modules that output bibtex