On 3 Jun 2016, at 11:18am, Максим Дементьев <deme...@hotmail.com> wrote:

> Is it a well-known problem ?

Dear Max,

Many of the problems Python has with SQLite are caused by trying to work within 
the DB-API interface.  This interface doesn't really suit how SQLite works 
internally.  Could you try using this interface instead ?

<https://rogerbinns.github.io/apsw/>
<https://github.com/rogerbinns/apsw>

I cannot help solve the problem with Python, but it might be useful to test out 
your sequence of commands using the SQLite command-line tool.  You can find 
documentation here

<https://www.sqlite.org/cli.html>

and download it as one of the "Precompiled Binaries for Linux" here

<https://www.sqlite.org/download.html>

It can be especially useful to run your Python program in one window while 
running the command-line tool in another window since you can step through your 
program and use the command-line tool to see what effect it has line-by-line.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to