Python/SQLite best practices

[Jonathan Moules]

>> * 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.