Dear Simon, Thank you, I'll try this "yet another python SQLite wrapper" in the near future, it looks interesting.
I've already solved the problem (see my previous answer). I'm not only able to run the command line tools with my intermediate files to refine the problem, I was able to built debug version of SQLite library and use "PRAGMA vdbe_debug=true;" (unfortunately, I couldn't able to interpret all that stuff it generates). IMHO, there is a problem with the schema in WAL mode in general. But I've given up to refine it farther, having a solution. Best wishes, Max > From: slav...@bigfraud.org > Date: Fri, 3 Jun 2016 14:29:28 +0100 > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] WAL: no schema after close > > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
