Re: [sqlite] Re: is safe to use the same database connection at the same time in more than one thread?

2007-11-11 Thread Don Lavelle
for your help. Cheers, Don On Nov 10, 2007, at 1:24 PM, Igor Tandetnik wrote: Don Lavelle <[EMAIL PROTECTED]> wrote: Second, my question is about SQLite and multi-threading. Basically, the snippet below means that if I have multiple threads executing SQL statements, and I want at

Re: [sqlite] Suggests for improving the SQLite website

2007-11-10 Thread Don Lavelle
Hi, As a developer who is new to SQLite, I'll say that my initial experience with the web site was that it was very busy and confusing. The available documentation seems to have a great deal of useful content, but I think would be more useful if it were organized, say into

Re: [sqlite] is safe to use the same database connection at the same time in more than one thread?

2007-11-10 Thread Don Lavelle
Hey, all. Thanks Gerry and Thomas for your replies. Now I know that my e-mails are being sent and are being received. This seems like a very knowledgeable and supportive mailing list. I'm really looking forward to participating. On Nov 10, 2007, at 11:18 AM, Thomas Fjellstrom wrote:

Re: [sqlite] is safe to use the same database connection at the same time in more than one thread?

2007-11-10 Thread Don Lavelle
statement 2 fails 50. thread 1: rollback, taking with it thread 2's effect If that's the case, it also answers my previous, unposted question about sqlite3_changes, which was, "what would sqlite3_changes return if it were called at line 35 in the above sequence?" Regards, Don

[sqlite] sqlite3_changes and multithreading

2007-10-23 Thread Don Lavelle
Hey all, I'm new to sqlite3, but it seems really cool, and I'm excited to be using it in a project. I'm also new to database programming in C. I've got a question, though. (I'm using SQLite 3.5.1 and C.) If I've got my database pointer, sqlite3 *database, and I have two threads that