RFC: host for new m-l for a DBMS module
Hello, This email concerns an unreleased new Perl DBMS module/framework/engine that has separate Perl 5 and Perl 6 versions; the Perl 5 version is named QDRDBMS, and serves as a prototype for the Perl 6 version, which will have a different name, though the Perl 5 version is expected to be used soon in production for several years. This is a rewritten successor to my "Rosetta" project, whose name won't be used anymore. QDRDBMS has not yet been released on CPAN, and I don't intend to put it there until it is complete enough to support a simple working demo, though I hope that will happen some time in February. Meanwhile, its various pieces can be seen at http://darrenduncan.net/QDRDBMS/ as a work in progress. QDRDBMS is a self-contained fully-featured RDBMS implemented in Perl, a fact which is strongly emphasized. (FYI, see also Genezzo on CPAN.) But it has swappable engines (as DBI has swappable drivers), and with an appropriate engine substitution, the QDRDBMS API can alternately be used as a front for some other DBMS, such as what DBI and its wrappers do, and its API can be targeted by other wrappers. Or its query language / AST can used as an interchange language. QDRDBMS is not in managed version control yet, though I do manually make daily archives ... I plan to actually move it into version control a few days before the first CPAN release, where it would be subsequently maintained. Most likely, the version control system I will use is that which Rosetta is currently in, which is the utsl.gen.nz SVN server graciously provided by Sam Vilain. My main reason for writing this email is that I would like to have a reliable email discussion list setup for developers/users of QDRDBMS prior to the first CPAN release, so I can refer to it in my documentation as a place where to get help or make suggestions, and so discussion among co-developers can be centered there rather than being divided up among a variety of other mailing lists. This list will be specific to the Perl 5 version, not the Perl 6 one (though they would crossover at times). I would prefer to use a developer-focused server as is common already in the Perl community, and not use a general purpose server like Yahoo or Google. From what I have seen with existing database or Perl related lists, they tend to be either at perl.org, or at sourceforge, or at an owner-specific domain. While in the long term I will probably use an owner-specific domain (likely named after whatever the Perl 6 version will be called), during the first several years I can't do that. I would like suggestions to where I may be best to apply for a mailing list at an existing managed host. Currently, a perl.org address looks the most attractive to me, as that is where lists about DBI and Perl 6 are, and they have a lot of other lists besides. Since I have no intention of hosting my project at Sourceforge, I don't know if it possible to get a mailing list with them in isolation from a project, or maybe that isn't actually a problem with using them. Ideally, people would be able to view an archive of all list posts on the web, some how, and that it would be easy enough to transfer all the historical posts, with original email headers to a new host later if desired. Any feedback as to where or who I should best ask for a list host, or offers for said, are appreciated. Thank you in advance. -- Darren Duncan P.S. I'll also want to setup a designated IRC channel for the project also, though I anticipate that those will be trivial in comparison, and I can concern myself with it later. At least both freenode and perl.org seem to be setup that you can go to any channel name and the channel will just exist while people are there.
Positively Archaic Versions of DBI and DBD::Oracle
On 1/18/07, Peter J. Holzer <[EMAIL PROTECTED]> wrote: [...interesting stuff deleted...] > You can find DBI modules back to 1.13 at > > http://www.cpan.org/modules/by-authors/id/TIMB/ > > The Oracle versions only go back to 1.14 - and may not cover the latest ones > either; you can hunt those down yourself. You can find even older versions on BackPAN: http://backpan.cpan.org/authors/Tim_Bunce/ starts with DBI-0.89 and DBD-Oracle-0.47 from 1997. Only that far back? Would they be interested in DBI versions 0.69, 0.73, 0.74, 0.75, 0.77, 0.78, 0.79, and 0.81..0.88 too? I have them stashed away... I also have DBD::Oracle 0.43..0.46 too. I'd be happy to give them - ideas on who to contact? I don't see any information on who or how to submit such stuff at http://backpan.cpan.org/ - that just gives a directory listing. For DBD::Informix, I have all released (and probably some unreleased) versions back to 0.23, but they already seem to have those (or enough that the difference is unlikely to matter). The versions prior to 0.25 are under Alligator Descartes' directory, not mine. -- Jonathan Leffler <[EMAIL PROTECTED]> #include Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
DBD::Proxy - getting unitialized error for $numFields
### Perl: 5.008008(i386-freebsd) OS : freebsd (6.1-stable) DBI : 1.53 DBD::mysql : 3.0004 DBD::Sponge : 11.10 DBD::SQLite : 1.12 DBD::Proxy : 0.2004 DBD::Multiplex : 2.00 DBD::File : 0.35 DBD::ExampleP : 11.12 DBD::DBM: 0.03 DBD::CSV: 0.22 DBD::AnyData: 0.08 ## For every database call, do, execute, ...etc I get the warning, Use of uninitialized value in subroutine entry at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/i386-freebsd/DBD/Proxy.pm line 567. Which is " 'NUM_OF_FIELDS' => $numFields, ". I don't think this matters but, the proxy is connecting to DBD::Oracle, the connect is in another module that is inherited by the module I am testing. I am also getting disconnect errors on the DESTROY, (in cleanup) DBD::Proxy::db disconnect failed: Can't call method "disconnect" on an undefined value at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/i386-freebsd/DBD/Proxy.pm line 311 during global destruction. (in cleanup) DBD::Proxy::db DESTROY failed: Can't call method "disconnect" on an undefined value at /usr/local/perl-5.8.8/lib/site_perl/5.8.8/i386-freebsd/DBD/Proxy.pm line 311 during global destruction. My eyes are glazing over, so any help would be appreciated. I'm sure it is something simple I am missing here... Thanks. -- Scott T. Hildreth <[EMAIL PROTECTED]>
Re: DBD-ODBC.ppd
On Thu, 18 Jan 2007 11:14:11 +0100 (MET), Alexander Foken wrote: >http://ppm.activestate.com/PPMPackages/zips/ >http://search.cpan.org > >On 18.01.2007 10:32, Pamal Dias wrote: >> Hi, >> >> Please send me the DBD-ODBC.ppd file for perl 5.8.8. If that is not >> available please send me a the latest version available. Alexander didn't mention my favourite URL: Kobes' Search http://cpan.uwinnipeg.ca/search?query=DBD%3A%3AODBC&mode=module The section at the bottom of the page lists known locations where you can get the PPD file. -- Bart.
DBI upgrade from 1.52 to 1.53
Sorry, the subject is not correct so I changed it. TSHIMANGA Minkoka VAS Administrator Mobile: +243 814443113 Office: +243 813131347 Fax:+243 813010373 Email: [EMAIL PROTECTED] VODACOM CONGO (DRC) s.p.r.l. > -Original Message- > From: Tshimanga Minkoka [mailto:[EMAIL PROTECTED] > Sent: Thursday, 18 January 2007 11:36 > To: dbi-users@perl.org > Subject: RE: DBD-ODBC.ppd > > Hi All, > > I fail to upgrade the DBI from 1.52 to 1.53 with the errors below. I am on > Windows XP SP2. > > C:\dev>ppm upgrade DBI > Downloading ActiveState Package Repository packlist...not modified > DBI 1.53 (have v1.52) > Downloading DBI-1.53...done > Unpacking DBI-1.53...done > Generating HTML for DBI-1.53...done > Installing to site area...failed > ppm upgrade failed: File conflict; package DBD-File already provide > C:/Perl/html > /site/lib/DBD/File.html > > C:\dev>ppm query DBD-File > ┌──┬─┬─ > ───┬──┐ > │ name │ version │ abstract │ area │ > ├──┼─┼─ > ───┼──┤ > │ DBD-File │ 0.35│ Base class for writing DBI drivers │ site │ > └──┴─┴─ > ───┴──┘ > (1 package installed matching 'DBD-File') > > C:\dev>ppm query DBI > ┌──┬─┬─ > ┬──┐ > │ name │ version │ abstract│ area │ > ├──┼─┼─ > ┼──┤ > │ DBI │ 1.52│ Database independent interface for Perl │ perl │ > └──┴─┴─ > ┴──┘ > (1 package installed matching 'DBI') > > C:\dev>perl -v > > This is perl, v5.8.8 built for MSWin32-x86-multi-thread > (with 33 registered patches, see perl -V for more detail) > > Copyright 1987-2006, Larry Wall > > Binary build 819 [267479] provided by ActiveState http://www.ActiveState.com > Built Aug 29 2006 12:42:41 > > Perl may be copied only under the terms of either the Artistic License or the > GNU General Public License, which may be found in the Perl 5 source kit. > > Complete documentation for Perl, including FAQ lists, should be found on > this system using "man perl" or "perldoc perl". If you have access to the > Internet, point your browser at http://www.perl.org/, the Perl Home Page. > > C:\dev> > > TSHIMANGA Minkoka > VAS Administrator > Mobile: +243 814443113 > Office: +243 813131347 > Fax:+243 813010373 > Email: [EMAIL PROTECTED] > VODACOM CONGO (DRC) s.p.r.l. > > >
Re: Help Required:Installing DBI in Perl 5.005
On 2007-01-18 06:24:09 -0800, Jonathan Leffler wrote: > On 1/18/07, Mohd Naim <[EMAIL PROTECTED]> wrote: > >I have Perl 5.005 in Unix environment.I have no issues with running > >any PErl Script. > >But I cant access my Oracle Database(92) through Perl Script. > Why don't you do the sensible thing and upgrade to Perl 5.8.8? While I agree that this is probably a lot more sensible than trying to get a seriously outdated perl installation to play nicely with a reasonably current Oracle installation, that may not actually be the issue in this case: > >Its throwing error > >*Can't locate object method "connect" via package "DBI"* > > > >*Can't locate dbi.pm in @INC (@INC contains: ^^^ Note that perl is looking for "dbi.pm", not "DBI.pm" here. Looks like the OP wrote "use dbi" instead of "use DBI". [...] > You can find DBI modules back to 1.13 at > > http://www.cpan.org/modules/by-authors/id/TIMB/ > > The Oracle versions only go back to 1.14 - and may not cover the latest ones > either; you can hunt those down yourself. You can find even older versions on BackPAN: http://backpan.cpan.org/authors/Tim_Bunce/ starts with DBI-0.89 and DBD-Oracle-0.47 from 1997. hp -- _ | Peter J. Holzer| If I wanted to be "academically correct", |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgplNCooFqvnx.pgp Description: PGP signature
Just In case you missed it...
Josh Mcadams of PerlCast has posted the podcast of his interview with Tim at last summer's Oscon. http://www.perlcast.com/audio/Perlcast_Interview_038.mp3
Re: Help Required:Installing DBI in Perl 5.005
Why don't you do the sensible thing and upgrade to Perl 5.8.8? Presumably, you have a reason that seems sensible to you - though if you've not considered the option, you should do it, and do it now (where 'do' encompasses both 'think about installing Perl 5.8.8' and 'actually install Perl 5.8.8'). Assuming you can't upgrade (what was the reason again? you're kidding - you could upgrade!) you'll probably need to dig through the release notes for DBI to find the last version that supports Perl 5.5, and then obtain that source manually from the CPAN archive (not by trying to use CPAN or CPANPLUS modules). Then you'll need to obtain a compatible version of DBD::Oracle, and install that. You can find DBI modules back to 1.13 at http://www.cpan.org/modules/by-authors/id/TIMB/ The Oracle versions only go back to 1.14 - and may not cover the latest ones either; you can hunt those down yourself. On 1/18/07, Mohd Naim <[EMAIL PROTECTED]> wrote: Dear Friends, I am not having much experience in Perl except from programming. I have Perl 5.005 in Unix environment.I have no issues with running any PErl Script. But I cant access my Oracle Database(92) through Perl Script. Its throwing error *Can't locate object method "connect" via package "DBI"* *Can't locate dbi.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .) at PerlDatabaseConnection.pl line 10.* Please let me know which version of DBI shud I install and where can I get this. If we dont have Perl5.005 compatible DBI in market; then what is the other alternative... I also have posted the same in http://www.cpanforum.com/posts/4081 Regards Naim Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: Platform: osname=solaris, osvers=2.8, archname=sun4-solaris uname='sunos localhost 5.8 sun4u sparc sunw,ultra-1 ' hint=previous, useposix=true, d_sigaction=define usethreads=undef useperlio=undef d_sfio=undef Compiler: cc='cc', optimize='-xO3 -xdepend', gccversion= cppflags='' ccflags ='' stdchar='char', d_stdstdio=define, usevfork=false intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 alignbytes=8, usemymalloc=n, prototype=define Linker and Libraries: ld='cc', ldflags ='' libpth=/lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldl -lm -lc -lcrypt libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R /usr/perl5/5.00503/sun4-solaris/CORE' cccdlflags='-KPIC', lddlflags='-G' Characteristics of this binary (from libperl): Built under solaris Compiled at Dec 22 1999 00:00:57 @INC: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 -- Jonathan Leffler <[EMAIL PROTECTED]> #include Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
Help Required:Installing DBI in Perl 5.005
Dear Friends, I am not having much experience in Perl except from programming. I have Perl 5.005 in Unix environment.I have no issues with running any PErl Script. But I cant access my Oracle Database(92) through Perl Script. Its throwing error *Can't locate object method "connect" via package "DBI"* *Can't locate dbi.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .) at PerlDatabaseConnection.pl line 10.* Please let me know which version of DBI shud I install and where can I get this. If we dont have Perl5.005 compatible DBI in market; then what is the other alternative... I also have posted the same in http://www.cpanforum.com/posts/4081 Regards Naim Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: Platform: osname=solaris, osvers=2.8, archname=sun4-solaris uname='sunos localhost 5.8 sun4u sparc sunw,ultra-1 ' hint=previous, useposix=true, d_sigaction=define usethreads=undef useperlio=undef d_sfio=undef Compiler: cc='cc', optimize='-xO3 -xdepend', gccversion= cppflags='' ccflags ='' stdchar='char', d_stdstdio=define, usevfork=false intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 alignbytes=8, usemymalloc=n, prototype=define Linker and Libraries: ld='cc', ldflags ='' libpth=/lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldl -lm -lc -lcrypt libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R /usr/perl5/5.00503/sun4-solaris/CORE' cccdlflags='-KPIC', lddlflags='-G' Characteristics of this binary (from libperl): Built under solaris Compiled at Dec 22 1999 00:00:57 @INC: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005
Help Required:Installing DBI in Perl 5.005
Dear Friends, I am not having much experience in Perl except from programming. I have Perl 5.005 in Unix environment.I have no issues with running any PErl Script. But I cant access my Oracle Database(92) through Perl Script. Its throwing error *Can't locate object method "connect" via package "DBI"* *Can't locate dbi.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .) at PerlDatabaseConnection.pl line 10.* Please let me know which version of DBI shud I install and where can I get this. If we dont have Perl5.005 compatible DBI in market; then what is the other alternative... I also have posted the same in http://www.cpanforum.com/posts/4081 Regards Naim Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: Platform: osname=solaris, osvers=2.8, archname=sun4-solaris uname='sunos localhost 5.8 sun4u sparc sunw,ultra-1 ' hint=previous, useposix=true, d_sigaction=define usethreads=undef useperlio=undef d_sfio=undef Compiler: cc='cc', optimize='-xO3 -xdepend', gccversion= cppflags='' ccflags ='' stdchar='char', d_stdstdio=define, usevfork=false intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 alignbytes=8, usemymalloc=n, prototype=define Linker and Libraries: ld='cc', ldflags ='' libpth=/lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldl -lm -lc -lcrypt libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R /usr/perl5/5.00503/sun4-solaris/CORE' cccdlflags='-KPIC', lddlflags='-G' Characteristics of this binary (from libperl): Built under solaris Compiled at Dec 22 1999 00:00:57 @INC: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005
RE: DBD-ODBC.ppd
Hi All, I fail to upgrade the DBI from 1.52 to 1.53 with the errors below. I am on Windows XP SP2. C:\dev>ppm upgrade DBI Downloading ActiveState Package Repository packlist...not modified DBI 1.53 (have v1.52) Downloading DBI-1.53...done Unpacking DBI-1.53...done Generating HTML for DBI-1.53...done Installing to site area...failed ppm upgrade failed: File conflict; package DBD-File already provide C:/Perl/html /site/lib/DBD/File.html C:\dev>ppm query DBD-File ┌──┬─┬┬──┐ │ name │ version │ abstract │ area │ ├──┼─┼┼──┤ │ DBD-File │ 0.35│ Base class for writing DBI drivers │ site │ └──┴─┴┴──┘ (1 package installed matching 'DBD-File') C:\dev>ppm query DBI ┌──┬─┬─┬──┐ │ name │ version │ abstract│ area │ ├──┼─┼─┼──┤ │ DBI │ 1.52│ Database independent interface for Perl │ perl │ └──┴─┴─┴──┘ (1 package installed matching 'DBI') C:\dev>perl -v This is perl, v5.8.8 built for MSWin32-x86-multi-thread (with 33 registered patches, see perl -V for more detail) Copyright 1987-2006, Larry Wall Binary build 819 [267479] provided by ActiveState http://www.ActiveState.com Built Aug 29 2006 12:42:41 Perl may be copied only under the terms of either the Artistic License or the GNU General Public License, which may be found in the Perl 5 source kit. Complete documentation for Perl, including FAQ lists, should be found on this system using "man perl" or "perldoc perl". If you have access to the Internet, point your browser at http://www.perl.org/, the Perl Home Page. C:\dev> TSHIMANGA Minkoka VAS Administrator Mobile: +243 814443113 Office: +243 813131347 Fax:+243 813010373 Email: [EMAIL PROTECTED] VODACOM CONGO (DRC) s.p.r.l.
Re: DBD-ODBC.ppd
http://ppm.activestate.com/PPMPackages/zips/ http://search.cpan.org On 18.01.2007 10:32, Pamal Dias wrote: Hi, Please send me the DBD-ODBC.ppd file for perl 5.8.8. If that is not available please send me a the latest version available. Thanks in advance, Pamal. ___ New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes. http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk -- Alexander Foken mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/
DBD-ODBC.ppd
Hi, Please send me the DBD-ODBC.ppd file for perl 5.8.8. If that is not available please send me a the latest version available. Thanks in advance, Pamal. ___ New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes. http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk
