[Zope-DB] mxODBC Zope Database Adapter

[Dieter Maurer]

M.-A. Lemburg writes:
 > Dieter Maurer wrote:
 > > M.-A. Lemburg writes:
 > >  > * are there any extensions to the standard interface (currently
 > >  >    there only seems to be a single .query() method in there),
 > >  >    which I could implement to better expose the rich ODBC
 > >  >    APIs (e.g. catalog methods come to mind) ?
 >  >
 > > Many DAs provide tabs to browse the schema.
 > 
 > I was thinking of APIs which would be used by web-site
 > programmers rather than yet another schema browser ;-)
 > 
 > Aren't there any standard for e.g. returning a list
 > of tables, columns and data types in these columns ?
I fear, there is not standard.

At least when I looked at a DA that provided schema browsing,
they implemented it themselves. As Python's DB-API (on which
most DAs are based) do not provide standard ways for schema
access, this may also be necessary.

 > > And, it would be nice, when we had also ways to add new tables,
 > > add columns and similar things (also I did not meet any DA
 > > that could do this).
 > 
 > Sounds like it would be better to have a generic tool
 > for this... creating tables and columns is certainly not
 > restricted to the DA but rather a task which depends on
 > the used database backend.
You are right. But such a generic tool is not yet there.
Maybe, another wish for the database-sig...

 > The restart is natural, but I would have thought that at
 > least on Windows products ship in form of Windows installers.
 > And on Unix, something like: download, unzip, run
 > "python setup.py install", restart.
There is currently (at least up to Zope 2.5) no standard installation
place for Zope. And the installation target must be Zope's
"Products" folder (not completely precise, there may be more
of them).

This makes a generic "python setup.py install" difficult.


Dieter