Is there any package for LaTeX dealing with a database?

Question

Is there any package for LaTeX dealing with a database (with some of the fields being LaTeX code). For example, given a collection of problems with fields {id, name, author, refs, statement, solution, difficulty, keywords...} the package should allow to build a latex document from the data filtering by any of the fields (obtaining, for example, a list of the "easy" algebra problems with authors but without solutions). Another possible application is a multilingual CV being the fields the CV entries and the rows the data in the corresponding language.

I managed to simulate this scheme using .bib files to store the data, but as some drawbacks appeared (relative to the code interpretation) I just wonder if there is something specifically designed for this situations.

There is the datatool package. I haven't used it myself so I can't say more about it. — cgnieder, Dec 16 '12 at 17:39
@cgnieder I've used the datatool package and I'm happy to recommend it. — , Dec 16 '12 at 17:50
If you really want a database then this question is relevant: Reading data from a relational database into a LaTeX table. If your needs are more modest, then pgfplotstable or datatool? might be more relevant. — Alan Munn, Dec 16 '12 at 18:02
See also the blog post LaTeX and template engines, revisited. — Stephan Lehmke, Dec 16 '12 at 18:43
If you want to build exames from already defined exercises tagged with some words, Exsheets can help you. Look at Exsheets' author answer here. — Ignasi, Dec 16 '12 at 19:29
I frequently use template toolkit. Works with all data sources supported by Perl's database interface. — Alex, Dec 16 '12 at 19:32
Thank you all, I probably will give datatool a try (since it seems that it can convert my .bib files) before going into something more involved. — suitangi, Dec 17 '12 at 21:55
You can use also textmerg, there an example in build dynamic documents from a Textdatabase. — Fran, Dec 20 '12 at 01:22
@suitangi, If you mean accessing database to create tables, I use R, which has good connectivity via RODBC. You can then, of course, create the tables directly (in LaTeX format) via use of R xtable package. The above, used in conjunction with knitr means that data frames (and other data objects) in R can be ported DIRECTLY into LaTeX document, facilitating real-time, data-driven, up-to-date documentation to your liking. Might seem convaluted, but its really quite straightforward. — Nicholas Hamilton, Dec 21 '12 at 15:09

score 6 · Answer 1 · edited Apr 13 '17 at 12:35

Excerpt from comments below question:

If you really want a database then this question is relevant: Reading data from a relational database into a LaTeX table. If your needs are more modest, then pgfplotstable or datatool? might be more relevant. See also the post in our TeX community blog: LaTeX and template engines, revisited. You can use also textmerg, there is an example in build dynamic documents from a Textdatabase.

Perhaps also some TeX external solutions fit your needs: Template Toolkit (works with all data sources supported by Perl's database interface); R with knitr (create the tables directly in LaTeX format via use of R xtable package, and in conjunction with knitr port data frames and other data objects in R DIRECTLY into a LaTeX document).

score 1 · Answer 2 · answered Nov 24 '21 at 14:18

1

You can take a look at datatex. I think that it has the functionality you need.

answered Nov 24 '21 at 14:18

mac

1,479

Is there any package for LaTeX dealing with a database?

2 Answers2