[Python-Dev] SQLite module for Python 2.5

Barry Warsaw barry at python.org
Fri Oct 22 00:36:24 CEST 2004


On Thu, 2004-10-21 at 04:46, Gerhard Haering wrote:

> WAIT!
> 
> I *can* implement something that is smarter than always converting to
> unicode/string, and that is, I can ask the SQLite engine which type a
> column has, but the limitation is it will only return its internal
> types:
> 
> #define SQLITE_INTEGER  1
> #define SQLITE_FLOAT    2
> #define SQLITE_TEXT     3
> #define SQLITE_BLOB     4
> #define SQLITE_NULL     5

I think that would be a neat idea as a default.  Still, I want what the
MySQL python binding has -- a way to provide a mapping of column names
to converters.  IIRC, the interface for that was a bit clunky, but it
was definitely usable, so it might be better to be consistent, than
better. :)

-Barry

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 307 bytes
Desc: This is a digitally signed message part
Url : http://mail.python.org/pipermail/python-dev/attachments/20041021/77e60723/attachment.pgp


More information about the Python-Dev mailing list