[Zope3-dev] RDB support

[Stephan Richter]

At 12:03 PM 4/10/2002 -0600, Casey Duncan wrote:
>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).

Good point. The question is just, how? :-)

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

I think everyone agrees with that. But as RDM pointed out, let's not 
discuss that yet, since we do not know how TTW development will look like 
anyhow.

>Database adapters themselves should be utilities.

That is an implementation detail, but yeah, that is the obvious one. I 
think there might be even an ExternalDatasourceService and DAs implement it.

>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?).

Yep, I agree.

>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 think ORMapping should be a in a higher level. We will open up a can of 
worms if we go there. I want it VERY simple in the low-level parts.

>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.

Who talks about implementation. I think people assume that the word 
"constructive" equals "code". That is not true. Constructive can also mean 
that some nice design ideas are written down in a Wiki, so the discussion 
does not need to start over again all the time.

Regards,
Stephan

--
Stephan Richter
CBU - Physics and Chemistry Student
Web2k - Web Design/Development & Technical Project Management