DB-API 2.0 in pysqlite and pgdb

[Gerhard Haering]

On Sat, Jan 01, 2005 at 06:33:24PM +0300, Roman Suzi wrote:
> 
> Happy New Year to all Pythoneers!
> 
> I am playing with pysqlite and pgdb and their DB-API conformancy.
> It was quite interesting to know:
> 
>  - sqlite doesn't have mandatory helper-functions Date, Tim, etc.
>    (due to an error int it's __init__, but this is quite obvious to correct
>    or just to use mx.Date, mx.Time)

Yes, that's an oversight.

> more serious mishaps with pgdb (postgresql-python):
> it doesn't know how to quote date-time data for the objects
> it has constructors itself. [...]

You may have better luck with pyPgSQL or psycopg.

-- Gerhard
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 196 bytes
Desc: Digital signature
URL: <http://mail.python.org/pipermail/python-list/attachments/20050104/e5ad087c/attachment.sig>