Some users of my application have their servers in remote locations that lose power. They have UPS backup, but the battery runs down and the computers will suddenly stop. When power returns and the application starts, the SQLITE database is sometimes corrupt. The vast majority of writes to the database are to a table that could be TEMPORARY, but is currently not. If that table was created as TEMPORARY, and it was in MEMORY, as opposed to FILE, would the likelihood of corruption on restart be reduced? If not, is there another change (schema or otherwise) that would help?
The table to be made TEMPORARY is fairly small and has no indexes. Its purpose is to provide data for a simple web UI showing current data. Thanks very much. Joe