On Mon, May 24, 2004 at 01:42:10AM +0200, Andreas Schwarz wrote:
> Hi,
>
> my changes to the SQLite DBD are in the CVS.
>
> Improvements:
> - rows aren't buffered any more (this also has disadvantages, see below)
> - column aliases are working
> - attribute sqlite_full_column_names is working
> - test cases based on Test::Unit
>
> Problems/TODO:
> - queries fail if the database is locked (wait & retry after SQLITE_BUSY
> has to be implemented)
is this an inherent problem when using the compile/step functions?
> - the database is locked until the program has fetched all available
> rows or called StatementHandle#finish
> - StatementHandle#fetch_scroll doesn't work any more
> - no test cases for transactions & AutoCommit
> - code still needs some cleanup, maybe split it in multiple C files
One further todo item for you ;-)
http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/252531
Automatic binary encoding for BLOB or BINARY datatypes would be great.
There's a C file in the SQLite distribution which implement the encoding
and decoding, which you could use.
Thanks!
Regards,
Michael
|
