Re: [gnome-db] Feature requests : reverse engeneering & md5 stamps

[Vivien Malerba <malerba gnome-db org>]

On Sun, Dec 15, 2002 at 03:45:17PM +0100, Jean-Michel POURE wrote:
> > we already have this for almost all schemas. You get the SQL for tables,
> > procedures, etc
> 
> Sorry, I did not know.
> 
> > but do you mean actually adding a field to the table (or create a new
> > table)? If so, I don't like the idea. libgda should be as little
> > intrusive as possible, and creating fields in the database (as pgaccess
> > does, and probably pgAdmin) is not a good idea, IMO.
> 
> A function returning the md5 stamp of the SQL needed to create the object. No 
> table should be needed.
> 

How about using an asynchronous notification system? The idea is that an
application can register to receive event notification for example when
a new table is created, or when a table is altered, etc. We could add
some signals to the GdaConnexion object for this purpose (the difficult
part is to see how to  have a generic API non dependant on one DBMS, and
which signals to emit). I know that the postgres C library supports this
(I'm not sure about Oracle or MySQL).

This would allow applications to always be kept up to date with database
structures.

How does it sound?

Cheers,

Vivien