Re: [sqlite] Recommend server for Windows?

Hi Gilles, On 6/20/07, Gilles Ganault [EMAIL PROTECTED] wrote: At 16:49 19/06/2007 -0700, Medi Montaseri wrote: The context is that, until now, our apps were almost used on stand-alone hosts with only a few customers hosting the (small) SQLite database file on a shared drive on the LAN, so

Re: [sqlite] Cache invalidation after insert statements.

HI all. Thanks for everyones help the problem is now solved. The memory drive worked like a bomb. Basically the problem on that server was that the insanely high IO prevented the OS from caching the file which slowed down the performance. After installing a mem drive ( using mfs ) and reducing

RE: [sqlite] Trigger on Attached Database

Try to create a TEMPorary trigger after the ATTACH command. Regards Marc Is it possible to do this: Open DB1 Attatch DB2 In DB1 have a trigger that does Insert into DB2. ? Theoretically it seems possible but we couldn't get it to work. Before I investigate further just want to know

Re: [sqlite] Cache invalidation after insert statements.

At 11:20 22/06/2007, you wrote: HI all. Thanks for everyones help the problem is now solved. The memory drive worked like a bomb. Basically the problem on that server was that the insanely high IO prevented the OS from caching the file which slowed down the performance. After installing a mem

[sqlite] Pragma busy

Hi all, The following errors are generated in a multi threaded program where each thread has its own independent Connection to sqlite. The command sql=[PRAGMA synchronous=FULL] Results in a rc=[5] and errorr msg=[database is locked] How can this can be avoided? I've tried

Re: [sqlite] Re: How to sort not binary?

On 12.05.2007 22:57 CE(S)T, Ingo Koch wrote: Yves Goergen wrote: I guess that doesn't work when I'm accessing the database through the System.Data.SQLite interface in .NET? Fortunately your guess is wrong. ;-) System.Data.SQLite supports user defined collation sequences. See

[sqlite] Unicode collation

Hello, I wonder whether there are any plans to include internally proper Unicode comparisons? Don't get me wrong, I think that it's great that SQLite supports custom collations, there's absolutely no problem to handle it in internally for my database, but problem is that if I define UNICODE

[sqlite] Capturing output from SQLlite with variables in a BASH script

Hi, I'm wondering how to write a BASH script that will capture my SQLite output. I can do it for a single line with something like this: somevar=`sqlite3 dbfilename SELECT name FROM tablename WHERE name='smith' LIMIT 1;` However, if I want to do anything with multiple lines, I haven't figured

Re: [sqlite] blob data streaming

On 4/10/07, Teg [EMAIL PROTECTED] wrote: Hello Andrew, Tuesday, April 10, 2007, 3:25:29 PM, you wrote: AF Using sqlite3 (3.3.15 or later), is there a method to retrieve portions of a AF blob rather than the whole thing? AF If not, would others find it useful and handy? Store the file in

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

[In the message [sqlite] Capturing output from SQLlite with variables in a BASH script on Jun 22, 13:02, litenoob writes:] Hi, I'm wondering how to write a BASH script that will capture my SQLite output. I can do it for a single line with something like this: somevar=`sqlite3 dbfilename

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

litenoob wrote: Hi, I'm wondering how to write a BASH script that will capture my SQLite output. I can do it for a single line with something like this: somevar=`sqlite3 dbfilename SELECT name FROM tablename WHERE name='smith' LIMIT 1;` However, if I want to do anything with multiple lines, I

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

- Original Message From: Martin Jenkins [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Friday, June 22, 2007 2:00:45 PM Subject: Re: [sqlite] Capturing output from SQLlite with variables in a BASH script litenoob wrote: Hi, I'm wondering how to write a BASH script that will

Re: [sqlite] Re: How to sort not binary?

On 22.06.2007 17:48 CE(S)T, Yves Goergen wrote: Match m1 = Regex.Match(param1, ^([0-9]+)); if (m1.Success) { Match m2 = Regex.Match(param2, ^([0-9]+)); if (m2.Success) { int cmpNum = int.Parse(m1.Groups[1].Value) -

[sqlite] What about with LAST_INSERT_ROWID() ?

Hmm.. don't know sed or awk, but I suppose this weekend would be a good time to learn! Alright, going along with this, is there a better way to get the last row id inserted? This is my (completely inefficient) workaround: - - - - - sqlite3 $dbfilename EOF INSERT INTO tablename (col1, col2)

Re: [sqlite] What about with LAST_INSERT_ROWID() ?

[In the message [sqlite] What about with LAST_INSERT_ROWID() ? on Jun 22, 15:09, litenoob writes:] Hmm.. don't know sed or awk, but I suppose this weekend would be a good time to learn! Alright, going along with this, is there a better way to get the last row id inserted? This is my

[sqlite] Worked perfectly!

-- #/bin/sh ROW_ID=`sqlite3 test.db END insert into t values(1,2); select last_insert_rowid() from t limit 1; END ` echo ROW_ID=$ROW_ID -- ^ that worked perfectly. Thank you Nikola! -- View this message in context:

Re: [sqlite] Tomcat crashes with SQLite

Hi I just tried this driver: http://www.zentus.com/sqlitejdbc/ The result is ten times slower or even more. Maybe I am wrong using this new driver. So for the moment I am still using this one: http://www.ch-werner.de/javasqlite/ BUT I HAVE STILL THE CRASH TROUBLES: An unexpected exception has

Re: [sqlite] Tomcat crashes with SQLite

If you did not compile sqlite as multi-threaded this is exactly what would happen. On Jun 22, 2007, at 9:06 PM, Frederic de la Goublaye wrote: Hi I just tried this driver: http://www.zentus.com/sqlitejdbc/ The result is ten times slower or even more. Maybe I am wrong using this new