Re: [sqlite] [OT] Java wrapper binaries for Windows with larget MAX_ARGS

2006-10-24 Thread David Crawshaw
Adriano Rodrigues <[EMAIL PROTECTED]> wrote: For example, I will miss ResultSet.getObject() which I rely upon heavily. Sorry, the README is out of date there. The latest version v026 supports ResultSet.getObject() by instancing the object that matches the storage type of the column. So you

[sqlite] Re: Regarding sqlite3_exec

2006-10-24 Thread A. Pagaltzis
* Da Martian <[EMAIL PROTECTED]> [2006-10-24 16:15]: > It appears that DBs like oracle etc.. get the whole resultset > into temporary memory/space and then return the query (at least > for unions this appears true), although this is just based off > assumptions based on observations. What

Re: [sqlite] Sqlite & Matlab

2006-10-24 Thread Dennis Cote
[EMAIL PROTECTED] wrote: There seems to be a possible connection between Sqlite and Matlab available at http://sourceforge.net/project/showfiles.php?group_id=139986 However it is not refered to on the sqlite website. Does that mean it does not really work? Victor, I took a quick look at

Re: [sqlite] Regarding sqlite3_exec

2006-10-24 Thread Dennis Cote
Da Martian wrote: Hi I understand the problem in thoery and you are saying that sqlite is using an iterative algorithm which returns data as it finds it, is this correct? It appears that DBs like oracle etc.. get the whole resultset into temporary memory/space and then return the query

[sqlite] Sqlite & Matlab

2006-10-24 Thread victor . camus
Hi All There seems to be a possible connection between Sqlite and Matlab available at http://sourceforge.net/project/showfiles.php?group_id=139986 However it is not refered to on the sqlite website. Does that mean it does not really work? Thank you in advance for your answer Victor

Re: [sqlite] Regarding sqlite3_exec

2006-10-24 Thread Da Martian
Hi I understand the problem in thoery and you are saying that sqlite is using an iterative algorithm which returns data as it finds it, is this correct? It appears that DBs like oracle etc.. get the whole resultset into temporary memory/space and then return the query (at least for unions this

Re: [sqlite] Potential corruption bug in 2.8.17. Patch attached.

2006-10-24 Thread drh
[EMAIL PROTECTED] wrote: > >> > >> --- vdbe.c~2005-12-19 12:42:25.0 -0500 > >> +++ vdbe.c 2006-10-22 16:32:45.0 -0400 > >> @@ -2937,7 +2937,7 @@ > >>if( pOp->p2 & OPFLAG_NCHANGE ) db->nChange++; > >>if( pOp->p2 & OPFLAG_LASTROWID ) db->lastRowid = pNos->i;

Re: [sqlite] [OT] Java wrapper binaries for Windows with larget MAX_ARGS

2006-10-24 Thread Adriano Rodrigues
On 10/20/06, David Crawshaw <[EMAIL PROTECTED]> wrote: Adriano Ferreira <[EMAIL PROTECTED]> wrote: > Does anyone know where I can get binary files for the Christian > Werner's Java wrapper (sqlite.jar and sqlite_jni.dll) which allows for > a large number of placeholders (something like 256 or

Re: [sqlite] Potential corruption bug in 2.8.17. Patch attached.

2006-10-24 Thread Derrell . Lipman
[EMAIL PROTECTED] writes: > [EMAIL PROTECTED] wrote: >> This was likely a typo. In its current state, it's accessing uninitialized >> memory. It looks like it's conceivable that an incorrect nextRowid could be >> later used if the uninitialized value happens to be a small integer (smaller >>

Re: [sqlite] memroy footprint for mobile phone

2006-10-24 Thread drh
"weiyang wang" <[EMAIL PROTECTED]> wrote: > hi, > > i am working on the sqlite evaluation for mobile phone. and now i am facing > the issues of memory footprint. > > according to the documents, three parameters are used to control the memory > footprint: default_cache_size, cache_size and

Re: [sqlite] Potential corruption bug in 2.8.17. Patch attached.

2006-10-24 Thread drh
[EMAIL PROTECTED] wrote: > This was likely a typo. In its current state, it's accessing uninitialized > memory. It looks like it's conceivable that an incorrect nextRowid could be > later used if the uninitialized value happens to be a small integer (smaller > than pC->nextRowid) and the "valid"

Re: [sqlite] Regarding sqlite3_exec

2006-10-24 Thread drh
"Da Martian" <[EMAIL PROTECTED]> wrote: > Hi > > > >The optimal way is that you prepare the statement, fetch and > > count the results with sqlite3_step. > > How would I "fetch and count" the results via sqlite3_step? > > Do you mean fetch all the records first? What if my result set is huge,

Re: [sqlite] encrypted file

2006-10-24 Thread drh
Lloyd <[EMAIL PROTECTED]> wrote: > Hi List, > Whether the data base which we create through the program will be in > encrypted form? The public-domain version of SQLite does not encrypt the data. But commerical extensions that encrypt the data are available. See, for example,

Re: [sqlite] insertion time

2006-10-24 Thread drh
Lloyd <[EMAIL PROTECTED]> wrote: > Hi, > When this 3M inserts are performed, it takes 130 more seconds compared > to the actual application running time. The actual application run time > is 20 seconds but when this 3M inserts are performed it takes 150 > seconds. > > Is there any way to reduce

Re: [sqlite] Regarding sqlite3_exec

2006-10-24 Thread Da Martian
Hi The optimal way is that you prepare the statement, fetch and count the results with sqlite3_step. How would I "fetch and count" the results via sqlite3_step? Do you mean fetch all the records first? What if my result set is huge, and I would only like to show the first few records but

[sqlite] encrypted file

2006-10-24 Thread Lloyd
Hi List, Whether the data base which we create through the program will be in encrypted form? If yes, how can I see the result in sqlite? (How can use select statements on this database?) My application creates a database and to analyze the results in the database, it will be easy for me to