LaTeXDB project brings together LaTeX and a MySQL database. You can use SQL queries in your LaTeX document and loop over the result sets creating tables, serial letters, and other stuff.
LaTeXDB is pretty simple to use, there are only three new commands to extend your LaTeX files: With them you define a database connection, create queries and access the result sets.
You include commands such as
texdbconnection{DBType,host,user,passwd,db}
to setup a database connection,
texdbdef{##query}{select var1,var2,... from table where...}{##VAR1,##VAR2,...}
to define a query, and
texdbfor{##query}{... some LaTeX stuff with ##VAR1, ...}
to use the results in your LaTeX code.
Installation:
This is easy too: Grab the archive, unpack it, and run install as root, or for minimum functionality copy latexdb, latexdb.py and latexdb-preparse.py from the code directory to /usr/local/bin or some other directory that can be found in $PATH. Only put them in the same directory, because latexdb expects latexdb.py and latexdb-preparse.py in its own directory.
What's New in This Release:
· A bug within the preparser that caused latexdb to break in texdbfor loops with too big arguments was fixed (contributed by Francois Meyer)
· New script pdflatexdb which is the same as latexdb but calls pdflatex instead of latex, so it generates PDF, not DVI files (user request)
Product's homepage
Find us on Google+
