Re: [DB-SIG] Other extensions

2007-07-21 Thread Andy Todd
Michael Bayer wrote: > On May 15, 2007, at 3:29 PM, Michael Bayer wrote: > >> DBAPI needs to remain as the most minimal layer of standardization >> possible (and i think it should remain about SQL. to support other >> query languages would invariably require much richer APIs)...it just >> would b

Re: [DB-SIG] Other extensions

2007-05-18 Thread Michael Bayer
On May 18, 2007, at 12:19 PM, Andy Dustman wrote: > On 5/15/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > >> the "standard" for database metadata are the information_schema >> tables/views, they are part of ANSI 2003. Currently, there is >> support for information_schema in postgres, mysql, SQL

Re: [DB-SIG] Other extensions

2007-05-18 Thread Andy Dustman
On 5/15/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > the "standard" for database metadata are the information_schema > tables/views, they are part of ANSI 2003. Currently, there is > support for information_schema in postgres, mysql, SQL Server 7, and > possibly Oracle. At least for the PG/mys

Re: [DB-SIG] Other extensions

2007-05-15 Thread Michael Bayer
On May 15, 2007, at 3:29 PM, Michael Bayer wrote: > DBAPI needs to remain as the most minimal layer of standardization > possible (and i think it should remain about SQL. to support other > query languages would invariably require much richer APIs)...it just > would be nice to iron out the API v

Re: [DB-SIG] Other extensions

2007-05-15 Thread Art Protin
Dear folks, M.-A. Lemburg wrote: On 2007-05-15 21:00, Robert Brewer wrote: 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 i

Re: [DB-SIG] Other extensions

2007-05-15 Thread M.-A. Lemburg
On 2007-05-15 21:00, Robert Brewer wrote: > 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

Re: [DB-SIG] Other extensions

2007-05-15 Thread Robert Brewer
Michael Bayer wrote: > On May 15, 2007, at 3:00 PM, Robert Brewer wrote: > > 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

Re: [DB-SIG] Other extensions

2007-05-15 Thread Michael Bayer
On May 15, 2007, at 3:00 PM, Robert Brewer wrote: > > 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 shun

Re: [DB-SIG] Other extensions

2007-05-15 Thread Robert Brewer
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 nee

Re: [DB-SIG] Other extensions

2007-05-15 Thread M.-A. Lemburg
On 2007-05-15 19:58, Art Protin wrote: > Dear Marc-Andre, et al, >M.-A. Lemburg wrote: > >> On 2007-05-15 18:06, Art Protin wrote: >> >> >>> Dear folks, >>>I have lots more questions about ways that the API could and possibly >>> should be enriched. >>> >> >> There have been some disc

Re: [DB-SIG] Other extensions

2007-05-15 Thread Art Protin
Dear Marc-Andre, et al, M.-A. Lemburg wrote: On 2007-05-15 18:06, Art Protin wrote: Dear folks, I have lots more questions about ways that the API could and possibly should be enriched. There have been some discussions about this, but since no standard API could be found, no add

Re: [DB-SIG] Other extensions

2007-05-15 Thread Michael Bayer
On May 15, 2007, at 12:38 PM, M.-A. Lemburg wrote: > On 2007-05-15 18:06, Art Protin wrote: >> Dear folks, >> I have lots more questions about ways that the API could and >> possibly >> should be enriched. > > There have been some discussions about this, but since no standard > API could be

Re: [DB-SIG] Other extensions

2007-05-15 Thread M.-A. Lemburg
On 2007-05-15 18:06, Art Protin wrote: > Dear folks, > I have lots more questions about ways that the API could and possibly > should be enriched. There have been some discussions about this, but since no standard API could be found, no additions to the DB-API were made. ODBC has a very compl