Re: [RDBO] Q: State of Oracle support

2006-03-02 Thread Ron Savage
On Fri, 03 Mar 2006 00:19:40 -0500, John Siracusa wrote: Hi John Spooky. -- Ron Savage [EMAIL PROTECTED] http://savage.net.au/index.html --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends application

Re: [RDBO] Q: State of Oracle support

2006-03-02 Thread John Siracusa
On 3/3/06 12:11 AM, Ron Savage wrote: > But how come it doesn't ask me to authenticate when I upload a changed file? My guess is that it somehow found your ssh keys or you SF.net login name in a browser cookie or some crazy thing. Also, after I authenticate using even the regular svn command-line

Re: [RDBO] Q: State of Oracle support

2006-03-02 Thread Ron Savage
On Wed, 1 Mar 2006 22:28:42 -0500, Rob Kinyon wrote: Hi Rob > If you're on Win32, use TortoiseSVN. Using it. Looks good. But how come it doesn't ask me to authenticate when I upload a changed file? Even John Siracusa gets asked if he changes to an account which is not logged in to SVN. I foun

Re: [RDBO] Q: State of Oracle support

2006-03-01 Thread Ron Savage
On Wed, 1 Mar 2006 22:28:42 -0500, Rob Kinyon wrote: Hi Rob >> I've installed a client - subcommander - but haven't used it yet. >> > If you're on Win32, use TortoiseSVN. I very nearly installed that instead, since I'd read good things about it. I'll do that now. -- Ron Savage [EMAIL PROTECTED]

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] Q: State of Oracle support

2006-03-01 Thread Ron Savage
On Wed, 01 Mar 2006 19:21:00 -0500, John Siracusa wrote: Hi John > Great :) Are you set up with SVN yet? I've installed a client - subcommander - but haven't used it yet. -- Ron Savage [EMAIL PROTECTED] http://savage.net.au/index.html ---

Re: [RDBO] Q: State of Oracle support

2006-03-01 Thread John Siracusa
On 3/1/06 6:34 PM, Ron Savage wrote: > I've gained 'create view' privilege since I sent you that code, and have > activated the commented-out references to views in list-tables.t, and those > aspects of the tests now pass also. Great :) Are you set up with SVN yet? -John

Re: [RDBO] Q: State of Oracle support

2006-03-01 Thread Ron Savage
On Thu, 23 Feb 2006 19:47:33 -0500, John Siracusa wrote: Hi John I've gained 'create view' privilege since I sent you that code, and have activated the commented-out references to views in list-tables.t, and those aspects of the tests now pass also. -- Ron Savage [EMAIL PROTECTED] http://savage.n

Re: [RDBO] Q: State of Oracle support

2006-02-23 Thread John Siracusa
On 2/23/06 6:23 PM, Ron Savage wrote: > o Rose::DB::Pg calls DateTime::Infinite::Past etc, so shouldn't it 'use' > DateTime? Yeah, it should. (Well, DateTime::Infinite actually.) It gets away with not calling it because it uses Rose::DB which uses Rose::DateTime::Util which uses DateTime::Infini

Re: [RDBO] Q: State of Oracle support

2006-02-23 Thread Ron Savage
Hi Folks OK. I've set up a few files so Oracle is a supported vendor. I copied pg.t to oracle.t and cut out almost everything :-) so just 30 tests (all those remaining) pass. Now: o Rose::DB::Pg calls DateTime::Infinite::Past etc, so shouldn't it 'use' DateTime? o In t/test-lib.pl some connexio

Re: [RDBO] Q: State of Oracle support

2006-01-29 Thread John Siracusa
On 1/30/06 12:27 AM, Ron Savage wrote: > Looking at Rose::DB::Pg, I see we'll need a DateTime::Format::Oracle. Technically, you don't "need" such a thing. It just so happens that it was convenient to use an existing DateTime parser/formatter module for Pg. If no such thing exists for Oracle, the

Re: [RDBO] Q: State of Oracle support

2006-01-29 Thread Ron Savage
On Wed, 25 Jan 2006 09:02:55 +1100, Ron Savage wrote: Hi > Yeah. It's 9 am here now so I'll ask at work today if I can have a > database (aka ) set up to play with. But > I'd be the only one who could access it. OK. I have a tablespace just for this project. Looking at Rose::DB::Pg, I see we'll

