Hi, I'm trying to figure out how to set the PRAGMA synchronous attribute to ON permanently for my database. I've read the pragma docs at (http://www.sqlite.org/pragma.html) and looked at the source code and haven't been able to figure it out.
I am able to load up my database with sqlite3 and send the PRAGMA synchronous=on; command which sets it only for the duration that I'm using sqlite3 to view/manipulate the database. Once I quit and access it again, the synchronous attribute is reset. How can I save the PRAGMA synchronous attribute to be equal to 'ON' permanently? (so that its saved in the database) Thanks, Eric