-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
stephen liu wrote:
I want to save multipile sqlite database in one file.
Generally that is a bad approach and instead you use more tables and
normalize your data more. However you know your situation better.
The backup api is not fix for this
I want to save sqlite database as a entry of the dbm.
If you really have to store the sqlite databases as blobs, why not store
them in yet another sqlite database as a blob instead of inside dbm?
SQLite has the drawback of not letting you resize a blob (you have to
create a new value with
-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 the
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
Matthew L. Creech mlcreech-re5jqeeqqe8avxtiumw...@public.gmane.org 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
Matthew L. Creech mlcreech-re5jqeeqqe8avxtiumw...@public.gmane.org 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
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
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
Rene Claassen claassen.r...@gmail.com
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)
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
Vinnie-4 wrote:
From: Neville Franks sql...@surfulater.com
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
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 user
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
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 joannekp...@yahoo.com
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
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
17 matches
Mail list logo