You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by Ray Zimmerman <rz...@cornell.edu> on 2001/05/10 17:20:06 UTC
Object - RDBMS mapping tools and mod_perl
I'm looking for a good package to use for Object - RDBMS mapping in
the context of mod_perl and Mason. Something that will handled object
inheritance and nested objects, etc.
I'm aware of Tangram, Alzabo and SPOPS (not sure all these do what I
need) ... are there any others? Any particular reasons why any of
these may not play with with mod_perl/Mason?
Thanks,
--
Ray Zimmerman / e-mail: rz10@cornell.edu / 428-B Phillips Hall
Sr Research / phone: (607) 255-9645 / Cornell University
Associate / FAX: (815) 377-3932 / Ithaca, NY 14853
Re: Object - RDBMS mapping tools and mod_perl
Posted by Chris Winters <ch...@cwinters.com>.
* Ray Zimmerman (rz10@cornell.edu) [010510 11:39]:
> I'm looking for a good package to use for Object - RDBMS mapping in
> the context of mod_perl and Mason. Something that will handled object
> inheritance and nested objects, etc.
>
> I'm aware of Tangram, Alzabo and SPOPS (not sure all these do what I
> need) ... are there any others? Any particular reasons why any of
> these may not play with with mod_perl/Mason?
SPOPS plays very well with mod_perl -- it's an integral part of the
OpenInteract web application framework which (currently) depends on
mod_perl.
If you wind up using it, there's some initialization you'll probably
want to do at server startup and in the child init phase -- let me
know if you're interested and I'll pull the SPOPS-specific stuff out
of OpenInteract.
Chris
--
Chris Winters (chris@cwinters.com)
Building enterprise-capable snack solutions since 1988.
Re: Object - RDBMS mapping tools and mod_perl
Posted by Nathan Stitt <na...@allmed.net>.
Ray Zimmerman wrote:
> I'm looking for a good package to use for Object - RDBMS mapping in the
> context of mod_perl and Mason. Something that will handled object
> inheritance and nested objects, etc.
>
One that I've been meaning to try out when I get a chance is GOODS at:
http://www.ispras.ru/~knizhnik/goods.html I've never used it and have
never heard of anyone useing it either, but it looks intriging and has
perl bindings. I want to attempt to store XML trees in it, as I've yet
to find a good free sytem for storing arbitrary XML data.
If you do attempt to use it, please let me know how it works out.
Nathan
Re: Object - RDBMS mapping tools and mod_perl
Posted by Dave Rolsky <au...@urth.org>.
On Fri, 11 May 2001, Chris Winters wrote:
> > Anyone (including Chris) done a comparison of the two (SPOPS and
> > Tangram) and willing to comment on strengths, weaknesses,
> > differences, etc?
>
> That is an excellent idea and would be quite useful. I'll see what I
> can do in the (relatively) near future.
I started working on such a thing (comparing various persistence solutions
for Perl) a long time ago. You can see where I was at if you look at:
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/poop/documents/poop-comparison.pod?rev=1.2&content-type=text/vnd.viewcvs-markup
If you want to help it'd be much appreciated. The goal is to finish it,
turn it into HTML and stick it somewhere that people will see it
(poop.perl.org?)
-dave
/*==================
www.urth.org
We await the New Sun
==================*/
Re: Object - RDBMS mapping tools and mod_perl
Posted by Chris Winters <ch...@cwinters.com>.
* Ray Zimmerman (rz10@cornell.edu) [010511 08:01]:
> Using Dave Rolsky's OO-RDBMS vs RDBMS-OO sort of description of
> Tangram and Alzabo, it sounds like SPOPS is more in the same category
> as Tangram, correct?
That's correct. I think Tangram is more of a 'pure' object storage
solution than SPOPS is, and, IIRC, Tangram also requires you to modify
your table schema to use it.
> Anyone (including Chris) done a comparison of the two (SPOPS and
> Tangram) and willing to comment on strengths, weaknesses,
> differences, etc?
That is an excellent idea and would be quite useful. I'll see what I
can do in the (relatively) near future.
Chris
--
Chris Winters (chris@cwinters.com)
Building enterprise-capable snack solutions since 1988.
Re: Object - RDBMS mapping tools and mod_perl
Posted by Ray Zimmerman <rz...@cornell.edu>.
At 12:03 AM -0400 5/11/01, Chris Winters wrote:
>SPOPS is built to map objects to relational databases, or other data
>stores. If you're just getting/setting object properties and
>persistence (create/update/fetch/remove) along with relationships
>among the objects, you don't even need to write any Perl code. Just
>some fairly simple configuration info. Plus you can (if you wish) get
>per-object security for free.
Using Dave Rolsky's OO-RDBMS vs RDBMS-OO sort of description of
Tangram and Alzabo, it sounds like SPOPS is more in the same category
as Tangram, correct?
Anyone (including Chris) done a comparison of the two (SPOPS and
Tangram) and willing to comment on strengths, weaknesses,
differences, etc?
Thanks,
Ray
Re: [Mason] Object - RDBMS mapping tools and mod_perl
Posted by Chris Winters <ch...@cwinters.com>.
* Dave Rolsky (autarch@urth.org) [010510 12:43]:
> ...
> I think the author of SPOPS is also a mod_perl user (I'm pretty sure he's
> posted to the mod_perl list in the past) so I'd expect it to play nice.
Mostly one of the 'silent majority', tho :-) (Plus, we met at last
year's YAPC -- sheesh, the memories on some people! ;-)
(Sidenote: how many folks are going to YAPC this year?)
> ...
> I'm not sure exactly what the goal of SPOPS is, so I'll let the author
> speak for himself.
(gee, that sounds like an invitation to get out the...)
<soapbox>
SPOPS is built to map objects to relational databases, or other data
stores. If you're just getting/setting object properties and
persistence (create/update/fetch/remove) along with relationships
among the objects, you don't even need to write any Perl code. Just
some fairly simple configuration info. Plus you can (if you wish) get
per-object security for free.
IMO, it also works quite well in an environment where you need to
retrofit a framework onto an existing datastore, since SPOPS doesn't
require special fields or tables (unless you're using security).
</soapbox>
More upon request, or on the OpenInteract
(sourceforge.net/projects/openinteract/) mailing lists.
Chris
--
Chris Winters (chris@cwinters.com)
Building enterprise-capable snack solutions since 1988.
Re: [Mason] Object - RDBMS mapping tools and mod_perl
Posted by Dave Rolsky <au...@urth.org>.
On Thu, 10 May 2001, Ray Zimmerman wrote:
> I'm aware of Tangram, Alzabo and SPOPS (not sure all these do what I
> need) ... are there any others? Any particular reasons why any of
> these may not play with with mod_perl/Mason?
Well, I wrote Alzabo and it plays just fine with mod_perl and Mason. In
fact, the schema creation interface is a set of Mason components. The
caching/syncing architecture was specifically created to allow syncing of
objects between multiple processes (ala mod_perl) and I will be creating a
syncing module sometime that sync between multiple machines as well.
I think the author of SPOPS is also a mod_perl user (I'm pretty sure he's
posted to the mod_perl list in the past) so I'd expect it to play nice.
Tangram I don't know much about in relation to mod_perl.
However, these are all fairly different systems. I often descrive Alzabo
as the opposite of Tangram, for instance. Alzabo is an RDBMS-OO mapper
and Tangram is an OO-RDBMS mapper. Tangram is aimed at letting you have
transparent OO persistence in an RDBMS without worrying about the schema
too much. Alzabo is about taking an RDBMS and giving you access to it
through convenient object methods.
I'm not sure exactly what the goal of SPOPS is, so I'll let the author
speak for himself.
-dave
/*==================
www.urth.org
We await the New Sun
==================*/