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.12

TODO

Droping IDT relationships, layers for tables and views, support for SV format and dump format (if XML modules not present), on-line web generating printing (to some image format), context toolbox, hints on status line, alignment and grid, text tool for making notes on canvas, integrated manual or web documentation, setting canvas size by user (enlarging), backward update for databases, support comments in database schema, box with texts as special kind of objects, finding object in repository, locating object on canvas, solving known bugs.

KNOWN BUGS

Problem with manipulating of dragpoint in smooth coords based connection method, retrieving only updates from database -- now forgot all new informations, large tables quite slow move, edit relationship doesn't work, creating relationship works bad, repeated retrieving multiply objects in Object Repository, I retrieve always all relationships (e.g. for 1 table in large schema - slow).

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), Ing. Hana Netrefova (betatester) and Ludek Finstrle (PgSQL support, contributor).

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).