Re: [sqlite] get the actual database size.

P Kishor wrote: > 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 databas

Re: [sqlite] get the actual database size.

Joanne Pham 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. Thanks, JP Hi, Joanne. I assume that by "actual database size" you mean "the size of the database file minus the size of

Re: [sqlite] get the actual database size.

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

[sqlite] get the actual database size.

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 http://sqlite.org:8080/cgi-bin/mail

Re: [sqlite] SQLite C++

Rajesh Nair wrote: > Hi > > Is there any future plan to develop sqlite in C++. > Given that C++ has source and binary compatibility with C, I don't think there would be any point. I develop in C++ using SQLite quite happily, and see no reason to stop now. Clay ___

Re: [sqlite] Database Corruption

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

Re: [sqlite] Database Corruption

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 t

Re: [sqlite] Sqlite 3.5.9 journal_mode vs ext3 journaling

On May 29, 2008, at 4:13 PM, Bob Ebert wrote: > 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

Re: [sqlite] Sqlite 3.5.9 journal_mode vs ext3 journaling

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

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

Re: [sqlite] SQLite C++

dcharno wrote: >>> 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. Than look no further. SOCI is the definite sqlite c++ wrapper. http://soci.sourceforge.net/ _

Re: [sqlite] SQLite C++

>> 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 sqlite-users@sqlit

Re: [sqlite] SQLite C++

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

Re: [sqlite] SQLite C++

On 5/29/08, Rajesh Nair <[EMAIL PROTECTED]> wrote: > Hi > > Is there any future plan to develop sqlite in C++. Didn't you (or someone else) just ask that just a couple of days ago? I would say the chances of SQLite++ are less than zero (thank heavens), but for more details, search the list for an

[sqlite] SQLite C++

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

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