Re: [sqlite] Understanding locking and connections
The way I got around it was at the programmer level. Rollback,delay and try again. Thanks, Garyc --- On Sun, 5/16/10, Sam Carleton scarle...@miltonstreet.com wrote: From: Sam Carleton scarle...@miltonstreet.com Subject: Re: [sqlite] Understanding locking and connections To: General Discussion of SQLite Database sqlite-users@sqlite.org Date: Sunday, May 16, 2010, 9:15 AM On Sat, May 15, 2010 at 6:12 PM, Simon Slavin slav...@bigfraud.org wrote: On 15 May 2010, at 10:09pm, Sam Carleton wrote: Everything appears to be running fine, but... I was reading the thread late last week about SQLITE_BUSY and it got me wondering if I am doing things correctly. I would like to see documentation on what the Right Thing to do is for errors like SQLITE_BUSY from each of the common functions, e.g. on _step, on _finalise, etc.. It should include details of whether SQLite does its own retries or of how the programmer is expected to time retries. Simon, I did, but I did not see ANYTHING that addressed my question: I don't seem to have a performance issue with the general approach of doing multiple open/closes for each request, are there pitfalls out there that I am missing? Might it be worth the time and effort to keep the same connection through each request? Where can I go to find those answers? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] grabbing row contents?
Hiya, Got a quick question. I perform the following on a table: select * from table How do I know when the select has completed all its transactions? sqlite3_exec(db,query.c_str(),callback, this, db_err); I'm using the above statement,the callback is getting called as expected. Thanks, garyc ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] grabbing row contents?
Oh boy. Thanks. --- On Fri, 1/22/10, Jay A. Kreibich j...@kreibi.ch wrote: From: Jay A. Kreibich j...@kreibi.ch Subject: Re: [sqlite] grabbing row contents? To: General Discussion of SQLite Database sqlite-users@sqlite.org Date: Friday, January 22, 2010, 10:01 AM On Fri, Jan 22, 2010 at 07:57:50AM -0800, gary clark scratched on the wall: Hiya, Got a quick question. I perform the following on a table: select * from table How do I know when the select has completed all its transactions? sqlite3_exec(db,query.c_str(),callback, this, db_err); I'm using the above statement,the callback is getting called as expected. The function returns. -j -- Jay A. Kreibich J A Y @ K R E I B I.C H Our opponent is an alien starship packed with atomic bombs. We have a protractor. I'll go home and see if I can scrounge up a ruler and a piece of string. --from Anathem by Neal Stephenson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Creation of a sqlite database in VC++
Hi, I'm looking for an API in sqlite3 that allows me to create a database? Does one exist or do I have to do this from the command line i.e sqlite3.exe test.db Much appreciate any help on this as I thought one would be more available. Thanks, Gazza ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users