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
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
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
--- [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
>
[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
--- 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
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
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
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
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
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
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
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
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
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
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
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.
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
