Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread Rob Kinyon
On 1/24/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/24/06 2:29 AM, Ron Savage wrote: > > What is the state? > > Is there any unshipped Oracle code available to be worked on? > > Is it a matter of converting *::Pg.pm, say, to *::Oracle.pm, for starters? > > > > At the moment I have a great d

Re: [RDBO] Bitfield problem - again

2006-01-24 Thread Rob Kinyon
it's not in the first position, it's VARCHAR 2) If a second '.' is seen, it's VARCHAR 3) If a character doesn't pass isdigit(), it's VARCHAR 4) Otherwise, it's INTEGER The idea is that if it's SQL_INTEGER, it doesn't get $dbh->quote()

Re: [RDBO] Bitfield problem - again

2006-01-24 Thread Rob Kinyon
ew the parsing yourself - it's in dbdimp.c) Rob On 1/24/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/24/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > > Ahhh ... there's a solution here. *grins* I provided a patch to > > DBD::mysql to do param type guessin

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread Rob Kinyon
On 1/24/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/24/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > > I may be able to help with this. Luckily, if you stick with Oracle > > 9.2+, it can use the standard JOIN syntax. > > Hm, is that reasonable? What is t

Re: [RDBO] Bitfield problem - again

2006-01-24 Thread Rob Kinyon
On 1/24/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/24/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > > It's a $dbh attribute. > > > > $dbh->{mysql_unsafe_bind_type_guessing} = 1; > > > > The reason it's considered 'unsafe'

Re: [RDBO] Bitfield problem - again

2006-01-24 Thread Rob Kinyon
On 1/24/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/24/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > > The reason I wrote the patch is so that I would use indices for > > numeric columns. If MySQL has to convert the value from a string to a > > number, it doe

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread Rob Kinyon
On 1/24/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/24/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > > "Most popular" is a difficult term. DBD::Oracle supports back to > > Oracle 7, after a fashion. 9.2 has been out for about 5-6 years and in > > m

Re: [RDBO] Bitfield problem - again

2006-01-24 Thread Rob Kinyon
On 1/24/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/24/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > > According to the DBI docs under the description of the execute() > > method, it says: > > > > If any arguments are given, then C will effectively cal

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread Rob Kinyon
At this point, we're beyond my 2yr+ old memory of how to do something I never actually implemented in production. :-) Are we going to do this? If we are, I'll bug some friends of mine. Rob --- This SF.net email is sponsored by: Splunk Inc. Do

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread Rob Kinyon
On 1/24/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/24/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > > Are we going to do this? If we are, I'll bug some friends of mine. > > That probably depends on whether or not someone in "we" has an Oracle >

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread Rob Kinyon
If absolutely necessary, I can set one up on my home server, but I technically don't have a server-like IP access (even though I have DynDNS), so I really don't want a lot of access on it. Rob On 1/24/06, Ron Savage <[EMAIL PROTECTED]> wrote: > On Tue, 24 Jan 2006 15:49:2

Re: [RDBO] Q: State of Oracle support

2006-01-25 Thread Rob Kinyon
On 1/25/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/25/06, Todd Hepler <[EMAIL PROTECTED]> wrote: > > John Siracusa wrote: > >> Either way, after the insert, I'll need a way to get the value that was > >> used--and do so in a concurrency-safe way. What's The Oracle Way to do > >> that? >

Re: [RDBO] Rose::DB::Oracle.build_dsn()

2006-01-31 Thread Rob Kinyon
On 1/31/06, Ron Savage <[EMAIL PROTECTED]> wrote: > Hi Folks > > My plan is to solicit advice on the subs in Rose::DB::Pg, and convert them to > Rose::DB::Oracle, build_dsn() being the first. Better ideas accepted. > > I realize Oracle supports a myriad of forms (syntaxes) for the connection > stri

Re: [RDBO] Re: cannot find sets that are clearly there

2006-02-21 Thread Rob Kinyon
On 2/21/06, Michael Lackhoff <[EMAIL PROTECTED]> wrote: > On 21 Feb 2006, John Siracusa wrote: > > > SQLite really has no concept of SQL data types. Well, it has a very > > simplified concept, anyway. All that detail you put in your CREATE > > TABLE statements is pretty much ignored by SQLite. I

Re: [RDBO] Object data as hash ref (was: cannot find sets that are clearly there)

2006-02-27 Thread Rob Kinyon
On 2/27/06, John Siracusa <[EMAIL PROTECTED]> wrote: > Yeah, that's what I planned. Although the APIs will have "cgi" in > their names, all that will be requires is a param() method that works > like CGI's. You should probably elaborate here. CGI.pm has a TON of dwimmery that isn't immediately ob

Re: [RDBO] Object data as hash ref (was: cannot find sets that are clearly there)

2006-02-27 Thread Rob Kinyon
On 2/27/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 2/27/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > > On 2/27/06, John Siracusa <[EMAIL PROTECTED]> wrote: > >> Yeah, that's what I planned. Although the APIs will have "cgi" in > >>

Re: [RDBO] Object data as hash ref (was: cannot find sets that are clearly there)

2006-02-27 Thread Rob Kinyon
On 2/27/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 2/27/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > > It's absolutely critical to note that you view param() as a readonly > > method. > > Will calling it with zero args or just one arg suffice? Or do

Re: [RDBO] Rose::DB V 0.65 t/list-tables.t

2006-02-27 Thread Rob Kinyon
On 2/27/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 2/27/06 8:05 PM, Ron Savage wrote: > > Line 263 says: > > die "MySQL version too old" unless($version =~ /^4\./); > > > > Now that MYSQL V 5 is supported, I think that check needs to be fixed. > > Drat, thought I got all those. Fixed i

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread Rob Kinyon
On 2/28/06, John Siracusa <[EMAIL PROTECTED]> wrote: > Ron Savage is working on Oracle support for Rose::DB. He's currently > implicitly setting the schema() to the username(), but I'm not sure that's > such a great idea. Where we run into problems is in the list_tables() > method where the schem

Re: [RDBO] Oracle username vs. schema

2006-02-28 Thread Rob Kinyon
On 2/28/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 2/28/06 9:46 AM, Rob Kinyon wrote: > > Schema should default to username, but should be overridable. In other > > words, set it as normal, but in the intializer, set it to username if > > unset. > > Okay

Re: [RDBO] Q: State of Oracle support

2006-03-01 Thread Rob Kinyon
On 3/1/06, Ron Savage <[EMAIL PROTECTED]> wrote: > I've installed a client - subcommander - but haven't used it yet. If you're on Win32, use TortoiseSVN. Rob --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that

Re: [RDBO] Catalyst::Model::RDBO ?

2006-03-09 Thread Rob Kinyon
On 3/8/06, John Siracusa <[EMAIL PROTECTED]> wrote: > Do many people use the helpers and scaffolding? I always imagined that > people might use those to play with, but then write stuff form scratch when > creating their first real app. Having done some Rails work, you do really use the scaffoldin

Re: [RDBO] Catalyst::Model::RDBO ?

2006-03-10 Thread Rob Kinyon
On 3/9/06, Sean Davis <[EMAIL PROTECTED]> wrote: > On 3/9/06 3:56 PM, "Rob Kinyon" <[EMAIL PROTECTED]> wrote: > > > On 3/8/06, John Siracusa <[EMAIL PROTECTED]> wrote: > >> Do many people use the helpers and scaffolding? I always imagined that &