* To be reliably INSERTed Byte data should be first converted to sqlite3.Binary(my_data) explicitly

Interesting. Is that Python 2 specific, or also in Python 3. Because the latter would surprise me (not saying it isn't the case).
Only tried on Python 3. I'm inserting raw byte versions of web-pages. I forget the exact details but I have a comment in my code to the above effect so I must have ended up bashing my head against it at some point. A zip/lzma compressed byte output doesn't need this wrapper though.

On a UNIX system the command "lsof -p pid-of-running-python-process" should show the path of the sqlite library that is linked to the Python executable, which should let you learn this.

Thanks, I'll have to add that to the collection. I know when I was googling around for it on *nix I came across a bunch of different answers none of which seemed to work. Windows is a simple matter of replacing the right DLL (though again not really documented). I still have no idea how to do it on *nix but that's another thread.

--
https://mail.python.org/mailman/listinfo/python-list

Reply via email to