Skip site navigation (1) Skip section navigation (2)

Re: Google Summer of Code

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Google Summer of Code
Date: 2007-04-21 23:28:16
Message-ID: 462A9E10.30608@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-hackers
Euler Taveira de Oliveira a écrit :
> For those who don't know, I will develop and ER tool integrated to
> pgAdmin during these 3 months as a SoC project. Thanks to Dave Page to
> mentor me.

Whoo, that's just great news. With the debugger, it's the second 
functionnality I miss the most on pgAdmin :)

> I just set up two environments to develop/test: Slackware 11.0 and
> Windows XP SP2. I don't know what version you use to build; 2.6.4 or
> 2.8.3?

2.8.0 because I didn't take the time to build 2.8.3.

> The patches will be in [1]. I'll be using this maillist to discuss all
> the development steps.

Great.

> Project Summary:
> Implement an ER diagramming tool fully integrated with pgAdmin. The tool
> will have the following features: 
> 1) draw database diagrams: the ability to draw relation with its
> attributes, constraints, keys and draw relationships among them. The
> idea is to use the wxArt2D library [2] (it's tightenly integrated in
> wxWidgets [library used in pgAdmin] and it's actively maintained);
> 2) get the modifications in the diagram and apply it to schema/database:
> map modifications to SQL statements;
> 3) save the diagram in a proposed format (xml-based): draft a XML DTD
> format to store the metadata;
> 4) use different notation formats for diagrams (Barker's, IDEF1X,
> others?): make an abstraction layer to support all of the notation
> formats.
> 
> Steps:
> 1) draft a XML DTD to save the diagram metadata;
> 2) draft the interface integrated in pgAdmin;
> 3) implement the drawing diagram feature;
> 4) implement the diagram-to-saving-format feature;
> 5) implement the metadata to SQL statements feature;
> 6) implement different notation formats for diagrams.
> 
> That's it. I'm drafting the XML DTD (possible an XML Schema) and I'll
> post it ASAP, so you could comment about it.
> 

Good luck with your project.

Regards.


-- 
Guillaume.
<!-- http://abs.traduc.org/
      http://lfs.traduc.org/
      http://docs.postgresqlfr.org/ -->

In response to

pgadmin-hackers by date

Next:From: Nabucodonosor CoutinhoDate: 2007-04-22 00:13:53
Subject: PgAdmin pt_BR traduction
Previous:From: Euler Taveira de OliveiraDate: 2007-04-21 21:21:58
Subject: Google Summer of Code

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group