Hi Alberto,
Thanks for your interest. Here's a brief overview of what we've been up
to with respect to the PostgreSQL version. Currently, the official GUS
schema is contained within our instance here at CBIL. From time to
time, we use custom scripts to extract the schema, and release versions
of GUS. With the PostgreSQL release, we'd like to turn this model on
its head, maintaining instead the canonical version of GUS as an XML
representation, and then using that XML to either generate Oracle or
PostgreSQL installation scripts and DDL.
We're using a package called SQLFairy (SQL::Translator) to assist in
this process-- it has much of the functionality we require, but not
quite all. Thus, I've been working with the SQLFairy group to make the
necessary changes. So far, the Oracle parser has been reimplemented,
and I'm very close to producing the canonical XML file which will
represent GUS. (My goal is to complete this by the end of the week).
Once the XML document has been created, some work will be necessary to
modify the Oracle and PostgreSQL producers, which will then allow for
end-to-end Oracle DLL-> XML -> Oracle/PostgreSQL DDL in a programmatic
fashion.
Assuming all goes well this week with the Oracle Parser, I hope to
complete the Producer changes the following week, and address any
bugs/issues. So hopefully by mid-September we'll be ready with this
stuff. Of course, as you can assume from my earlier time estimate, this
is only a rough guess, and as other projects require diversions of my
attention, this will affect the timeline.
If your student is familiar with Perl and is interested, they are more
than welcome to help with modifying SQLFairy to accomplish this.
Eventually everything will be committed back to the main SQLFairy CVS,
but they're on the cusp of a release and so I'm holding off adding my
changes for now.
Thanks,
Mike
Alberto Davila wrote:
> Dear Mike,
>
> I have a student here that will center efforts to try to use GUS with
> PostgreSQL. If that GUS version has been released, would you kindly let
> us know from where we can download ? Otherwise, any data/doc you may
> have on it and able to share would be greatly appreciated.
>
> Thanks, Alberto
>
>
> On Thu, 2004-08-12 at 10:46, Michael Saffitz wrote:
>
>>Hello Jeetendra,
>>
>>We're actively working on the PostgreSQL version of GUS, and I hope to
>>release late next week.
>>
>>We have a proof of concept version in place, and we're just now working
>>to integrate this with our installation and configuration framework.
>>
>>Thanks,
>>
>>Mike
>>
>>On Aug 11, 2004, at 4:57 PM, Jeetendra Soneja wrote:
>>
>>
>>>Any idea on when the PostgreSQL version of GUS is expected to be
>>>released?
>>>
>>>~Jeetendra.
>>>
>>>
|
