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

How much experience do you have with ActiveX Controls? I'd be happy to
unload that part. I can then work on the results grid with hand-entered
queries until the control is done. Once the control is done (at least
alpha), we could work on the query design grid, and getting the
relationships, query grid, and SQL pane to work together. But we really
need the relationship control first, at least enough to see what will and
won't work.

I can send you what I have so far, but probably not until tomorrow night, as
I have quite a few other things that need to be done.

Mark

-----Original Message-----
From: Tim Finch, FosterFinch Ltd [mailto:tim(at)fosterfinch(dot)co(dot)uk]
Sent: Wednesday, February 27, 2002 3:41 PM
To: Mark A. Taff
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: RE: [pgadmin-hackers] Graphical ER Editor / Graphical Query Editor
: First stages?

Mark, you seem to be well on the way! Is there anywhere you think I could
get involved?
Dave/Jean is there any way you can set up a sep portion on the CVS where
this semi project can be held, without necessarily giving us rights to
upload the main project files for pgAdmin????
Tim.

At 10:04 27/02/2002 -0800, Mark A. Taff wrote:
>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(at)postgresql(dot)org
>[mailto:pgadmin-hackers-owner(at)postgresql(dot)org]On Behalf Of Tim Finch,
>FosterFinch Ltd
>Sent: Wednesday, February 27, 2002 2:20 AM
>To: pgadmin-hackers(at)postgresql(dot)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