Re: [sqlite] Difference between OR and IN [http://www.sqlite.org/php2004/page-052.html]

2007-09-01 Thread RaghavendraK 70574
Hi, Ok. Is there any way to tell the VDBE to stop execution moment it gets a record from the IN list rather than continue to query for all the parameters? I mean can it work like the C if clause a = 1; b = 100; if( a == 1 or b == 10) { } in the above case a is evauated but not b. Is this

RE: [sqlite] VFS in upcoming 3.5.0

2007-09-01 Thread Virgilio Alexandre Fornazin
You can create a 'shared memory VFS' to share a memory database against other thread / processes, and you can also 'copy' the RAW bytes of your memory with memcpy from/to another storage to accomplish the serialize / load you want to wire transfer SQLite memory databases. But this is not a simple

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-01 Thread Liam Healy
Good point. I guess my intent is this: I'd like to use the external API completely if possible. If not, I'm not sure whether to include source or use the current library (I can see advantages to each). I guess there aren't external API calls that do the needed tasks, so I'll have to figure out

Re: [sqlite] Looking for a cryptographic library

2007-09-01 Thread G√ľnter Greschenz
hi, after a long time being on a business trip, i finally came home and have now the chance to upload the sources to my webserver: http://greschenz.dyndns.org/sqlite.html these sources have never been in a productive system, i just implemented it for fun... what i want to say: i never

Re: [sqlite] VFS in upcoming 3.5.0

2007-09-01 Thread Olaf Schmidt
>> 1. As known, an InMemory-DB is currently not (much) faster >>than working against a File. >>With the new VFS I think, that much faster InMemory- >>DB-Handling should be possible, is that right? > I don't think so. The vfs is really an interface for moving > data (pages) in and

Re: [sqlite] Difference between OR and IN [http://www.sqlite.org/php2004/page-052.html]

2007-09-01 Thread Trevor Talbot
On 9/1/07, RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > I want to know why > prepareStatement: select * from xxx where IN (?); > stmt.bind("abc,xyz,123"); is not supported for multiple > values. It's not supported because it doesn't make sense. The parametric binding mechanism is for single

Re: [sqlite] VFS in upcoming 3.5.0

2007-09-01 Thread Dan Kennedy
On Sat, 2007-09-01 at 08:15 -0700, Olaf Schmidt wrote: > Hi, > > first - congrats to the planned changes in the new, upcoming > version of SQLite. The new shared-cache behaviour sounds > promising and also the new VFS-option. > > A few questions to VFS. > 1. As known, an InMemory-DB is

Re: [sqlite] Merge different Sqlite DB's

2007-09-01 Thread John Stanton
Use SQL. You could use a script like Perl or TCL. RaghavendraK 70574 wrote: Hi, If i have 2 sqlite files is there a way to merge the files without corruption? assuming the schema of both the files are same. I don't want to use sql statements rather want to do using file api's. Similar to

[sqlite] Merge different Sqlite DB's

2007-09-01 Thread RaghavendraK 70574
Hi, If i have 2 sqlite files is there a way to merge the files without corruption? assuming the schema of both the files are same. I don't want to use sql statements rather want to do using file api's. Similar to diffdb.c pls help. regards ragha

Re: [sqlite] compiling

2007-09-01 Thread John Stanton
You can define them as literals or read them from a file. As a literal: char *sql_statement = "SELECT * FROM mytable"; If you read all your SQL from a file you can use the Sqlite capability of having it in one big string delimited with semi-colons and preparing it is a loop where each

Re: [sqlite] compiling

2007-09-01 Thread nishit sharma
can anybody tell me that without using argc and argv in my main() program how can i pass sqlite3 statements in my C source code. more precise is that this time i m opening the database using argc and argv in my main and in sqlite3_open() call. similarly in sqlite3_exec(). but how can i make

Re: [sqlite] Performance tuning for Insert and select operations

2007-09-01 Thread Kees Nuyt
On Fri, 31 Aug 2007 09:34:18 +0530, you wrote: >Hi, > >I am using SQLite 3_3_17with the default configuration of SQLite. >Using Windows XP C++ API. >50,000 inserts into Table (with primary key and no other index as single >transaction commit) is taking 4.609000 sec. >50,000 selects from Table (

Re: [sqlite] Difference between OR and IN [http://www.sqlite.org/php2004/page-052.html]

2007-09-01 Thread RaghavendraK 70574
Thx. I want to know why prepareStatement: select * from xxx where IN (?); stmt.bind("abc,xyz,123"); is not supported for multiple values. Instead sqlite expect use to declare the statement var before hand, is it due to limitation of Virtual Machine impl? regards ragha