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

2009-04-29 Thread Roger Binns
-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

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

2009-04-29 Thread stephen liu
> > > > 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

2009-04-29 Thread Roger Binns
-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] How do you guys use sqlite from C++?

2009-04-29 Thread Harald Nehring
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] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-29 Thread Giacomo Mussati
"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

2009-04-29 Thread Giacomo Mussati
"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

[sqlite] Another Date Question

2009-04-29 Thread Rene Claassen
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] Another Date Question

2009-04-29 Thread Steven . Farmer
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

Re: [sqlite] Another Date Question

2009-04-29 Thread Igor Tandetnik
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

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

2009-04-29 Thread ddevienne
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] How do you guys use sqlite from C++?

2009-04-29 Thread ddevienne
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

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

2009-04-29 Thread Dennis Cote
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

[sqlite] Transaction control At the SQL Level

2009-04-29 Thread Joanne Pham
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

[sqlite] mutex and begin/end transaction

2009-04-29 Thread James Gregurich
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

Re: [sqlite] mutex and begin/end transaction

2009-04-29 Thread D. Richard Hipp
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

Re: [sqlite] Transaction control At the SQL Level

2009-04-29 Thread Igor Tandetnik
"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

2009-04-29 Thread James Gregurich
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