Re: Object - RDBMS mapping tools and mod_perl
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: Object - RDBMS mapping tools and mod_perl
* Ray Zimmerman ([EMAIL PROTECTED]) [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 ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.
Re: Object - RDBMS mapping tools and mod_perl
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.2content-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 ==*/
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: [EMAIL PROTECTED] / 428-B Phillips Hall Sr Research / phone: (607) 255-9645 / Cornell University Associate / FAX: (815) 377-3932 / Ithaca, NY 14853
Re: [Mason] Object - RDBMS mapping tools and mod_perl
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 ==*/
Re: Object - RDBMS mapping tools and mod_perl
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
* Ray Zimmerman ([EMAIL PROTECTED]) [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 ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.
Re: [Mason] Object - RDBMS mapping tools and mod_perl
* Dave Rolsky ([EMAIL PROTECTED]) [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 ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.