[Gusdev-gusdev] Re: [Fwd: Porting GUS to a Open SourceDB ?]

[Giuseppe J. <ju...@it...>]

> Thanks Elisabetta,
> 
> An important question would be also why PostgreSQL and not MySQL, the
> latter appears to be evolved well and have now a good support to
> transactions via InnoDB, etc. I am very inclined to use Gmod and chado
> por our project, but would like to have a final check on the potential
> of GUS before starting things.

ITC-irst has started a working group for a full open source version of
GUS, so to allow the substitution of the Oracle database management
system for data tables and relations within GUS with an open source
solution. In principle we are not oriented to the substitution
of Oracle with another specific DMBS.

It might be worthwhile to consider the possibility to turn DB
independent the whole object-related part of GUS and then choosing the
suitable DB-dedicated driver depending on the user's system. The first
(heavy) step towards this option requires to check the existing code
looking for the Oracle-specific SQL, and then designing an ad-hoc
strategy to transform into either a DBI (better) or into a DBD (here
the choice of the DBMS becomes a constraint).

An important issue, for us, is how to align the DBD portions of the
code along the next releases of GUS. In this view, we see the need of
a DBI-DBD separation really relevant.

We would like to perform the Oracle-PostgreSQL conversion in the most
automated way possible. Before, the Oracle proprietary SQL code has to
be somehow moved to the upper Perl Object Layer level, or to a new
Perl Object Layer.

Comments welcomed


Giuseppe Jurman
Cersare Furlanello