M.-A. Lemburg wrote: > On 2007-05-15 19:58, Art Protin wrote: > > No, this can not be done in a standard way above the DB-API > > level. There is nothing in the DB-API specification that can > > be used in a DBMS independent manner, that would be assured > > of producing the answers. One would need to presume that all > > DBMSs have SQL access to the systems tables and ours for > > one does not. > > This depends on the database backend. Most of them provide > system tables with the needed information in one form or > another. > > Others don't and require using special interfaces (at C level). > > It's difficult to standardize. ODBC has gotten this pretty well > sorted out, IMHO, but emulating it in the DB API would be > quite difficult for the module authors.
It's not so much that making a standard interface is hard (SQLAlchemy, for example, and my Dejavu/Geniusql do this quite well). It's that such interfaces are then called "Object-Relational Mappers" [1] and are pretty universally shunned as an arena for standardization. Robert Brewer System Architect Amor Ministries [EMAIL PROTECTED] [1] ... of the "Metadata Mapping" variety. See http://www.martinfowler.com/eaaCatalog/metadataMapping.html _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
