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

[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(>jfd, aJournalMagic, sizeof(aJournalMagic)); if( rc==SQLITE_OK ){ /*

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

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] 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 AND user1(a, b); SQLite loops through the rows where is true, and