Re: Stolen Ideas

[prev] [thread] [next] [Date index for 2004/08/10]

From: Tony Bowden
Subject: Re: Stolen Ideas
Date: 21:47 on 10 Aug 2004

On Tue, Aug 10, 2004 at 04:02:50PM -0400, Perrin Harkins wrote:
> For reference, my wanted feature list (in response to your use.perl.org
> comment) is here:
> http://use.perl.org/comments.pl?sid=21898&cid=33287

    * Built-in support for mapping of inheritance.

I'm not entirely sure what this means.

    * Efficient many-to-many support, including support for search
      criteria on the mapping table.

This shouldn't be too difficult. The hard part is syntax. There are some
patches on this already. I hope to have a variation of implementing this
as part of the advanced Class::DBI tutorial at YAPC::Europe.

    * Support for flexible object and query caching. (I plan to work on this.)

We've discussed the object caching, but what extra should we have on
query caching?

    * Built-in support for fetching a graph of related objects in one
      SQL statement (like the recent question on the mailing list about
      fetching an object and it's might_have relation in one shot).

Again, I think the hard part here is inteface rather than
implementation. Suggestions welcome!

    * Optimistic locking. This wouldn't be very hard to add, I think.

I've had a look at this a couple of times. When we have Attribute objects
working properly, which know not just their current value, but also the
one that they were created with, this should be trivial. I hope to have
these, in a basic form, in the next release.

    * More extensive support for collections, like delete_from_* (as
    * opposed to add_to_*) 

There are a couple of patches outstanding for this. delete_from_* only
really becomes useful when you've many-to-many (feel free to convince me
otherwise if this isn't actually true), but I need to think through the
implications of it more for complex joins.

		* and mapping of related objects to sets, rather than just arrays.

Again, I assume this is really to do with many-many and other complex
joins? If it's the problem I've had before, it's really just a matter of
changing the SQL generated from a simple SELECT __ESSENTIAL__ to a 
SELECT DISTINCT(__ESSENTIAL__), or am I missing the point?

> Other popular Java tools include Apache OBJ (http://db.apache.org/ojb/)
> and Cayenne (http://www.objectstyle.org/cayenne/).

Thanks. I'll have a look.

Tony

(message missing)

Stolen Ideas
Tony Bowden 18:58 on 10 Aug 2004

Re: Stolen Ideas
ed-cdbi 19:03 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 19:06 on 10 Aug 2004

Re: Stolen Ideas
ed-cdbi 19:08 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 19:11 on 10 Aug 2004

Re: Stolen Ideas
ed-cdbi 19:19 on 10 Aug 2004

RE: Stolen Ideas
Thomas, Mark - BLS CTR 19:11 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 19:27 on 10 Aug 2004

Re: Stolen Ideas
Nelson C. T. Ferraz 15:14 on 12 Aug 2004

Re: Stolen Ideas
Scott McWhirter 19:18 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 19:28 on 10 Aug 2004

Re: Stolen Ideas
Scott McWhirter 20:42 on 10 Aug 2004

Re: Stolen Ideas
Perrin Harkins 21:08 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 21:33 on 10 Aug 2004

Re: Stolen Ideas
Scott McWhirter 22:58 on 10 Aug 2004

Re: Stolen Ideas
Perrin Harkins 23:23 on 10 Aug 2004

Re: Stolen Ideas
Gregory P. Smith 19:55 on 10 Aug 2004

Re: Stolen Ideas
Perrin Harkins 20:02 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 21:47 on 10 Aug 2004

Re: Stolen Ideas
Perrin Harkins 22:23 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 22:37 on 10 Aug 2004

Re: Stolen Ideas
Perrin Harkins 22:57 on 10 Aug 2004

Re: Stolen Ideas
Yuval Kogman 15:39 on 11 Aug 2004

Re: Stolen Ideas
Tony Bowden 22:02 on 10 Aug 2004

Re: Stolen Ideas
ed-cdbi 22:11 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 22:25 on 10 Aug 2004

Re: Stolen Ideas
Tim Bunce 08:53 on 24 Aug 2004

Re: Stolen Ideas
Perrin Harkins 22:16 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 22:42 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 22:16 on 10 Aug 2004

Re: Stolen Ideas
Tony Bowden 23:18 on 10 Aug 2004

Re: Stolen Ideas
Scott McWhirter 23:48 on 10 Aug 2004

Re: Stolen Ideas
Perrin Harkins 00:22 on 11 Aug 2004

Re: Stolen Ideas
Perrin Harkins 03:45 on 11 Aug 2004

Re: Stolen Ideas
Tony Bowden 08:36 on 11 Aug 2004

Re: Stolen Ideas
Aaron Trevena 19:05 on 13 Aug 2004

Re: Stolen Ideas
Aaron Trevena 17:13 on 15 Aug 2004

Re: Stolen Ideas
Dan Friedman 04:47 on 11 Aug 2004

Re: Stolen Ideas
Tony Bowden 08:39 on 11 Aug 2004

Re: Stolen Ideas
Branislav Zahradnik 15:21 on 11 Aug 2004

RE: Stolen Ideas
Thomas, Mark - BLS CTR 19:13 on 13 Aug 2004

Re: Stolen Ideas
Tony Bowden 23:16 on 10 Aug 2004

Re: Stolen Ideas
Perrin Harkins 23:42 on 10 Aug 2004

Re: Stolen Ideas
Tim Bunce 08:48 on 24 Aug 2004

Re: Stolen Ideas
Tony Bowden 21:57 on 11 Aug 2004

Re: Stolen Ideas
Simon Cozens 09:03 on 24 Aug 2004