Toilets, New Orleans, Video games, Linux, PostgreSQL, the Marigny, Restaurants, Live Music, Bars, Hollywood Hotties and all with 30% less fat!!

Home

What's New

Tell me that you love me!!

Feedback / Submit Reader Photos

PGDesigner Datamodeling Tool

PGDesigner

The Greatest Game of all TIME!!

Cylindrix

Links

Personal

Current Poll:
What would you like to see more of on hardgeus.com

Answer

Links:

Watch Me Eat a Hot Dog

www.glitch13.com

Live New Orleans

Yaddoshi's site

Six Ten Split

Fleshbot

Offbeat

PGDesigner

PGDesigner is my attempt at implementing a datamodel designer for PostgreSQL. Good datamodeling tools already exist, but none are open source. So here we are. This program is in the alpha stage, but is usable for basic datamodeling.

ATTENTION Dec 4, 2006. I have recently ported PGDesigner over to QT. Most of the functionality is complete. The cvs project for the QT version of PGDesigner is "designer" and not "pgdesigner" as mentioned below.

Here is the Windows binary for PG Designer. If you want the code, you can get it from CVS. I have no Linux binary, so if you want to run it under Linux, you'll have to compile it. Note that you NEED QT4 to compile this app, and my scons SConstruct file expects it to be in /usr/local/qt.

NOTE: Due to limited time, and the current state of QT4 in Linux, I cannot help people trying to compile this app. My QT build settings in both Windows and Linux are utter madness. QT4 is somewhat in an "in between" state, and until things settle down, I *WILL NOT* help anyone compile this app. I am releasing this binary just because so many people ask me about it.

Currently Implemented Features:

) Connection to Postgres database
) Ability to run queries on database and display results on results box
) Importing of table objects with foreign key references into diagram from database
) Saving and loading of diagram to file
) Adding of new (blank) tables to diagram
) Changing table names in diagram
) Adding, removing, and changing columns of tables in the diagram
) Mouse resizing and moving of table objects
) Mouse moving of foreign key objects
) Generation of actual SQL commands to create diagrammed database
) Drag and Drop creation of foreign key relationships
) Coloring of tables for easy organization
) Full print preview and paginated printing support of diagram
) Allow selection of multiple tables for moving more than one at a time

TODO for 1.0:

) Fix printing to handle margins so edges of datamodel are not cut off
) Sort tables in order of dependancy on SQL generation
) Double buffered drawing to avoid flicker
) Drop referencing foreign keys when referenced table is deleted
) Make minimum table size on new table (currently shrinks to table name)
) #include .xpm for icons rather than load from working directory
) Implement scrolling of screen when dragging foreign keys
) Fix bug with computation of left or right key attach point on scroll

The Windows and Linux sources are available through my CVS server.
NOTE: Both the FLTK AND the wx versions of pgDesigner have been retired.
Tortoise CVS is a great CVS client for windows. Otherwise, to use a command line tool, click here to download the windows command line executable for cvs. If you're using Linux, you should know enough to get CVS working ;)

Save the .exe file to a directory in your path such as c:\windows
Open a command prompt and cd to a directory where you want to put the source (A pgdesigner subdirectory will be created by this process)
(note: under windows98 you may have to type: "set HOME=c:" to tell CVS where to store temp login files)

At the prompt type:

cvs -d :pserver:anonymous@www.hardgeus.com:/usr/local/repository login
(you will be prompted for a password. Just hit enter.
cvs -d :pserver:anonymous@www.hardgeus.com:/usr/local/repository checkout designer

And that's it. You should have the source. Note that you will not be able to commit your changes to my repository. If you want commit privileges, email me. My email address is hardgeus at hardgeus.com.

The tortoise CVS method is simpler and too easy to bother documenting :)

You will need Python and SCONS on your machine to build pgDesigner. As I said above, since QT4 isn't fully "out" in Linux, I am going to hold of on offering full build instructions or support.