perldb-developers

[pdb-dev]Re: The Perl DB

[Matthew W. <li...@wi...>]

Perhaps this...

    http://use.perl.org/article.pl?sid=01/05/16/1915255

is an opportunity for some PerlDBness to happen? Jeff, if you
have ideas for SQL::Statement that you've got a sketch of a plan
for, but not yet any time to flesh out of implmenent, you could
maybe present them there if you'll be attending.

Maybe other useful bits could get thrown in the pot.

Maybe the PerlDB project as a whole could be brought up in that
context and someone who hadn't happened to hear of it before then
but who had interest ability and tuits to take the reins could do so.

worth a thought.

-matt

Re: [pdb-dev]The Perl DB

[Jeff Z. <je...@vp...>]

Andy Duncan wrote:
> 
> 
> > Is this list / project stalled or have I just dropped off the list?
> 
> Maybe Jeff Zucker is the man, if he's listening in?

Yep, listening.

Here's the deal from my end:  I am madly trying to finalize DBD::AnyData
and various things (especially the vastly improved XML side of it) have
slowed me down.  I really do hope to have it out within the next month.

As planned, AnyData is based on an open framework that allows various
kinds of storage and various kinds of data formats to be plugged in to
it.  In that sense it can perhaps serve as a start towards PerlDB.  But
it is still based on SQL::Statement which has many limitations in terms
of flexibility of storage options and in terms of its SQL capabilities
and in terms of its C foundataion.  I still intend to tackle it once
AnyData is released but I will *certainly* need help on it.

I don't in any way want to be the sticking point of PerlDB.  If others
are ready to go on any part of it, more power to them, and I'll do what
I can to assist.

I'm also open to any suggestions about sharing the work on other aspects
of AnyData, or SQL::Statement or, other approaches if those are of any
use in the PerlDB quest.  If someone wants to either take "ownership" or
just lend a hand on of any of those things, please let me know.

-- 
Jeff

Re: [pdb-dev]The Perl DB

[Andy D. <and...@ya...>]

Hi Simon,

> Is this list / project stalled or have I just dropped off the list?

Well, from this end, stalled I'm afraid.  If you or A.N.Other would like to
pick up the baton, I only managed to carry 5 or so yards, you might like to
take it up?

Maybe Jeff Zucker is the man, if he's listening in?  I'll contact Jeff directly
shortly, to see if he'd like to take it up, and incorporate it as part of the
DBD::AnyData project, which would seem to be its natural home.

Personally, I've just got myself in too many other things (including a 14 month
old daughter, and 3 and a half year old son).  C'est la guerre.

HTH! :-)

Rgds,
AndyD

=====
and...@ya...

O'Reilly's "Oracle and Open Source": 
=> http://www.oreilly.com/catalog/oracleopen/

Orac, Perl/Tk and Perl DBI Database DBA & Development Tool: 
=> http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

RE: [pdb-dev]The Perl DB

[Garrett G. <ga...@sc...>]

It appears to be dead.

Last progress was that Jeff Zucker volunteered his DBIx::AnyData
(http://www.vpservices.com/jeff/programs/AnyData/) as the foundation on
which to build PerlDB.

Unfortunately it appears our desires for a Perl Database have yet to be met
by people who are capable, interested, and able to commit time to
implementing it.

[pdb-dev]The Perl DB

[Simon O. <sim...@um...>]

Is this list / project stalled or have I just dropped off the list?


-- 
   Simon Oliver

[pdb-dev]Re: DBD::RAM and DBD::AnyData

[Jeff Z. <je...@vp...>]

Tim Bunce wrote:
> 
> [snip recap of opening DBD::RAM for other authors to write plug-in parsers
> and storage managers and renaming it to either AnyData or PerlDB]
>
> I like it. I think I'd prefer 'AnyData' over 'PerlDB' (and anyway, isn't
> PerlDB the name of a seperate project?)

The suggestion to use the PerlDB name came from Andy Duncan and I'm
neutral on it.  He based the suggestion on the fact that the PerlDB
project is currently inactive and having something specific to work with
will hopefully spark some activity and on the idea that the way I am
opening up AnyData for other authors to create a variety of data parsers
and a variety of storage managers can be extended to this kind of
broader framework:

   DBD::PerlDB --+-- various Data parsers  ----- PerlDB::Parser::*.pm  
(1)
                 |
                 +-- various Storage managers -- PerlDB::Storage::*.pm 
