Re: [sqlite] sqlite db portability

2007-08-28 Thread Markus Hoenicka
Quoting Uma Krishnan <[EMAIL PROTECTED]>: Hello Markus, How is libdbi different from, say odbc? I've never used ODBC, but from what I read I'd say the main differences are the footprint and the scope. libdbi is language-specific (C), lightweight, and allows you to do simple things in

RE: [sqlite] Unique ids for each record

2007-08-28 Thread Sreedhar.a
Hi, First my thanks to everyone for the response. Sorry for the delay in replying I was on leave. I am working on client server database method. I am going to manage a large amount of data. Somewhere around 4 records. Is it possible for me to fix the id range for each and every column. So

Re: [sqlite] Towards SQLite version 3.5.0

2007-08-28 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > --- [EMAIL PROTECTED] wrote: > > The transition from 3.4.2 to 3.5.0 will perhaps be the > > > The SQLite code currently in CVS HEAD is not ready for > > production use. We know that. We know what many of the > > problems are and Dan and I are working

Re: [sqlite] sqlite db portability

2007-08-28 Thread John Stanton
Markus Hoenicka wrote: Quoting Uma Krishnan <[EMAIL PROTECTED]>: Hello Markus, How is libdbi different from, say odbc? I've never used ODBC, but from what I read I'd say the main differences are the footprint and the scope. libdbi is language-specific (C), lightweight, and allows you

Re: [sqlite] Towards SQLite version 3.5.0

2007-08-28 Thread Joe Wilson
--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > --- [EMAIL PROTECTED] wrote: > > > The transition from 3.4.2 to 3.5.0 will perhaps be the > > > > > The SQLite code currently in CVS HEAD is not ready for > > > production use. We know that. We know what many of the >

Re: [sqlite] Towards SQLite version 3.5.0

2007-08-28 Thread Dennis Cote
[EMAIL PROTECTED] wrote: The transition from 3.4.2 to 3.5.0 will perhaps be the largest single change to SQLite since 2.8->3.0. I have *started* to prepare documentation describing the changes in 3.5.0. This is draft documentation. But for those who are interested, please visit

Re: [sqlite] sqlite db portability

2007-08-28 Thread Uma Krishnan
Just FYI, ODBC specs is very similar to JDBC, except that ODBC is in C whereas JDBC is in java. Thanks Uma Markus Hoenicka <[EMAIL PROTECTED]> wrote: Quoting Uma Krishnan : > Hello Markus, > > How is libdbi different from, say odbc? > I've never used ODBC, but from what I read I'd say the

Re: [sqlite] Towards SQLite version 3.5.0

2007-08-28 Thread Joe Wilson
--- Dennis Cote <[EMAIL PROTECTED]> wrote: > > sqlite3_vfs *sqlite3_vfs_find(const char *zVfsName); > > > > > > The argument is the symbolic name for the desired VFS. If the argument > > is a NULL pointer, then the default VFS is returned. The function > > returns a pointer to the

Re: [sqlite] Towards SQLite version 3.5.0

2007-08-28 Thread drh
Dennis Cote <[EMAIL PROTECTED]> wrote: > > I wonder if it might not be better to change this API to accept an empty > string, in addition to a NULL pointer, to find the default VFS. It seems > to me this might make life easier for those writing wrappers in > languages that don't have a concept

Re: [sqlite] Towards SQLite version 3.5.0

2007-08-28 Thread Klemens Friedl
The "sqlite3_exec" function has resided in the "legacy.c" file since shift to version 3. The function is still around in current v3.5 draft as http://www.sqlite.org/capi350ref.html says. That function is still kept around for compatibility reasons, as it was a important function in SQLite v2

Re: [sqlite] Towards SQLite version 3.5.0

2007-08-28 Thread Marco Bambini
On Aug 28, 2007, at 4:51 PM, Dennis Cote wrote: I wonder if it might not be better to change this API to accept an empty string, in addition to a NULL pointer, to find the default VFS. It seems to me this might make life easier for those writing wrappers in languages that don't have a

[sqlite] In memory database question

2007-08-28 Thread Virgilio Alexandre Fornazin
Hi There´s possible to share a sqlite3 handle to a memory database in all threads of application? Or there´s a way to ‘duplicate’ the handle (sqlite_open() or something like that)?

Re: [sqlite] In memory database question

2007-08-28 Thread RaghavendraK 70574
Hi, I did tried something crazy like this (it worked, for read only DB only). I changed pread to preadCustom api.Then in preadCustom maintained a static fdArray. if fd is not listed then i mmap the whole file and the use the memcpy to return the data. There was significant performance again as

RE: [sqlite] In memory database question

2007-08-28 Thread Virgilio Alexandre Fornazin
I'm thinking in a more generic way... using /dev/shm works on linux, but not on windows. Also, r/w support is a must have, so this approach cannot solve the problem. Since we have 'drivers' for windows / linux / etc, a 'memory' driver would be enought, simulating file opening / closing / deleting,

Re: [sqlite] Skype client using SQLite?

2007-08-28 Thread Jeremy Hinegardner
On Tue, Aug 28, 2007 at 03:13:47PM +, [EMAIL PROTECTED] wrote: > In reference to > >http://www.sqlite.org/cvstrac/tktview?tn=2592 > > This is the first public indication we have had that > Skype is using SQLite in their windows clients. However, > the person who wrote the ticket seems

[sqlite] compiling 3.4.2 on solaris

