Re: [Gusdev-gusdev] PostgreSQL Version

[Michael S. <msa...@pc...>]

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