#720 SWF for relation view

Peter Liscovius

I would like suggest to develope a plugin for
phpmyadmin for relational databases like the
PDF-generation plugin.

possible advantages over PDF-plugin:
- WYSIWYG, automatic drawing of relation lines while
layouting the tables.
- Scalable
- 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:

A. -
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
pdfconfig has)
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.



  • Andrew Murphy
    Andrew Murphy

    Logged In: YES

    I am not sure if php allows this, but ASP allows you to use a
    page to return a picture. It could be done this way with an
    image map as well.

  • Michal Čihař
    Michal Čihař

    • status: open --> pending
  • Michal Čihař
    Michal Čihař

    There is already a wysiwyg editor for schema, database designer and it is possible to export schema into various scalable formats. I really don't see reason for including this proprietary technology.

  • This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

    • status: pending --> closed
  • Michal Čihař
    Michal Čihař

    • Status: closed --> fixed