Re: Graphical ER Editor / Graphical Query Editor : First stages?

This is pretty much where I am at.  I have the basic layout of the SQL
server new view window done.  The resizing code was a pain to implement
cleanly, but I did get it after a spell.

I agree with the need for a custom control for the entity diagrams.  The key
is to make the control powerful enough so that at design time, the
programmer can modify the control to suit their purpose.  For example, the
ideal control for the query planner is not the same as for a relationship
diagram, but they are close enough that it ought to be one customizable
control.  This control also needs to handle views, functions, rules,
triggers, etc (in their appropriate spots).

I am working on such a control now, but I've just barely begun that.

Mark

-----Original Message-----
From: pgadmin-hackers-owner@postgresql.org
[mailto:pgadmin-hackers-owner@postgresql.org]On Behalf Of Tim Finch,
FosterFinch Ltd
Sent: Wednesday, February 27, 2002 2:20 AM
To: pgadmin-hackers@postgresql.org
Subject: [pgadmin-hackers] Graphical ER Editor / Graphical Query Editor :
First stages?

Mark & Others,

Tim again. My thinking about the graphical facilities under discussion here
to do with pgAdmin could start with making an ActiveX control that displays
a table graphic, a la the Access graphical editor.

The control would potentially take something like a reference to a table
from pgSchema?? (I've not looked at pgSchema in any detail yet) and render
the table's fields in a box, showing which are PK, which have constraints,
indexes, foreign keys etc. using mixture of colour, bold, italic etc.

This control can then be used in numerous other places, like in a QBE
editor, a Relational Schema screen and no doubt other places (like the
create table dialogue boxes, as a table is being created...?)

This work would also give a clear goal post of completion - once its
written its usable, and if any of us have to drop out of the race we leave
behind something of worth.

Tim.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org