Differences between revisions 2 and 3
Revision 2 as of 2003-02-18 11:06:00
Size: 1491
Editor: proxy30
Comment:
Revision 3 as of 2003-02-18 11:14:06
Size: 1989
Editor: proxy10
Comment:
Deletions are marked like this. Additions are marked like this.
Line 8: Line 8:

Discussions should be held at db-sig@python.org, with summaries (even preliminary ones) entered here. This is also the place where limits imposed by the underlying database/library implementation should be entered for further reference. It could also be used as a place for technical voting by the driver authors (with tags like 'personal preference', 'trivial to implement', 'difficult to implement', 'implementable only with loss of performance' etc.)
Line 40: Line 42:

= Common Modules =

 * unit tests

This page should summarize topics for the DB API 3.0. It is meant to provide

  • clarifications of the DB API 2.0
  • new optional features
  • new recommendations

A related page is ExtendingTheDbApi, which lists features that aren't general enough to make it into the spec.

Discussions should be held at db-sig@python.org, with summaries (even preliminary ones) entered here. This is also the place where limits imposed by the underlying database/library implementation should be entered for further reference. It could also be used as a place for technical voting by the driver authors (with tags like 'personal preference', 'trivial to implement', 'difficult to implement', 'implementable only with loss of performance' etc.)

TableOfContents

Unified Parameter Style

Possibilities

  • currently: one parameter style per driver
  • one parameter style for all drivers
  • multiple parameter styles per driver, switchable per Connection, Cursor or .execute ()

Additional Driver Objects

Prepared statements in addition to Connection and Cursor. Related is the idea of statement caching:

  • Cursor object as a prepapared statement
  • Cursor object accesses a pool of cached prepared statements

Parameter Passing

cursor.execute ("SELECT where size = :size", {'size': localvar}) vs.cursor.execute ("SELECT where size = :size", size = localvar)

cursor.execute ("SELECT where size = ?", [localvar]) vs. cursor.execute ("SELECT where size = ?", localvar)

Should the argument passing be driver dependent, should there be additional methods, should only one be allowed?

Schema Information

Role of the DB API spec

  • programs should be completely portable, including the SQL
  • programs should be portable at the API level
  • it should be possible to write portable programs, but extensions are allowed
  • why bother, real apps write their own higher level API

Common Modules

  • unit tests

DbApi3 (last edited 2010-11-05 09:30:29 by port-87-234-198-221)

Unable to edit the page? See the FrontPage for instructions.