[sqlite] PRAGMA synchronous = NORMAL and Error = 21

Hello, I use the function: apr_dbd_query(driver, sqlite3, , "PRAGMA synchronous = NORMAL"); But I always get the error and error code is 21. In addtion, rows=(null). Does it mean I should insert some rows into SQlite3 before I use apr_dbd_query()? Thanks!

Re: [sqlite] Memory Usage

One other note, just about all real-time systems limit the dynamic allocation of memory because you lose the deterministic behavior, typically all memory is allocated when the task starts, memory is usually managed internally in standard sized chunks. Also for long running tasks

[sqlite] Re: Any way to obtain explicit read lock?

Igor Sereda <[EMAIL PROTECTED]> wrote: Suppose we need to read two tables in an isolated way, so no db change is visible to the connection between first and second readout. As far as I see, there's no such SQL or API for that at the moment. Just do both SELECT's within a single transaction.

[sqlite] Re: building a custom DBD::SQLite

On Nov 18, 2007 2:59 PM, P Kishor <[EMAIL PROTECTED]> wrote: > On Nov 17, 2007 2:22 PM, P Kishor <[EMAIL PROTECTED]> wrote: > > I need to build a DBD::SQLite package using SQLite with fts > > capabilities. Can someone on this list kindly give me painless, easy > > to understand instructions to do

[sqlite] Any way to obtain explicit read lock?

Suppose we need to read two tables in an isolated way, so no db change is visible to the connection between first and second readout. As far as I see, there's no such SQL or API for that at the moment. In other words: 1: // with the first step() the read lock is taken: 2: while(stmt1.step())

[sqlite] Re: building a custom DBD::SQLite

On Nov 17, 2007 2:22 PM, P Kishor <[EMAIL PROTECTED]> wrote: > I need to build a DBD::SQLite package using SQLite with fts > capabilities. Can someone on this list kindly give me painless, easy > to understand instructions to do so? I need to do this on a Mac OS X > 10.4 first, and then on my web

Re: [sqlite] Lemon problem

Hello, I finally find the bug. In fact that was many bugs. - Grammar rule order. - Input string not reseted properly. Thank you. David On Nov 18, 2007 10:30 AM, Joe Wilson <[EMAIL PROTECTED]> wrote: > It's most likely your bug. Just add some debug prints in your grammar > and tokenizer to see

Re: [sqlite] Memory Usage

On Nov 18, 2007, at 8:12 AM, Russell Leighton wrote: On Nov 17, 2007, at 4:56 PM, [EMAIL PROTECTED] wrote: If you compile with -DSQLITE_MEMORY_SIZE= then SQLite will *never* call malloc(). Instead, it uses a static array that is bytes in size for all of its memory needs. You can

Re: [sqlite] Lemon problem

It's most likely your bug. Just add some debug prints in your grammar and tokenizer to see what's going on. See also: ParseTrace() in http://www.hwaci.com/sw/lemon/lemon.html --- Téragone <[EMAIL PROTECTED]> wrote: > I have a problem with a rule of a small calculator which accept variables : >

[sqlite] Lemon problem

Hello, I have a problem with a rule of a small calculator which accept variables : assignment(A) ::= VARIABLE(C) EQUAL expr(B). I can set variable with simple value or expression like : a=2 b=2+3 but when I try : c=a+b The result is put in variable b instead of c. Is it my bug or a Lemon bug

Re: [sqlite] Memory Usage

On Nov 17, 2007, at 4:56 PM, [EMAIL PROTECTED] wrote: If you compile with -DSQLITE_MEMORY_SIZE= then SQLite will *never* call malloc(). Instead, it uses a static array that is bytes in size for all of its memory needs. You can get by with as little as 100K or so of memory, though

[sqlite] fts table insert performance

Hi I insert rfc txt files into a full text search table, 4119 txt files are 188MB totally. After insert, database file is 443MB. Logic is below, it's not the real code. BEGIN_TRANSACTION CREATE TABLE Notes ( rowid INTEGER PRIMARY KEY, docid, CreateTime,