I would like suggest to develope a plugin for
phpmyadmin for relational databases like the
possible advantages over PDF-plugin:
- WYSIWYG, automatic drawing of relation lines while
layouting the tables.
- interactive (e.g. show table or field comments or
content on mouseover etc.)
- expand, collapse table details
There are more than one way to reach the aim:
Make a prebuild SWF for phpmyadmin that loads a
XML-file which is send by phpmyadmin. The XML contains
all informations about tablefields,and relations, and
the last layoutpositions of your tables. (like the
Some little ActionScript parse the XML, at first open
layout the table and connect the relation fields by
lines using a sweet layout/routing algorithm (give
possibility to customize by drag/drop the lines by user)
Let the user drag/drop the tables. Lines are repainted
automatically following the tables when dragged.
Save your changes for the next time you open the swf
generation config. Because the Data is separated from
Layoutview, the SWF is even themeable.
This variant requires Flash >= 5, but the
phpmyadminuser need no flashgeneration library at all.
B. Do all the magic in PHP/whateverlanguage and
generate the SWF complete on server using an
swfgeneration library ('ming' or some other) Even
Flash4 would be sufficient for this variant, but
requires the minglibrary in PHP.
C. Like A, but using GET/POSTvariables. But XML is
better and easier to handle in Flash.