Roger Binns
2006-12-20 07:34:02 UTC
The next release of APSW is going to always return Unicode strings.
There was a long discussion on the pysqlite mailing list about why, and
it is what pysqlite already does. This may break some of the code that
has been in denial about Unicode so far.
Also available is a new SQLite feature named Virtual Tables. With APSW
this would allow Python code to define and provide the contents of some
tables, and the rest of the code just does normal SQL and doesn't know
any better. There might be some good uses we could make of this.
However so far the data format for BitPim is Python dictionaries. They
are far more flexible than a table with a fixed number of columns. Even
the current database takes dicts and munges them into SQL behind the
scenes so that the rest of the code never has to deal with SQL style
limited data.
Roger
There was a long discussion on the pysqlite mailing list about why, and
it is what pysqlite already does. This may break some of the code that
has been in denial about Unicode so far.
Also available is a new SQLite feature named Virtual Tables. With APSW
this would allow Python code to define and provide the contents of some
tables, and the rest of the code just does normal SQL and doesn't know
any better. There might be some good uses we could make of this.
However so far the data format for BitPim is Python dictionaries. They
are far more flexible than a table with a fixed number of columns. Even
the current database takes dicts and munges them into SQL behind the
scenes so that the rest of the code never has to deal with SQL style
limited data.
Roger