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
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()
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
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
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'
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
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
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
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
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
>
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
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?
>
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
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
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
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
> >>
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
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
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
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
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
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
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
&
23 matches
Mail list logo