Thanks, Richard! Will
On 2/2/11 8:22 AM, "Richard Hipp" <[email protected]> wrote: On Wed, Feb 2, 2011 at 11:14 AM, Duquette, William H (318K) < [email protected]> wrote: > Howdy! > > In SQLite 3.7.4/3.7.5, does WAL seem to be stable enough for production > use? > Mass-market consumer products are shipping with WAL now, I am told. > > And then, an architecture question. I have an app that occasionally needs > to do significant background processing. I'd like to keep the GUI awake and > looking at the current data set while the app is computing the updated data > in the background. The obvious notion is to ask a secondary process or > thread to do the background processing. However, both the background task > and the GUI need to access the same DB. > Please use a background process, not a thread.... :-) > > WAL seems perfectly suited to this architecture. While the background > processing is going on, only the background task can write to it; but the > GUI can read the database all it likes, seeing only the data committed > before the background task started its current transaction. > WAL does exactly what you want, Will. As long as you only have a single writer, it will work great. > > Does this make sense? Is there an easier way to do it that doesn't involve > WAL? > > Thanks very much! > > Will > > -- > Will Duquette -- [email protected] > Athena Development Lead -- Jet Propulsion Laboratory > "It's amazing what you can do with the right tools." > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Will Duquette -- [email protected] Athena Development Lead -- Jet Propulsion Laboratory "It's amazing what you can do with the right tools." _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
