Re: [sqlite] WinCE possible bug

Try play with "pragma" PRAGMA TEMP_STORE = MEMORY PRAGMA journal_mode = TRUNCATE On Fri, Sep 3, 2010 at 2:40 PM, Israel Lins Albuquerque < israel...@polibrasnet.com.br> wrote: > Guys I had a problem. > > We use sqlite for WinCE based devices, then in version 6.1 of this O.S., > the command

Re: [sqlite] Increment counter or insert row in one statement

Simon Slavin writes: > > This is the last message I'm sending to you. > slow down - life can be so easy http://www.youtube.com/watch?v=bf3ohrAIetg greetings Oliver ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Are triggers the best way to store the modification time?

Hi, I'm having a table of file names along with hashes and so on. In order to make sure that we keep a record, I had put a trigger on UPDATE and INSERT which would set the column 'modified' (REAL, Julian day) to the time of the change. However, this slows down any INSERTs (even those seemingly

Re: [sqlite] Increment counter or insert row in one statement

On 7 Sep 2010, at 4:09pm, Zack Weinberg wrote: > On Tue, Sep 7, 2010 at 4:45 AM, Simon Slavin wrote: >> On 7 Sep 2010, at 4:34am, Zack Weinberg wrote: >> >>> I'm not subscribed to the mailing list, please cc: me on replies. >> >> No. If you don't read a mailing list,

Re: [sqlite] Increment counter or insert row in one statement

Zack Weinberg wrote: > I have this database schema: > > CREATE TABLE observations ( >src TEXT, >dest TEXT, >verb TEXT, >occurrences INTEGER > ); > CREATE UNIQUE INDEX observations_index >ON observations (src, dest, verb); > > My program receives a stream of

Re: [sqlite] Increment counter or insert row in one statement

On 7 Sep 2010, at 4:34am, Zack Weinberg wrote: > I'm not subscribed to the mailing list, please cc: me on replies. No. If you don't read a mailing list, don't post to it. Part of the reason is this: we may have already answered a very similar question recently, and we don't see why we should

[sqlite] Increment counter or insert row in one statement

I have this database schema: CREATE TABLE observations ( src TEXT, dest TEXT, verb TEXT, occurrences INTEGER ); CREATE UNIQUE INDEX observations_index ON observations (src, dest, verb); My program receives a stream of events, which are (src, dest, verb) tuples. On every

[sqlite] ATTACH and WAL

I have a database that has a sort of central db with four other databases that are ATTACHed. When I enable journal mode of WAL, I only see one wal and shm file (for the one I actually opened). I would expect to see one for each attached database, as that would be consistent