I'm glad you have figured out WHAT went wrong, I'm worried that you have not discovered WHY it went wrong. I can't speak for Omnis and what it might do in the background, shielding you from SQL and all, but what I can say is if this was normal SQLite running in a normal system doing its thing in normal modes, then sure those column counts and content are a bit big and lofty, but even so it should absolutely work and it should absolutely NOT get corrupted, and if it does become corrupt by simple virtue of being lofty, it's a bug. So I don't think all the steps you are intending will solve the problem, though they may well be sensible improvements for other reasons, but they should not be blamed for what went wrong. [Have you seen this page?](https://sqlite.org/howtocorrupt.html) Maybe something in there might help you look in the right place. Best of luck!