(2)
                 |
                 +-- various SQL parsers ------- PerlDB::SQLparse::*.pm
(3)
                 |
                 +-- various SQL executors ----- PerlDB::SQLexec:: *.pm
(4)
                 

A version of #1 and #2 will be part of the coming AnyData release and
versions of #3,#4 will be part of it as soon as I (or others who join
the project) have time to get back to my re-write of SQL::Statement in
Parse::RecDescent/Parse::Yapp.

I *do* know that the kinds of parsers and storage managers I am using in
RAM/AnyData are basically toys compared to what will be needed for the
final PerlDB and that the key will be defining the API that plugs those
submodules into the main DBD.  But it seems that what I have going so
far could be a springboard into that and it also seems that it would be
nice for the final PerlDB to cover a wide range of pure-Perl database
options including the simple file-based things I am working on as well
as more sophisticated things like direct Berkeley_DB access.

In either case, my interest is in seeing the PerlDB succeed as a group
effort so I'll go with whatever naming convention works best to meet
that goal.

<regis>Your final answers?</regis>

-- 
Jeff

[pdb-dev]Re: RFC: DBD::AnyData.pm and AnyData.pm (formerly DBD::RAM)

[Andy D. <and...@ya...>]

Hi Jeff,

> I am approaching being ready to release a new version of DBD::RAM that
> opens the future development of the module up to the DBI/Perl
> community.  

Fantastic News! :-)

> Andy Duncan has suggested that I simply name the thing PerlDB .  I'll
> leave that up to y'all to decide if that is a good thing to do.  And if
> it is, what should the namespace look like?  If not, is the AnyData
> namespace I've illustrated above ok?

If you decide to turn this into a CVS project, with you becoming head
code-merger and maintainer, can I volunteer to set the site up for you on
SourceForge, look after the mailing lists etc, and become a registered
developer/tester etc?  If you and the community decide to call the whole suite
of modules, PerlDB, that'll be easiest, as the site's already there! :-)

But whatever the name is, I'd like to get on board.  I can't do much to help
you and Martyn with the back-end wizardry, as it's all a bit->over my $head;
but I could manage the odd GUI front-end in Perl/Tk (maybe using Frank Holtry's
pplug?), or some documentation accessible via the web, or whatever (pints of
lime and soda a speciality)?

I'll update the http://www.perldb.com/ website today, to link to your CPAN
homepage, so people can get hold of your downloads.  Do you have any home site
web page you'd also like me to point the site at?

Rgds,
AndyD

__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/

[pdb-dev]DBD:RAM developments

[Jeff Z. <je...@vp...>]

Hi all,

I've posted some major changes in DBD::RAM to the DBI lists including a
name change and a major opening of the API to other authors.  Andy has
suggested calling it PerlDB and I am neutral on that suggestion so
please join in the discussion and let me know your thoughts.  Regardless
of the naming, I am hoping that this can be a jump start for the perlDB
project and that by opening the API I can step out of the way more and
encourage others to join in.

I assume that everyone on this list is on the DBI list so I'm not
posting the full thing here.  If you are on this list but not the DBI
list and would like to see it, let me know.

-- 
Jeff

Re: [pdb-dev]CVS write rights (Botfly) [REPOST]

[Seth M. L. <se...@jo...>]

On Thu, Jun 01, 2000 at 02:37:01PM -0500, Garrett Goebel wrote:
> Andy, Seth,
> 
> Is it just me and my CVS incompetence... or am I lacking 
> write rights to the CVS repository? I keep getting error
> messages to that effect. If this is the case, can you
> grant write rights to developers?

Garrett,
	According to the admin page, you have CVS write access.  Could you
tell me (here or in private) what you are doing and what the error
messages you get are?  
	Are you using unix?  If so, what is your CVSROOT and CVS_RSH
variables set to?

	I'm lurking and more than a little swamped right now, so I haven't
been able to follow as much as I want.  However, if there is any
administration to be done, please (and this is to everyone) let me know
via private email. 

-Seth
--
"It is by will alone I set my mind in motion"

[pdb-dev]CVS write rights (Botfly) [REPOST]

[Garrett G. <ga...@sc...>]

Andy, Seth,

Is it just me and my CVS incompetence... or am I lacking 
write rights to the CVS repository? I keep getting error
messages to that effect. If this is the case, can you
grant write rights to developers?

