[sqlite] Understanding Sqlite IO on Windows CE

2015-03-18 Thread Nicholas Smit
Thanks very much for that. Unfortunately WAL mode is not supported on CE - lacks certain structures apparently. On 18 March 2015 at 12:26, Richard Hipp wrote: > On 3/17/15, Nicholas Smit wrote: > > Hello. > > > > We have an app on CE 5, and CE 7. > > > > We are keen to move from using SQL CE

[sqlite] Understanding Sqlite IO on Windows CE

2015-03-18 Thread Richard Hipp
On 3/17/15, Nicholas Smit wrote: > Hello. > > We have an app on CE 5, and CE 7. > > We are keen to move from using SQL CE, to Sqlite, for our main data, as > Sqlite is superior in many ways. > > The app runs on a mobile device, where power can be removed at any time. > The data is stored on SD car

[sqlite] Understanding Sqlite IO on Windows CE

2015-03-17 Thread Nicholas Smit
Hello. We have an app on CE 5, and CE 7. We are keen to move from using SQL CE, to Sqlite, for our main data, as Sqlite is superior in many ways. The app runs on a mobile device, where power can be removed at any time. The data is stored on SD cards, with FAT filesystem. Sometimes the IO sub-sy