Home

Welcome to the dbvisualizer wiki!

Motivation

In real world applications you always try to automate as much work as possible. This also applies to the generation of documentation. For Java APIs one usually uses Javadoc and for for REST APIs there are also some tools around. For documentation of large database schemas one could use reverse engineering capabilities of some data modeling tools, but mostly had to do some manual work, because the diagrams created by such tools does not have a nice layout in most cases. So I came up with the idea, to let those diagrams be generated using GraphViz.

Examples

I've created a pogram TestDBGenerator, which creates a large number of random tables with random columns. The program does not create tables directly but generates an DDL SQL (DDL - Data Definition Language) file.

Known Problems

• With some large databases the generated .dot file may cause problems when rendering with dot (e.g. long computation times or even segmentation faults)
• I've tested mainly with PostgreSQL; with other databases types may not be recognized perfectly