{database} is a structured collection of data.

learn more… | top users | synonyms

14
votes
1answer
1k views

Drawing relationships between elements of a database

I am looking into a feasible way of drawing relationships between Elements from a database. An example: Element x is related to Element Y via the Role "sister". Relationships exist in the form 1:1, ...
5
votes
2answers
3k views

Formatting complex table from CSV using datatool

I have this csv file, formatted like this one: Store,Product 1,Product 2,Product 3,Product 4,Product 5,Sub Total Store 1,15,99,299,75,292,780 Store 2,33,353,429,283,561,1659 Store ...
36
votes
7answers
7k views

Is it possible to connect a database to LaTeX to produce data-driven documents?

I'm starting to write a LaTeX-based reference manual, and have realised that a lot of my needs could be solved by writing a database and then producing the reference manual from that. Lots of my pages ...
16
votes
3answers
644 views

List of People analog to Bibliography

In my document I emphasize names that are mentioned and now I want to provide some additional information about them in an appendix. Currently I do something like: \documentclass{scrartcl} ...
11
votes
2answers
866 views

pgfplotstable or datatool?

What are differences, which to use for including .csv, .tsv files ? Datatool ? pgfplotstable ? I've seen at question : How typeset a numeric table from a CSV file how person asked about fixing ...
8
votes
2answers
495 views

build dynamic documents from a Textdatabase

I need a dynamic solution to produce questionnaires from a database of questions which gets updated from time to time. I thought of LaTeX for set out the layout but the question is whether LaTeX can ...
9
votes
2answers
2k views

Mail-merging documents from a database

I use the term database loosely here -- it can be an actual database, or a spreadsheet (in any format including CSV) or can be package-dependent. Is there a way to create mail-merged documents ...
21
votes
4answers
5k views

Symbols for Outer Joins

I'm looking for a way to typeset the symbols for outer joins, that is ⟕ U+27D5 onward. There seems to be nothing in symbols-a4. Note that I'm not looking for ⋊ U+22C9 as this represents a semijoin. ...
8
votes
2answers
756 views

How to create form letters from spreadsheet data in ConTeXt?

In LaTeX, one can use datatool to build simple form letters. As an example, the data is stored in a spreadsheet or CSV file, like this: Name,Amount,Date "Mr. White","$300","Dec. 2, 1911" "Mr. ...
3
votes
1answer
210 views

Spurious blank space when loading a datatool database

I am getting spurious blank spaces inserted upon loading a dtltool db. The MWE below produces links to all the image files named with a prefix the same as the .tex file: But if I comment out the ...
2
votes
1answer
294 views

Could I insert the elements of a mdb or csv base in Latex?

I want to insert some information from a csv text file or from a mdb (MS data base) base into a latex document. For example I have a document with math exercises and I would like to insert the first ...
10
votes
2answers
1k views

DB diagram's (entity relationship) - tikz chamfered rectangle with split zones

I try to draw an association type for an entity-relationship diagram. How can I draw a chamfered rectangle with split parts=2 or 3 ? I found this ref : Horizontally enlarged hexagon with TikZ but it ...
6
votes
1answer
841 views

Which database documentation software do you use for LaTeX (in Linux)?

I am looking for a database documentation software where I want to incorporate the output in LaTeX. I want to show the table structures, primary keys and other related information. I found ...
5
votes
1answer
774 views

TikZ ER diagrams: really can't underline keys?

I'm creating an ER diagram with the TikZ ER library. The manual warns that although key attributes are conventionally underlined, it is hard to implement in TeX and the library uses italics instead. ...
3
votes
1answer
199 views

How do I install and use nlatexdb? (or latexdb, ratexdb)?

This question is related to this question regarding typesetting a MySQL database using UTF-8 encoding with Xelatex. I ask this in desperation as it involved printing 552 rows for my thesis! I need ...
3
votes
1answer
227 views

Problems in creating graphs using dataplot

I have four simple databases: db1 dy,volume 2009,120000 2010,160000 2011,400000 2012,650000 2013,1000000 2014,1500000 db2 dy,volume 2009,400000 2010,500000 2011,1600000 2012,2200000 2013,2500000 ...
1
vote
2answers
917 views

How to use \hlines and | column separators in a csv table uploaded with datatool

Hi I've been trying to use the datatool package to get data from csv files easily into documents as formatted tables. I seem to keep getting the lines on the first column shifted down by a row. If I ...
0
votes
1answer
243 views

DB dump into LaTeX with Python and R?

I have quite a large index. I am planning to create a full-blown DB for it and later export the information to LaTeX. I am comfortable with R and Python so I would like to work with them but I feel ...
21
votes
1answer
297 views

Using \fontdimen as an array to store data

Reading through pi.tex, I discovered the trick of using \fontdimen as an array of dimensions (which is equivalent to storing integers between ±(2^31-1)sp). Namely, \font\x=cmr10 at 1sp % or whatever ...
9
votes
3answers
262 views

I have a generated database and need to look up values

A database in a format that can be freely defined had entities with the following attributes: ID, HEXNUMBER, LATEXFORMULA, LITERAL. The ID is unique and can contain numbers, dots and dashed. ...
5
votes
1answer
950 views

Drawing paths with TikZ from a DB with DataTool

I have written this code and it works: ... \DTLsetseparator{;} \DTLloaddb[noheader]{DBcurva}{Curvas.csv} \begin{tikzpicture} \foreach \columna in {1,3,...,\DTLcolumncount{DBcurva}}{ ...
3
votes
2answers
62 views

On sorting a string with multiple entries

In my LaTeX-file I create a variable \authors which could have content: [Doe] John Doe; [Potter] Harry Potter; [Clinton] Bill Clinton; [Obama] Barack Obama; ... This is dynamically created, so I ...
1
vote
0answers
180 views

How can I typeset with LaTeXDB using XeLaTeX? [closed]

Related question Using the sample code on this site, http://hgesser.com/software/latexdb/workshop.html, I would like to query my MySQL database and typeset using XeLaTeX. This is because all of ...