Database Schema Designer

Project page with downloads/mailing-list/bug tracking/... is here

GNU GPL license
store schema in XML
works in Linux and other Unixes, also in M$ Windows
supported database objects - DOMAIN, ENTITY, RELATION, SEQUENCE, PROCEDURE, TRIGGER, VIEW, ...

./configure
make
make install

or from RPMs

right click over object's type (domain, entity, ...) => create new object
left click over object's type (domain, entity, ...) => shows a list of objects in the right part
left double click on object => edit object
2x left click on object => edit object's name
left double click on entity in schema => edit entity

5.9.2002 - first version
6.9.2002 - indexes added, left click over object's type
9.9.2002 - moved indexes and triggers to be children of table
10.9.2002 - renamed table to entity and link to relation
11.9.2002 - started work on visual designer
12.9.2002 - it is possible to specify columns that are used in index and to specify which columns are binded in a relation
16.9.2002 - release 0.2 - first step into visual designer
17.9.2002 - it is possible to design relations when in schema (drag with right button)
29.9.2002 - data types are selected from a list (depends on target DB server), first version of XSLT stylesheet for converting DataDesigner's XML data to a target SQL server (only PostgreSQL now)
30.9.2002 - improved XSL stylesheet, added parameters for sequences
6.10.2002 - referential integrity in relation, constraints for entities
8.12.2002 - release 0.3 - improved referential integrity + XSL tranformation for PostgreSQL
17.12.2002 - release 0.3.1 - fixed build with wxWindows 2.3.4
22.2.2003 - reworked GUI (now using MDI), uses wxWindows 2.4.0, the Windows version are distributed as instalable package
2.6.2003 - release 0.4 - reworked GUI, added printing and zooming of schema. DDL commands can be saved directly from DataDesigner
6.1.2004 - release 0.5 - improved GUI, added "models", improved DDL generation