[sqlite] Understanding Sqlite IO on Windows CE

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

[sqlite] Understanding Sqlite IO on Windows CE

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

[sqlite] Understanding Sqlite IO on Windows CE

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

Re: [sqlite] Understanding Sqlite

On Mon, Jun 16, 2014 at 9:57 AM, jose isaias cabrera wrote: > > Designing the DBs and tables would be the essencial part of the whole > project. After that, the rest is easy. > "Representation is the essence of computer programming" (Fred Brooks, _The Mythical

Re: [sqlite] Understanding Sqlite

"dd" wrote... Dear Author/All, There are many things needs to understand from sqlite apart from RDBMS concepts. For example, pragmas, database connection in different scenarios, IPC, virtual tables..etc. Do sqlite team has any plan to start online university for training and issuing

Re: [sqlite] Understanding Sqlite

I took a course back in the day when MSSQL-2000 was just coming out, or just had come out. I learned the nuts and bolts (Right down to the freak'n file format used at the time -- Ironically, that was the best part and I did enjoy that the most), the concepts, the attitude, and the mentality of

Re: [sqlite] Understanding Sqlite

What worked for me was, before starting to code with SQLite,  I read the first two books on this page http://www.sqlite.org/books.html cover-to-cover, and spent a lot of time reading various articles on the SQLite website.  I also find it useful to read the SQLite code itself. Peter On

Re: [sqlite] Understanding Sqlite

On Jun 4, 2014, at 8:35 AM, dd wrote: > What is/are the best practice(s) to become master in sqlite in short > period of time for new developers (i mean, new to sqlite not for > programming)? Master? In short time? Nope. If you don’t want to be a total phony, you

Re: [sqlite] Understanding Sqlite

On 2014/06/04 08:35, dd wrote: Dear Author/All, There are many things needs to understand from sqlite apart from RDBMS concepts. For example, pragmas, database connection in different scenarios, IPC, virtual tables..etc. Do sqlite team has any plan to start online university for

[sqlite] Understanding Sqlite

Dear Author/All, There are many things needs to understand from sqlite apart from RDBMS concepts. For example, pragmas, database connection in different scenarios, IPC, virtual tables..etc. Do sqlite team has any plan to start online university for training and issuing certificates? If