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