I don't know if James Maes' work is based on mine, but those of us
interested in the Gadfly port have been making pretty fragmented
efforts. It sounds like James has been making more progress than
any of us, so by all means help us set up a botfly module in the
CVS repository so he can check his code in.

thanks,

Garrett

P.S. It'd also be nice if someone could improve on a PerlDB 
specific version of the poor Sourceforge documentation for
doing cvs and ssh on Win32. http://sfdocs.sourceforge.net/sfdocs/

Re: [pdb-dev]Where did this list go?

[Andy D. <and...@ya...>]

Hi Jeffrey,

I think the initial lack of a seed program to build upon has thrown us out a
bit, and we'll probably have to get to this point first, via several
alternative individual clusters and get that bell on that cat, before we can
begin to accelerate and build around whatever materialises.  

> I think everything is stilll going. Perosnlay I am working on the gadfy
> port, and am about ready to post the outline of creation for it.  The
> struture of it is coming along nicly and I think the coders and I should
> have something to really start on soon.

It looks like James is on the case, on this one! :-)  Can't wait to see his
plans.

I think the old time problem has hit a lot of us too, with explosive worldwide
software developments in all areas, now that Y2K is over, and I'm sure this has
taken a lot of people's priority work time.  But hopefully the idea of a
complete database written in Perl is too strong to be resisted, and overcomes
this and other constraints.

If you want to be taking a look at something in the meantime, you may want to
take a look at Jeff Zucker's latest DBD::RAM release. 

=> http://www.perl.com/CPAN-local//modules/by-module/DBD/
(DBD-RAM-0.072.tar.gz)

This was only released in the last few days and it's pretty amazing, almost a
complete Perl database by itself?  You might want to see if you can think of a
way of adding on new storage module onto this, such as Berkeley v3, which could
be the thing for multi-user solutions, involving lock contentions and fast
access?

Personally speaking, I've painted myself into a corner recently, taking on too
many things, and then failing to balance any of them against my wife's
requirements, but I'm currently trying to write a Client/Server system (Anubis)
based upon DBD::RAM, to provide a persisent database, based upon Messaging and
Remote Procedure Calls.  

=> http://download.sourceforge.net/perldb/

This is currently a pretty primitive client/server set-up, and I'm going to try
and provide a much more robust DBI type API to this, so any Perl program can
call this persistent server, in the same way you might try and call a MySQL
server.  But I'm more of a drinks tray carrier, than a hard-core Perl
programmer, and it could be some time before this comes to fruition, and maybe
by then we'll have all joined James's bandwagon? :-)

Go James! 8)

Rgds,
AndyD

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

Re: [pdb-dev][BUG] When I attempt to run the server (0.04)

[Andy D. <and...@ya...>]

Hi Tom,

Ah.

Looks like I better get working on Anubis-0.05 pronto 8-)

Rgds,
AndyD

--- "Lowery, Thomas" <tl...@ds...> wrote:
> 364:        my $result = eval { $stmt->execute($sth, $params); };
>   DB<3> x $stmt
> 0  DBD::RAM::Statement=HASH(0x9497b2c)
>    'params' => ARRAY(0x94a41d0)
>         empty array
>    'statem' => 'SELECT TABLE_NAME FROM PDB_TABLE'
>    'stmt' => 157482272
>   DB<4> n
> DBD::File::st::execute(C:/Perl/site/5.6.0/lib/DBD/File.pm:364):
> 364:        my $result = eval { $stmt->execute($sth, $params); };
>   DB<4> n
> DBD::RAM::st execute failed: Unknown column: PDB_TABLE.TABLE_NAME at
> C:/Perl/sit
> e/5.6.0/lib/SQL/Statement.pm line 52, <GEN1> line 1.
> DBD::File::st::DESTROY(C:/Perl/site/5.6.0/lib/DBD/File.pm:429):
> 429:        undef;
>   DB<4>         q
> 
> C:\DevStudio\MyProjects\perl\anubis-0.04>
> 
> 
> _______________________________________________
> Perldb-developers mailing list
> Per...@li...
> http://lists.sourceforge.net/mailman/listinfo/perldb-developers


=====
The Perl Database
=> http://www.perldb.com/

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

[pdb-dev][BUG] When I attempt to run the server (0.04)

[Lowery, T. <tl...@ds...>]

364:        my $result = eval { $stmt->execute($sth, $params); };
  DB<3> x $stmt
