Re: [sqlite] mutex and begin/end transaction

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

Re: [sqlite] Transaction control At the SQL Level

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

Re: [sqlite] mutex and begin/end transaction

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

[sqlite] mutex and begin/end transaction

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

[sqlite] Transaction control At the SQL Level

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

Re: [sqlite] listing registered SQL functions (aggregate or scalar)

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

Re: [sqlite] How do you guys use sqlite from C++?

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

[sqlite] listing registered SQL functions (aggregate or scalar)

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

Re: [sqlite] Another Date Question

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

Re: [sqlite] Another Date Question

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

[sqlite] Another Date Question

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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

"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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

"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

Re: [sqlite] How do you guys use sqlite from C++?

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

Re: [sqlite] A memvfs for loading/saving database from buffer

-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

Re: [sqlite] A memvfs for loading/saving database from buffer

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

Re: [sqlite] A memvfs for loading/saving database from buffer

-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