Bill McCormick wrote:
> < PRAGMA journal_mode=WAL;
...
So when I run an update command (to update some arbitrary record) from the sqlite3 command line, do I need to do something to do a checkpoint?
By "checkpoint", I presume you mean some previous state of the database to which you can revert. Since the database is a file, you can keep a copy of it, as another file. Or you could put your update in a transaction. However, for a single-record update, there is no point. SQLite is pretty robust once you've set journal_mode=WAL.
Best regards, -- Larry Brasfield _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users