Re: [sqlite] get the actual database size.

2008-05-29 Thread P Kishor
On 5/29/08, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, > I have the database which has a lot of insertion and deletion. > Is there anyway that I can get the actual database size without running > VACUUM. Your question implies that VACUUM lets you "get the database size." No, it doesn't.

[sqlite] get the actual database size.

2008-05-29 Thread Joanne Pham
Hi All, I have the database which has a lot of insertion and deletion. Is there anyway that I can get the actual database size without running VACUUM. Thanks, JP ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Database Corruption

2008-05-29 Thread D. Richard Hipp
On May 29, 2008, at 4:38 PM, manas.abi wrote: > > Some more details: > > The scenario here is: > DB->Exec(Begin); //Transaction begin > DB->Step(); // Execute my query that is trying to insert a record in > the db > DB->Exec(End); //End the transaction > > When the last step is executed i.e.

Re: [sqlite] Database Corruption

2008-05-29 Thread manas.abi
Some more details: The scenario here is: DB->Exec(Begin); //Transaction begin DB->Step(); // Execute my query that is trying to insert a record in the db DB->Exec(End); //End the transaction When the last step is executed i.e. the end step, I am seeing that Sqlite now tries to write the record

Re: [sqlite] Sqlite 3.5.9 journal_mode vs ext3 journaling

2008-05-29 Thread Bob Ebert
I was under the impression that setting PRAGMA synchronous=NORMAL also removed the fsync() at step 6. I'm pretty sure when we run with synchronous=NORMAL we see only one fsync() call per COMMIT operation, not 2 (and definitely not 3 as we see with synchronous=FULL).

Re: [sqlite] SQLite C++

2008-05-29 Thread dcharno
>> Is there any future plan to develop sqlite in C++. >> > > Why would anybody want to do that? Maybe he is looking for a C++ wrapper for Sqlite. http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers ___ sqlite-users mailing list

Re: [sqlite] SQLite C++

2008-05-29 Thread Darko Miletic
Rajesh Nair wrote: > Hi > > Is there any future plan to develop sqlite in C++. > Why would anybody want to do that? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite C++

2008-05-29 Thread Rajesh Nair
Hi Is there any future plan to develop sqlite in C++. Rajesh Nair ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SqLite db ODBC

2008-05-29 Thread Barry Trutor
I am trying to locate an ODBC driver that I can use in the Windows Data Link. Is this doable? Does one exist? Thanks, Barry ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users