Re: [sqlite] mj file loss consequences

Understood and most grateful for the quick response. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] mj file loss consequences

>The only consequence of losing -mj file is that in a multi-database >transaction (which can only be in rollback mode, not in WAL mode) if you >lose power and come back up without the -mj file, then the transaction >might commit to some of the database files, but not to others. Are you onl

[sqlite] mj file loss consequences

What are the recovery consequence(s) to a database (journal mode wal) should a master-journal file be lost? Suppose a flash sensitive embedded product had to update its database every second. To save flash wear the database (journal mode delete) is created in ram (e.g. /tmp). Suppose every 8 sec