-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
stephen liu wrote:
> For addressbook application, it call select_all_address_for_one_user
> frequency.
> If multipile users' addresses store in one table, the
> select_all_address_for_one_user
> will cause much I/O operations.
If you have an index on
Just stumbled over SOCI (http://soci.sourceforge.net/) in
my search for an easy to use C++ interface to relational DBs. Scales from
simple scalar queries to OR mapping and STL/Boost integration. Supports
SQLite as backend.
Haven't tested it yet, but the concept
sounds clean and promising.
MfG H
"Matthew L. Creech" wrote
in message
news:5ee96a840904271946o315df05dxb45024d5c0474...@mail.gmail.com...
> On Mon, Apr 27, 2009 at 10:25 PM, liubin liu
> <7101227-k+ct0dcb...@public.gmane.org> wrote:
>>
>> thanks
>>
>> I'm not sure of the real reason.
>> It's true that the speed of inserting with
"Matthew L. Creech" wrote
in message
news:5ee96a840904271946o315df05dxb45024d5c0474...@mail.gmail.com...
> On Mon, Apr 27, 2009 at 10:25 PM, liubin liu
> <7101227-k+ct0dcb...@public.gmane.org> wrote:
>>
>> thanks
>>
>> I'm not sure of the real reason.
>> It's true that the speed of inserting with
I've had a problem before where I received an 'Invalid Use of Null' error
when I'm quering a DateTime field from vb6. Olaf send me a link to another
class, and when I used that I could query the data, but I still have a
problem if I want to link to the data from MS Access or Cold Fusion.
If I do a
If you just convert that floating number back to a date using the CDate
Function. It properly converts it back. Open the vb project and do not
run it but just open the Immediate window and type the following lines and
you will see it do the conversion.
? cdate(39895.56086)
3/23/2009 1:27:38 P
Rene Claassen
wrote:
> If I do a normal select on the field in SQLite2008 I get the
> following: Select Date_Stamp
> from in_wt;
> 2009-03-23 13:27:38
> 2009-03-23 13:43:20 etc
>
> And lastly if convert it to a float it gives the following:
> Select cast(Date_Stamp as float)
> from in_wt;
> 39
I can't find a way to list registered functions (the built-in ones and the
ones added programmatically) via an API call nor via a built-in table like
there is for tables in sqlite_master, which I could query.
How does one get this list? Or asked differently, how would a user know
which SQL functi
Vinnie-4 wrote:
>
>> From: Neville Franks
>
> Apparently I did come up with an original idea. Because none of the
> wrappers from the archives are using variable argument lists.
>
That's because many C++ programmer don't like using printf-like vararg calls
which are not type safe. I for one
ddevienne wrote:
> I can't find a way to list registered functions (the built-in ones and the
> ones added programmatically) via an API call nor via a built-in table like
> there is for tables in sqlite_master, which I could query.
>
> How does one get this list? Or asked differently, how would a u
Hi All,
I read the document about "File Locking And Concurrency IN SQLite Version 3"
about the "Transaction Control At The SQL Level" as below:
"If multiple commands are being executed against the same SQLite database
connection at the same time, the autocommit is deferred until the very last
howdy!
question:
for an in-memory db with the threading mode set to serialized, is the
internal mutex held for an entire transaction so that one thread won't
access the db while another one is in the middle of a transaction with
multiple insert statements?
thanks for any info.
James Greg
On Apr 29, 2009, at 10:03 PM, James Gregurich wrote:
> howdy!
>
> question:
>
> for an in-memory db with the threading mode set to serialized, is the
> internal mutex held for an entire transaction so that one thread won't
> access the db while another one is in the middle of a transaction with
>
"Joanne Pham"
wrote in message news:464293.67815...@web90308.mail.mud.yahoo.com
> 1) : If I have mulitple commands which are used the same SQL database
> connection then all commands after the first won't commit to the
> database if the first one is not completed"
Correct.
> 2) Is that sqlite3_r
thanks for the info. That should work for me.
Given the industry is going multicore and 16-core macintoshes for your
grand-mother are just a few years away, I recommend you rethink your
position on the use of threading. Apple is heavily pushing parallelism
on its developers. NSOperation i
Thank you Steven and Igor. Both methods worked.
Rene
-- Forwarded message --
From: steven.far...@dds.net
To: General Discussion of SQLite Database
Date: Wed, 29 Apr 2009 11:56:15 -0400
Subject: Re: [sqlite] Another Date Question
If you just convert that floating number back to a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Gregurich wrote:
> Given the industry is going multicore and 16-core macintoshes for your
> grand-mother are just a few years away, I recommend you rethink your
> position on the use of threading.
Threading is the worst solution to many cp
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
ddevienne wrote:
> How does one get this list?
There is no public API. If you use the amalgamation then you can add
code to dig it out of the SQLite internals (a hash table amongst other
things). Look for functionSearch and sqlite3FindFunction
> O
18 matches
Mail list logo