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).
answered Aug 3 '10 at 5:13
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
