NAME

svplus - SchemaView Plus GUI for drawing database schemas

FORMAT

        svplus [file]

SYNOPSIS

        svplus
        svplus example.svp

DESCRIPTION

SchemaView Plus is a GUI for retrieve, drawing and printing database schema.

Schema can be retrieved using DBIx::SystemCatalog (currently supported basicly all current DBD drivers, some better support for PostgreSQL and quite well support for Oracle).

Program use XML for storing and retrieving data in text files. You can write any filters to modify these XML files for add new functionality based on your projects (e.g. droping off some relationships etc.). You can specify one filename on command line for autoloading it after GUI start up.

Schema can be printed to PostScript file.

VERSION

0.08

TODO

Putting on CPAN, announcing on Freshmeat, droping IDT relationships, posterizing PostScript output, retrieving only updates from database (for schema), editing in repository, showing primary keys, layers for tables and views, support for SV format and dump format (if XML modules not present), printing to currently defined printers and to GhostView, on-line web generating printing (to some image format), context toolbox, hints on status line, alignment, text tool for making notes on canvas, splash, integrated manual, setting canvas size by user (enlarging), saving position of scrollbars, information about unwanted tables and relationships, backward update for databases, support comments in database schema, box with texts as special kind of objects, local right-click menus, solving known bugs.

KNOWN BUGS

Now I can't show multiple relationships (two and more columns, only first of these columns are drawn), problem with manipulating of dragpoint in smooth coords based connection method, if only one table is, all operations work very slowly, large tables quite slow move.

AUTHOR

(c) 2001 Milan Sorm, sorm@pef.mendelu.cz at Faculty of Economics, Mendel University of Agriculture and Forestry in Brno, Czech Republic.

Special thanks for Miroslav Kripac (SchemaView) and Ing. Hana Cerna (schema for UIS MZLU).

This program was made because we need draw large database schema for University Information System at our university. Miroslav Kripac's SchemaView was our first solution but because SchemaView was written in Java (slow, slow and slow) and don't have needed functions like scrollable canvas we write this yet another drawer.

SEE ALSO

perl(1); DBI(3), Tk(3), XML::Parser(3), XML::Dumper(3), DBIx::SystemCatalog(3), Math::Project(3), Hints(3).