Re: [RDBO] Q: State of Oracle support

2006-01-26 Thread Todd Hepler
Rob Kinyon wrote: I would recommend, on the first pass at least, to not worry about BEFORE INSERT triggers. Just get: select .nextval from dual; working before the insert statement, where SEQUENCE_NAME is specified by the user. Yeah, that sounds the simplest. But if the trigger-based

Re: [RDBO] Q: State of Oracle support

2006-01-25 Thread Ron Savage
On Wed, 25 Jan 2006 15:14:58 -0500, Rob Kinyon wrote: Hi Rob >> (BTW, anyone know why dual is named dual?) >> > No clue. :-) Me neither, but at a guess I'd say the language designers were uncomfortable calling it manifold, which is it's behaviour given that it impersonates many (manifold) unreal

Re: [RDBO] Q: State of Oracle support

2006-01-25 Thread Ron Savage
On Tue, 24 Jan 2006 18:58:01 -0500, Rob Kinyon wrote: Hi Rob Our sys admin only works Mondays, Tuesdays and Thursdays, so yesterday (Wed) I could not talk to her, and today is a national holiday, so it'll be next Monday before I discuss a new tablespace. -- Cheers Ron Savage, [EMAIL PROTECTED] on

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] Q: State of Oracle support

2006-01-25 Thread John Siracusa
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? > > In my experience, it's best way is to select the nextval from the

Re: [RDBO] Q: State of Oracle support

2006-01-25 Thread John Siracusa
On 1/25/06, Todd Hepler <[EMAIL PROTECTED]> wrote: > DBI needs a constraint_info() or unique_info() or somesuch, IMHO. Yeah, another API for DBD authors not to implement. (not that I'm bitter... ;) -John --- This SF.net email is sponsored by:

Re: [RDBO] Q: State of Oracle support

2006-01-25 Thread Todd Hepler
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? In my experience, it's best way is to select the nextval from the sequence before doing the insert, and then providing tha

Re: [RDBO] Q: State of Oracle support

2006-01-25 Thread Todd Hepler
John Siracusa wrote: 4) The information schema is going to make you drool Does DBD::Oracle support all of DBI's various *_info() methods correctly? That alone would make auto-init 90% done, since the default Auto.pm implementation just uses DBI's native introspection. All we'd have to add i

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:29 -0500, Rob Kinyon wrote

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread Ron Savage
On Tue, 24 Jan 2006 15:49:29 -0500, Rob Kinyon wrote: Hi Rob Yeah. It's 9 am here now so I'll ask at work today if I can have a database (aka ) set up to play with. But I'd be the only one who could access it. >> Does DBD::Oracle support all of DBI's various *_info() methods correctly? This see

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 > server to play with. I'm game if/when I get ac

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread John Siracusa
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 server to play with. I'm game if/when I get access to an Oracle database. I hear there's a "personal server

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 John Siracusa
On 1/24/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > Heh. It's a little more complicated than that. You have to create a > BEFORE INSERT trigger to read the next value from the sequence and set > the ID to it. Well, whatever gymnastics the db owner has to go through to set up the tables in the firs

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 > > my consulting career, I've never encountered a

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread John Siracusa
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 > my consulting career, I've never encountered anything before 9.2 > (except in extreme legacy cases where I

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 the most popular version of Oracle thes

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread John Siracusa
On 1/24/06, Sean Davis <[EMAIL PROTECTED]> wrote: > I'm not an Oracle user and, like John, do not have access to it, but is > there precedent for someone who does have access to open a database for John > et al. for development purposes? This is probably a dumb idea and is laden > with security an

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread Sean Davis
On 1/24/06 10:39 AM, "John Siracusa" <[EMAIL PROTECTED]> wrote: > > Anyway, like I said, baby steps. Start by implementing the Rose::DB > public API in a new Rose::DB::Oracle module. While that's happening, > it'd be great iif someone could post the various Oracle-isms discussed > above to th

Re: [RDBO] Q: State of Oracle support

2006-01-24 Thread John Siracusa
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 the most popular version of Oracle these days? > Oracle doesn't have a LIMIT syntax, though it can b

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] Q: State of Oracle support

2006-01-24 Thread John Siracusa
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 deal of time available to do the typing, if the > answer to the p