Re: [sqlite] Max limits on the following

ollowing > > http://www.sqlite.org/limits.html > --- > Marco Bambini > http://www.sqlabs.net > http://www.sqlabs.net/blog/ > http://www.sqlabs.net/realsqlserver/ > > > > On Jun 23, 2008, at 8:55 AM, Shailesh Birari wrote: > > > Hello all, > >

[sqlite] Max limits on the following

Hello all, I wanted to know if there are any upper limits on the following: I have seen sqlite_ext.h but did not any so just wanted to confirm the same. 1) Max number of tables in the sqlite database? 2) Max number of fields/columns in the table : 2000?? 3) Max column name size? 4) Max table

Re: [sqlite] Database locked error, while deleting

Richard, Just to go one step ahead, If there are independent connections, do you mean that there can exist multiple transactions at the same time? I think not since the first transaction (write) will exclusively lock the database and the second transaction will get a busy error. Correct me if I

Re: [sqlite] Forming a query with BLOB with null characters

PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shailesh Birari > Sent: Tuesday, June 03, 2008 5:02 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Forming a query with BLOB with null characters > > Thanks I found that later. > sprintf would rather

[sqlite] Forming a query with BLOB with null characters

Hello, I have a simple question here. I want to generate a insert query (char*) which will insert a blob in a table. This blob is nothing but a C structure in my program. So the query would be something like this INSERT INTO table1 VALUES ('12323232\0\0\0\023232323\0\0\023232323\0\03445\0')

Re: [sqlite] Transaction across threads

any clarifications on the below statements? -Shailesh > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shailesh Birari > Sent: Wednesday, April 16, 2008 11:30 AM > To: General Discussion of SQLite Database > Subject: Re: [s

Re: [sqlite] Transaction across threads

Thank you Ken, Hipp and Shawn. Below I am trying to summarize sqlite in the three dimensions of shared cache, transactions and threads. Please let me know which of the following are correct. Ideally I would like to put this list on the sqlite website for others. 1) With shared cache mode,

Re: [sqlite] Connection Sharing across threads

Can some one tell me if the sharing of connection is possible even when the shared cache mode is disabled? -Shailersh > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shailesh Birari > Sent: Monday, April 14, 2008 11:24 PM > T

Re: [sqlite] Transaction across threads

Does anyone have any answers for the queries below? -Shailesh > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shailesh Birari > Sent: Monday, April 14, 2008 9:55 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Transact

[sqlite] Connection Sharing across threads

In one of the wiki entries, http://www.sqlite.org/cvstrac/wiki?p=MultiThreading , I read that application cannot share the sqlite connection across threads. However in another posting at http://www.sqlite.org/sharedcache.html

[sqlite] Transaction across threads

Hello, I had a doubt of sqlite transactions across threads. I have a multithreaded application which shares the same sqlite connection across threads. I had a few doubts 1) If I do a begin transaction and insert on one thread. Then do a insert on the second thread and finally a commit on the

[sqlite] Open issues on latest build and last stable build

Can Some one give me pointers to the blog where all the open and reported issues on different releases is listed. So that If I have to use sqlite in my product I can choose the most suitable build after referring to this list.? Thanks, Shailesh. ___