0  DBD::RAM::Statement=HASH(0x9497b2c)
   'params' => ARRAY(0x94a41d0)
        empty array
   'statem' => 'SELECT TABLE_NAME FROM PDB_TABLE'
   'stmt' => 157482272
  DB<4> n
DBD::File::st::execute(C:/Perl/site/5.6.0/lib/DBD/File.pm:364):
364:        my $result = eval { $stmt->execute($sth, $params); };
  DB<4> n
DBD::RAM::st execute failed: Unknown column: PDB_TABLE.TABLE_NAME at
C:/Perl/sit
e/5.6.0/lib/SQL/Statement.pm line 52, <GEN1> line 1.
DBD::File::st::DESTROY(C:/Perl/site/5.6.0/lib/DBD/File.pm:429):
429:        undef;
  DB<4>         q

C:\DevStudio\MyProjects\perl\anubis-0.04>

[pdb-dev]CVS write rights (Botfly)

[Garrett G. <ga...@sc...>]

Andy, Seth,

Is it just me and my CVS incompetence... or am I lacking write rights to the
CVS repository? I keep getting error messages to that effect. If this is the
case, can you grant write rights to developers?

I don't know if James Maes' work is based on mine, but those of us
interested in the Gadfly port have been making pretty fragmented efforts. It
sounds like James has been making more progress than any of us, so by all
means help us set up a botfly module in the CVS repository so he can check
his code in.

thanks,

Garrett

P.S. It'd also be nice if someone could improve on a PerlDB specific version
of the poor Sourceforge documentation for doing cvs and ssh on Win32.
http://sfdocs.sourceforge.net/sfdocs/

Re: [pdb-dev]Where did this list go?

[James M. <jm...@sp...>]

I think everything is stilll going. Perosnlay I am working on the gadfy
port, and am about ready to post the outline of creation for it.  The
struture of it is coming along nicly and I think the coders and I should
have something to really start on soon.







 
 
------------------------------------
|| James Maes                     ||
|| Systems/Database Programmer    ||
|| mailto: jm...@sp... ||
|| The Sporting News              ||
|| www.sportingnews.com           ||
------------------------------------ 

On Sun, 28 May 2000, Jeffrey Horn wrote:

> Has everyone moved to another list?  I haven't got any email on this list
> since 5/10.  Is this project still alive?  I am very interested in working on
> logging and locking systems for the database!
> 
> -- Jeff
> 
> _______________________________________________
> Perldb-developers mailing list
> Per...@li...
> http://lists.sourceforge.net/mailman/listinfo/perldb-developers
> 

[pdb-dev]Where did this list go?

[Jeffrey H. <ho...@cs...>]

Has everyone moved to another list?  I haven't got any email on this list
since 5/10.  Is this project still alive?  I am very interested in working on
logging and locking systems for the database!

-- Jeff

[pdb-dev]Anubis-0.04 Released - No More Reliance on CGI

[Andy D. <and...@ya...>]

Hi Steve,

Following on from your earlier question on CGI reliance, I took a look at
mod_perl and realised I might've been over-complicating things a bit with
Anubis.  In response, I've heavily simplified this latest release down to:

1 TCP/IP database server (using IO::Socket)
1 TCP/IP database client (using Term::Readline)

You can download anubis-0.04.tar.gz (only 7kb) from:
=> http://download.sourceforge.net/perldb/

I've tried to get as much installation information as I could into the README
file, but basically you:

*. Run create_pdb.pl to create the initial database dictionary
*. Run anubis_server.pl in the background to run a TCP/IP database server
daemon
*. Run anubis_client.pl to run a dbish-like client in the foreground to
interract with the database server and do stuff.

And that's about it, with hopefully minimal requirements of:

Perl5
DBD-RAM
TCP/IP running on your local (andor remote) host

It's all still very experimental but I think it's definitely getting somewhere.
 I'm still groping blindly in the dark a bit, like a heavily sedated amoeba,
towards a forking TCP/IP server, which gives each calling client a dedicated
connection, but once that hurdle is cleared, we can try and make much more use
of Jeff Zucker's rapidly expanding DBD-RAM functionality, ramp up some Perl/Tk
clients andor start building a DBD::Anubis driver, to give an initial minimal
set of DBI hook functions into the new daemonesque database server, perhaps
with an interim target of getting dbish to work with it, as for other
databases.

