[sqlite] In memory database table is locked? :-(

2008-08-16 Thread Alex Katebi
Hello, I have a single threaded non-blocking server that uses a single in memory database. It's client API is the RPC version of the SQLite API. I wrote a Ruby test script that tests the client API functionality. All my tests pass successfully. How ever when I run two instances of the test clie

Re: [sqlite] FTS3 Snippet function on two column MATCHes

2008-08-16 Thread P Kishor
On Fri, Aug 15, 2008 at 9:13 PM, Alexandre Courbot <[EMAIL PROTECTED]> wrote: >> I would like to generate Snippets from MATCHes in two columns, >> however, I get the following error: "unable to use function MATCH in >> the requested context" with the following query -- > > I think you ran into the

Re: [sqlite] System function with Sqlite

2008-08-16 Thread Asif Lodhi
Hi Chris, On 8/15/08, Chris Brown <[EMAIL PROTECTED]> wrote: > > Can you offer any further help/suggestions? > AFAIK, how the system() passes the command-string to the command-processor is implementation defined. I would suggest that you also pass the shell (e.g. /bin/sh) to system() in addition