Re: Open source WO - offer

On Sep 4, 2006, at 10:12 AM, Andrus Adamchik wrote:

>  The differences are in details. Here is a few that I can think of  
> right away (aside from the license):
>
> * More databases are supported by Cayenne.
> * Database type selection is automatic (no need to edit  
> configuration when deploying the same app to a different db).
> * Better raw SQL queries: scriptable; support for configuration of  
> multiple DB dialects in the same query.
> * "Local JNDI" mode that allows to work with JNDI model in the  
> absence of a container.

Forgot a few more things:

* Cayenne stack supports running custom query classes, so you can  
extend standard query behavior, or implement custom database "commands".
* Cross-VM cache synchronization is built in.
* Caching query lists (EOF only offers caching individual objects)
* Paginated queries (I believe this is available via Wonder?)
* (3.0 only) Pluggable cache implementation. So you can have a single  
external managed cache, such as OSCache, used for many things, ORM  
being only one of them. This is great for CMS-like apps.

Andrus