2007-08-28 Thread rahed
Hello, when running make I get: sed -e s/--VERS--/3.4.2/ ../sqlite/src/sqlite.h.in | \ sed -e s/--VERSION-NUMBER--/3004002/ >sqlite3.h gcc -g -O2 -o lemon ../sqlite/tool/lemon.c ../sqlite/tool/lemon.c:111: error: redeclaration of enumerator `B_FALSE' /usr/include/sys/types.h:176: error: previous

Re: [sqlite] Skype client using SQLite?

2007-08-28 Thread Trevor Talbot
On 8/28/07, Jeremy Hinegardner <[EMAIL PROTECTED]> wrote: > On Tue, Aug 28, 2007 at 03:13:47PM +, [EMAIL PROTECTED] wrote: > > In reference to > > > >http://www.sqlite.org/cvstrac/tktview?tn=2592 > > > > This is the first public indication we have had that > > Skype is using SQLite in

[sqlite] CURRENT_TIMESTAMP value in single transaction

2007-08-28 Thread Brandon, Nicholas \(UK\)
When enclosed in a single transaction, would inserting many rows into a table using the special default keyword 'CURRENT_TIMESTAMP' result in all of the rows guaranteeing the same timestamp value? If not, is there a recommended way to assign a unique value to a collection of inserts in a single

Re: [sqlite] Skype client using SQLite?

2007-08-28 Thread Kees Nuyt
On Tue, 28 Aug 2007 15:13:47 +, you wrote: >In reference to > > http://www.sqlite.org/cvstrac/tktview?tn=2592 > >This is the first public indication we have had that >Skype is using SQLite in their windows clients. However, >the person who wrote the ticket seems to be a bit confused. >Can

RE: [sqlite] Skype client using SQLite?

2007-08-28 Thread Mike Marshall
The same file appears on the windows version -Original Message- From: Jeremy Hinegardner [mailto:[EMAIL PROTECTED] Sent: 28 August 2007 17:05 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Skype client using SQLite? On Tue, Aug 28, 2007 at 03:13:47PM +, [EMAIL PROTECTED] wrote: >

RE: [sqlite] Skype client using SQLite?

2007-08-28 Thread Robert Simpson
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 28, 2007 8:14 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Skype client using SQLite? > > In reference to > >http://www.sqlite.org/cvstrac/tktview?tn=2592 > > This is the first

Re: [sqlite] Skype client using SQLite?

2007-08-28 Thread Kees Nuyt
On Tue, 28 Aug 2007 18:44:50 +0200, you wrote: >On Tue, 28 Aug 2007 15:13:47 +, you wrote: > >>In reference to >> >> http://www.sqlite.org/cvstrac/tktview?tn=2592 >> >>This is the first public indication we have had that >>Skype is using SQLite in their windows clients. However, >>the

Re: [sqlite] compiling 3.4.2 on solaris

2007-08-28 Thread Brian Munroe
On 8/28/07, rahed <[EMAIL PROTECTED]> wrote: > /usr/include/sys/types.h:176: error: previous definition of 'B_TRUE' was here > *** Error code 1 > make: Fatal error: Command failed for target `lemon' > > Could somenone suggest what's wrong? > Rahed: Funny enough, I just ran into this problem

Re: [sqlite] compiling 3.4.2 on solaris

2007-08-28 Thread drh
rahed <[EMAIL PROTECTED]> wrote: > Hello, > > when running make I get: > > sed -e s/--VERS--/3.4.2/ ../sqlite/src/sqlite.h.in | \ > sed -e s/--VERSION-NUMBER--/3004002/ >sqlite3.h > gcc -g -O2 -o lemon ../sqlite/tool/lemon.c > .../sqlite/tool/lemon.c:111: error: redeclaration of enumerator

Re: [sqlite] Towards SQLite version 3.5.0

2007-08-28 Thread Eugene Wee
Would this be a good time to replace the older sqlite3_prepare() and sqlite3_prepare16() interfaces with what is currently the newer sqlite3_prepare_v2() and sqlite3_prepare16_v2() interfaces respectively? Admittedly they are definitely not among the "less frequently used interfaces", but such

Re: [sqlite] CURRENT_TIMESTAMP value in single transaction

2007-08-28 Thread Dennis Cote
Brandon, Nicholas (UK) wrote: When enclosed in a single transaction, would inserting many rows into a table using the special default keyword 'CURRENT_TIMESTAMP' result in all of the rows guaranteeing the same timestamp value? If not, is there a recommended way to assign a unique value to a

Re: [sqlite] sqlite db portability

2007-08-28 Thread Shilpa Sheoran
Thanks everyone for your input. Shilpa On 8/27/07, Asif Lodhi <[EMAIL PROTECTED]> wrote: > Hi Shilpa, > > On 8/28/07, Shilpa Sheoran <[EMAIL PROTECTED]> wrote: > > Eg. I create sqlite db file say "mysqlitedb.db" and now I have MySQL > > installed. Can it access "mysqlitedb.db" > > IIRC, I did

Re: [sqlite] CURRENT_TIMESTAMP value in single transaction

2007-08-28 Thread Kees Nuyt
Hi Nick, On Tue, 28 Aug 2007 17:39:16 +0100, you wrote: > When enclosed in a single transaction, would inserting > many rows into a table using the special default keyword > 'CURRENT_TIMESTAMP' result in all of the rows > guaranteeing the same timestamp value? Did you try? I did.

[sqlite] Newby Question

2007-08-28 Thread Graham Wickens
Hi All, I'm trying to learn SQLITE from a book and am making slow progress. My question is, in the following TRIGGER how do I tell it to only update the single record that the field Interested was updated? its a logical field either TRUE of FALSE, I want the trigger to work when the Field is

Re: [sqlite] Newby Question

2007-08-28 Thread Simon Davies
Hi Graham, The trigger needs a where clause, as in the following: sqlite> sqlite> create table temp( id integer primary key, ...> interested integer, ...> val1 text, ...> val2 text, ...>