[Zope3-dev] RDB support

[Casey Duncan]

At a high level, Zope 2's model of SQL methods that share a data base 
adapter is pretty good, but I think in Zope 3 we need to make sure:

* The interface and contracts for database adapters are better defined. 
Database adapters should be "smarter" and do more to promote efficient 
usage (less round trips to the DB server, etc).

* ZSQL methods should be able to be tied to one database adapter, but 
dynamically use others if desired. This is currently difficult in Zope2.

Database adapters themselves should be utilities.

ZSQL methods are recordset generators. Perhaps we should abstract that 
to a common base interface so that anything generating record sets, like 
catalogish things, sql methods, xml-rpc/wddx and any other tablish 
things (tinytables?).

Even better I think we might start to think about ORMappings and make 
recordsets just a simplistic implementation of them. So, we should 
probably abstract this from a basic interface for mapping objects to 
records.

I would strongly caution that this is a very big ball of wax that we 
need many minds to flesh out well. So, if you go ahead and implement 
something, don't be surprised if it gets completely paved over later 
when everyone else catches up.

-Casey

Stephan Richter wrote:
> Hello everyone,
> 
> as I am getting done writing the server stuff, I am getting ready to 
> integrate RDBs into Zope 3. I have no idea whta is expected of this, but 
> I know I like the way Zope 2 does it. For my taste, porting the Zope 2 
> mechanism to Zope 3 would be perfect. That would result in the following 
> problems:
> 
> Are SQL Methods Content Objects or not?
> Should there be a RDBService having specific implementation utilities as 
> plugins?
> Where do all the objects live? In the Service Manager?
> ...
> 
> Let's **constructively** discuss that. I would to agree quickly on an 
> approach!
> 
> Regards,
> Stephan
> 
> -- 
> Stephan Richter
> CBU - Physics and Chemistry Student
> Web2k - Web Design/Development & Technical Project Management
> 
> 
> 
> _______________________________________________
> Zope3-dev mailing list
> Zope3-dev@zope.org
> http://lists.zope.org/mailman/listinfo/zope3-dev
>