If anyone would like to help Hugo and I push this thing trolley along further,
please let me know.  IO::Socket gurus who know how to create $dbh database
handles, created by DBD::RAM, accessible over forked TCP/IP links, will *not*
be asked for references :-) :-) :-)

Rgds,
AndyD

PS. Thank goodness for the Perl Cookbook.  May Tom Christiansen and Nathan
Torkington be blessed in their blessedness.

=====
The Perl Database
=> http://www.perldb.com/

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

[pdb-dev]Pure Perl database server?

[Andy D. <and...@ya...>]

Hi Everyone,

I'm currently researching various Perl server programs, to see if there's one
available, outside of hitching a ride on the Apache mod_perl httpd backbone,
which can be adapted to provide a pure perl database server, and constant $dbh
type connections, which calling programs (such as dbish) can make use of.

Does anybody know of any such thing?  I did read there was a webserver called
Plexus, which could be the thing.  Is there anything else out there?

rgds,
andyd

=====
The Perl Database
=> http://www.perldb.com/

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

Re: [pdb-dev]A tk GUI for Anubis

[Andy D. <and...@ya...>]

Hi Hugo,

> New location:
> http://www.colba.net/~casanova/perldb/anubis.ui

Hey, you'll put us Perl/Tk Perl DBI programmers out of work, with this SpecPerl
approach! :-)

Looking good.

rgds,
ad.

=====
The Perl Database
=> http://www.perldb.com/

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

Re: [pdb-dev]A tk GUI for Anubis

[Hugo L. C. <hug...@ya...>]

--- Jeff Zucker <je...@vp...> wrote:
> I think you need to name the file something other
> than .pl for us to be
> able to download it.  The server treats it as a
> server-side script and
> tries to run it.

New location:
http://www.colba.net/~casanova/perldb/anubis.ui

Sorry!

Hugo.

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

[pdb-dev]A tk GUI for Anubis

[Hugo L. C. <hug...@ya...>]

Hi there,

Here I have some sort of TK GUInterface for Anubis,
based on the CGI interface currently used.

It's not hooked to the program yet, I didn't have the
time for this but all the widgets are there.

You can get it from:
http://www.colba.net/~casanova/perldb/anubis_ui.pl

I used SpecTcl in Perl mode (a gui interface to create
gui interfaces) to create it. And edited it after in
emacs(Linux) and bbedit(MacOS).

Check it out!

Hugo. 

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

Re: [pdb-dev]I don't know if this could interest you?

[Tim B. <Tim...@ig...>]

On Fri, May 05, 2000 at 07:46:55AM -0700, Hugo L. Casanova wrote:
> Check it out it points out some features users want.
> 
> http://openacs.org/why-not-mysql.html
> by Ben Adida
> 
> I know we're not at the point in time for features yet
> but it's still in the database field!

But lets not get into that topic here. It's not worth it and not
very relevant in PerlDB's pluggable architecture.

Tim.

[pdb-dev]I don't know if this could interest you?

[Hugo L. C. <hug...@ya...>]

Check it out it points out some features users want.

http://openacs.org/why-not-mysql.html
by Ben Adida

I know we're not at the point in time for features yet
but it's still in the database field!

I got the link from http://www.slashdot.org/

Hugo.

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

[pdb-dev]Re: Perldb-developers digest, Vol 1 #46 - 9 msgs

[Mano P. <man...@ya...>]

 Thanks;
   I am trying to call a sotered procedure from perl

It is giving error
DBD::ORACLE::st execute failed ora-06550.

 plese give a soloution.
 
Otherwise plese give some examle how to call a stored
procedure in perl program.
thanks



__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

RE: [pdb-dev]Using Perl 5.6 as the standard PerlDB base

[Autarch <au...@ur...>]

On Wed, 3 May 2000, Andy Duncan wrote:

> latest DBD-RAM, that version of Perl works for me.  I don't know if 5.6 gives
> us anything particularly critical for our effort, except perhaps bug fixes for
> earlier Perl releases?  I'm trying to follow Jeff Zucker's amazing work as

Some things that might be nice include:

Unicode support (not quite there yet but hopefully getting better in a
future 5.6.x release)

lexical warnings

our (to replace use vars)


Of those, I'd say the first is potentially very useful (though not fully
implemented), the second would be very nice to have, and the third is nice
but not compelling in and of itself.


-dave

/*==================
www.urth.org
We await the New Sun
==================*/