Re: [gnome-db] Oracle Provider and How to Contribute

[Steve Fosdick <gnomedb pelvoux demon co uk>]

On 30 Jan 2003 12:40:42 +0100
Rodrigo Moya <rodrigo gnome-db org> wrote:

> On Thu, 2003-01-30 at 05:45, Biswapesh Chattopadhyay wrote:
> > Hi
> > 
> > I'm interested in the Oracle provider. I've been working on
> > *NIX/Oracle for the last six years and have experience with OCI,
> > GNOME and C. Where do I start/who do I coordinate with ?
> > 
> as I already told Steve, the Oracle provider is orphan right now, so
> if you guys want to work on it, just coordinate between you two.
> 
> The current status is that it works, but needs filling in some missing
> things, as well as updating all the schemas retrieval (see
> http://www.gnome-db.org/docs/libgda/libgda-provider-class.html)

To me this would seem to the the highest priority at the moment - get
the Oracle provider to the point it can support those features allready
in the GUI front-end (mergeant).

As, you'll see from my other message, I am currently working on trying
to get the schema functionality to work correctly with tables, views and
their fields - we're having trouble with naming.  I would value your
views on that point.

Other than that the other main task I can see is to go through the
schema types and work out how we get the necessary info either from
OCIDescribeAny or by querying the relavent views. 

> > 1. DB explorer and editor - I'd like to view, create a modify all DB
> > entries from the GUI, e.g. table-spaces, data files, users, tables,
> > indexes, packages and procedures, triggers, etc. Viewing, of course,
> > includes structure as well as content.
> >
> yes, this is what we plan also. This is already available for tables
> and views, and we are adding, as development progresses, the same for
> the other database objects.

This raises the decision between being generic and being specific, for
example are tablespaces a general thing supported by several databases
or are they Oracle-specific.  How do we handle specific stuff - do we
have GUI plugins for certain database types or do we handle it all through
the gda_supports function?

Steve.