Take the 2-minute tour ×
TeX - LaTeX Stack Exchange is a question and answer site for users of TeX, LaTeX, ConTeXt, and related typesetting systems. It's 100% free, no registration required.

I have and extensive database with references in form of an SQL database. How can I use this information in BibTeX?

share|improve this question
    
I'd thought about asking the exact same thing myself... –  David Z Aug 3 '10 at 1:04
1  
Some 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? –  Loop Space Aug 3 '10 at 7:23
    
I 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
add comment

2 Answers

up vote 11 down vote accepted

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); it's not publicly available to non-TUG members until 12 months after publication.

share|improve this answer
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.
http://tex.stackexchange.com/questions/857/is-it-possible-to-use-sql-database-for-bibtex
tex.stackexchange.com
crawl=CC-MAIN-2014-23
66907
application/http; msgtype=response
sha1:MSXXBV4DXCXMHNQWSBLKJLGKQDPPZGL6
<urn:uuid:9e3ab8e5-45d7-43e2-828a-de8455056bf2>
2014-07-10T14:46:17Z
198.252.206.16
sha1:6J3B5ADE2MRRKKKI536QG4KQZUKEKB5G
<urn:uuid:89dddbb2-419e-4640-8f88-0e0ce6e5f2a3>
http://tex.stackexchange.com/questions/857/is-it-possible-to-use-sql-database-for-bibtex
response
<urn:uuid:0debeaae-0bbd-4765-8702-c7a522eec43c>
robots: classic
hostname: ip-10-180-212-248.ec2.internal
software: Nutch 1.6 (CC)/CC WarcExport 1.0
isPartOf: CC-MAIN-2014-23
operator: CommonCrawl Admin
description: Wide crawl of the web with URLs provided by Blekko for July 2014
publisher: CommonCrawl
format: WARC File Format 1.0
conformsTo: http://bibnum.bnf.fr/WARC/WARC_ISO_28500_version1_latestdraft.pdf