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

[Rodrigo Moya <rodrigo gnome-db org>]

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)

> I'm chiefly interested in having an open-source tool on GNOME with
> features similar to PL/SQL Developer and TORA on Linux. This roughly
> means:
> 
that is our plan. My initial plan when I started working on gnome-db was
to make something similar to TOAD (www.toadsoft.com), which allows you
to do everything you can with the database from a single app.

> 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.

> 2. Nice syntax highlighted editor for SQL and PL/SQL.
> 
we already have that for SQL, and adding support for PL/SQL is as easy
as setting up a list of the keywords/syntax/etc used by that language.
If you could do that, I'll add support for PL/SQL in 5 minutes :-)

> My time is pretty limited and available in short spurts mostly, plus I'm
> already involved in other projects - any ideas on how to best utilize it
> ?
> 
if you know OCI, I'm sure you won't find difficult at all to work on the
provider. You mainly need to understand how they are done (explained in
http://www.gnome-db.org/docs/libgda/libgda-providers.html), which is
just a matter of understanding a couple of GObject-based classes.

As I said to Steve, just use this list for any question you have.

cheers