Re: [sqlite] database table is locked

2005-05-14 Thread Gerry Snyder
Dan Kennedy wrote: It's probably not a good idea, because it depends on some behaviour that is not specified, but I once used a trick like this to get good performance: CREATE TABLE abc(a, b); UPDATE abc SET b = user2(a, b) WHERE condition AND user1(a, b); SQLite loops through the rows where

Re: [sqlite] Convert and isnumeric function

2005-05-14 Thread Wolfgang Rohdewald
On Samstag 14 Mai 2005 00:31, Michael Evenson wrote: case SQLITE_TEXT: { const char *z = sqlite3_value_text(argv[0]); for (i = 0; i strlen (z); i++) { if (!isdigit (z[i])) { nResult = 0; break; } this should return FALSE for -5,

Re: [sqlite] SQLite Java Wrapper?

2005-05-14 Thread Christian Werner
majed chatti wrote: I tried to use the SQLite Java Wrapper wich I download froh here http://www.ch-werner.de/javasqlite/ I extract it I do $./configure $make but I have this errors Please try out the new version from the above mentioned website. It should now compile with

[sqlite] Small journal optimization?

2005-05-14 Thread Ludvig Strigeus
Hello. I noticed that the sqlite code looks like below. On windows this will result in 5 system calls instead of 1 each time the journal is made. Why not batch it all together into a single write? /Ludvig rc = sqlite3OsWrite(pPager-jfd, aJournalMagic, sizeof(aJournalMagic)); if( rc==SQLITE_OK

Re: [sqlite] Where I can download a libsqlite3.a file, I do not want to compile it.

2005-05-14 Thread Doug Henry
I uploaded my compiled sqlite-3.2.1 here: http://www.brilligent.com/stuff/ My .a is about 340K, so your 400K version sounds correct. On 5/14/05, liigo [EMAIL PROTECTED] wrote: Where I can download a libsqlite3.a file? I do not know how to compile it properly. I have compiled one using