Re: [Gusdev-gusdev] Porting to PostgreSQL

[Jason H. <jha...@pr...>]

Steve-

On Mar 9, 2004, at 10:39 AM, Steve Fischer wrote:

> Jason-
>
> Here is a quote from a mail i sent on Feb 13:
>
<snip>

> I know that Laurie was working on porting the queries found in the  
> object layer, and seems to have succeeded.
>
> I suggested that we  factor those queries out of the DbiTable.pm and  
> DbiDatabase.pm files, and place them into an Oracle.pm and  
> PostgreSQL.pm.
>
> How did you guys integrate the PostgreSQL specific queries into the  
> object layer?

I generally really just plunked them into an 'elsif' where there is an  
'if' that asks for getDSN =~/oracle/
Pretty messy. There is one strangely nested if if elsif. That's about  
it.

> If you haven't done a clean refactoring we can work together on that...
>
I was getting ready to clean some things up.  There are changes in  
DbiTable and DbiDatabase, like you said, there is also a one-line  
change in DbiRow.pm. I would be happy to help in the code refactoring  
in any way that I can. I have diffs associated with all of the changes  
I have made, if you want those. Two of the queries that Laurie wrote  
don't work, so I rewrote those.

Jason

> steve
>
> Jason Hackney wrote:
>
>> Hi Chris,
>>
>> Well, I wouldn't be so fast to do that just yet. As of this morning,  
>> I have rebuilt Pg 7.3, and reinstalled GUS. Everything builds fine,  
>> including the array and associated tables, as far as I can tell. I  
>> can register plugins using ga. That's about it, so far. What I think  
>> would be useful would be some examples of Perl modules built using  
>> Oracle, just so I can make sure that everything is kosher. Anyone  
>> want to volunteer a couple of modules they have built, so I can  
>> compare and contrast? So far, so good, though.
>>
>> Cheers,
>> Jason
>>
>> On Mar 9, 2004, at 8:06 AM, Chris Stoeckert wrote:
>>
>>> Hi Jason,
>>> Great to hear of your progress. Sounds like we will need to change  
>>> the table name for Array in RAD.
>>>
>>> Any suggestions? "Array_" "ArrayP" (for ArraryPostgreSQL)
>>>
>>> Chris
>>>
>>> On Mar 8, 2004, at 7:04 PM, Jason Hackney wrote:
>>>
>>>> Hi all,
>>>>
>>>> I am working with Laurie Kramer to port the GUS platform to  
>>>> PostgreSQL. Most things work, or are pretty trivial to get working  
>>>> (more on that later). The only real issue I have run into is  
>>>> PostgreSQL uses array as a reserved word (it's a datatype), and you  
>>>> can't make a table called array. This is as of PostgreSQL 7.4 (and  
>>>> is a keyword according to SQL99). PostgreSQL 7.3 doesn't reserve  
>>>> this word, but is a bit gimpy on sub-selects, if necessary we can  
>>>> downgrade, but this will be an issue in the future, as 7.3 departs  
>>>> and 7.4 takes over for it.
>>>>
>>>> Cheers,
>>>> Jason
>>>>
>>>> Jason A. Hackney
>>>> Graduate Student
>>>> Princeton University
>>>>
>>>>
>>>>
>>>> -------------------------------------------------------
>>>> This SF.Net email is sponsored by: IBM Linux Tutorials
>>>> Free Linux tutorial presented by Daniel Robbins, President and CEO  
>>>> of
>>>> GenToo technologies. Learn everything from fundamentals to system
>>>> administration.http://ads.osdn.com/? 
>>>> ad_id=1470&alloc_id=3638&op=click
>>>> _______________________________________________
>>>> Gusdev-gusdev mailing list
>>>> Gus...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: IBM Linux Tutorials
>> Free Linux tutorial presented by Daniel Robbins, President and CEO of
>> GenToo technologies. Learn everything from fundamentals to system
>> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
>> _______________________________________________
>> Gusdev-gusdev mailing list
>> Gus...@li...
>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>