request to update SQLite.dll

[At_Libitum]

As the subject. I've been dealing with an issue in trying my hand on plugins because of the lack for the CHAR statement in the included SQLite3.dll

Could this one please be updated to the current stable version? (has support for CHAR)

[kovidgoyal]

As fas as I recall the windows build does not contain any separate sqlite3.dll. There is one implementation of sqlite3 that comes from the python stdlib and the other from apsw. I assume you are using the one from the python stdlib, tryusing apsw instead. IIRC it was 3.7.17 or something like that.

[At_Libitum]

Originally Posted by kovidgoyal

As fas as I recall the windows build does not contain any separate sqlite3.dll. There is one implementation of sqlite3 that comes from the python stdlib and the other from apsw. I assume you are using the one from the python stdlib, tryusing apsw instead. IIRC it was 3.7.17 or something like that.

There is a sqlite3.dll in the calibre dll folder. I have no idea which version as the file properties do not specify this information.

The one I have replaced it with I got directly from here: http://sqlite.org/download.html where there is no mention of either of the two other sources you mention.

All I know is that the one included with Calibre does not know the CHAR function where as the one I downloaded from above link does.

[kovidgoyal]

That will likely come from the python standard distribution. I'm not going to replace it as generally speaking, willy nilly replacing bits of a standard distribution is not something to be done lightly.

As I said, try using apsw

import apsw
apsw.connect('path_to_database')

[At_Libitum]

thanks for the suggestion but I guess that means I'll drop this attempt before getting sucked in too deep. Up until the last line of your last post I had no idea what apsw is... ok so this is something part of Calibre...and I know far too little about Python and the insides of Calibre to venture there.

[toddos]

Google is your friend.

So is Bing.

apsw is "Another Pythong SQLite Wrapper", not something calibre-specific beyond the fact that it seems calibre uses it and thus the package is available to plugins to use without having to add their own package.

[At_Libitum]

Well, if all I would need to do is to change sqlite3 into apsw wherever I encounter it. That I can try of course. don't need to know any Python for that.

Alas, when it came to apsw.connect(path to my db) it barfed

AttributeError: 'module' object has no attribute 'connect'

Like I said, this is no big deal, the basics like getting books into and out of this ole reader app works and that was already more than I ...hoped for. Until I know more about python I can settle for that.

EDIT: Ok so it is called Connection with capital c... but I fear I have to leave it be anyways and settle for copying in the newer dll as it seems that via apsw other things also aren't supported. This code seems to use row_factory all over and that ain't working with apsw either without rewriting... way over my current skill set.

Thanks all for the pointers just the same