|
Thanks to Yaroslav Samchu, asfPY now has a SQLite backend. He sent in a first take at this backend and I completed the code so that it now runs with only a few glitches left. One glitch is the support for autoincrementing columns - this isn't done in an atomic way due to the fact that the pysqlite interface (at lest the 1.something series) doesn't support atomic update and fetch on those columns and so I had to do a select max() and a combined insert.
The other glitch is support for data types. SQLite has only it's flexible data type handling and due to that currently the support for long integers is broken - they are damaged on store and you never get back a long integer on fetch. Due to this the test cases regarding long integers don't work.
Otherwise it's running fine. It's as slow as the other backends, though. There is definitely optimization needed in asfPY. But hey, it's just some 0.something version 
|
