[DB-SIG] Asymmetry in DB-API 2.0 types

M.-A. Lemburg mal at lemburg.com
Fri Jun 6 19:47:37 EDT 2003

Harald Meland wrote:
> [M.-A. Lemburg]
>>The driver output values are driver dependent and there's nothing
>>much the API spec could do about this because not all databases
>>support all different kinds of data types and it is not even
>>clear for which result columns a specific data type is needed
>>or desired.
> Wouldn't it be possible to extend the current specification for
> e.g. DATETIME:
>      This type object is used to describe date/time columns in a
>      database.

Note that DATETIME is a type object, not the object being returned
itself. DATETIME (and the others) are only meant to be able to
provide a common ground for the cursor.description tuple entries --
nothing more.

There are no standard date/time objects defined in the spec. Many
DB-API modules use mxDateTime, some return strings, some time.time()
integers, etc. In the future some may also use the Python datetime
module's objects.

Again, DB-API modules are low-level interfaces and you are
asking for higher level standardizations which should really
go into your abstraction layer rather then the spec.

Marc-Andre Lemburg

Professional Python Software directly from the Source  (#1, Jun 06 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
EuroPython 2003, Charleroi, Belgium:                        18 days left

More information about the DB-SIG mailing list