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 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
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 long hours
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 to
--- [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
problems are
[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
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 main
--- 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 *sqlite3_vfs* object
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 of a
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 days.
On
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
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)?
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
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,
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 to be a
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
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 their windows
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
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 any able
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:
-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 public
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 person who wrote the
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 yesterday!
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 `B_FALSE'
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
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
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 read about
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. Surprisingly, it
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
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,
...
30 matches
Mail list logo
