[sqlite] primary key is indexed by default ?
Hi Just wondering that if you set primary key in table, the column is indexed by default in sqlite ? thanks a lot Richard K ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] concurrent write
Hi Alexey, Thanks for your link, but it is not really click me too well I should set this busy_timeout to longer ms than current ? Richard K -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alexey Pechnikov Sent: Friday, November 28, 2008 3:00 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] concurrent write Hello! В сообщении от Saturday 29 November 2008 01:16:17 Richard Kim написал(а): > We have database table, and it is being written, sometimes 30 times a > second. > Some of the data succeeded, but some aren't. > > How should we handle this sort of lock issue ? http://www.sqlite.org/c3ref/busy_timeout.html Best regards, Alexey. ___ 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] concurrent write
Hi, We have database table, and it is being written, sometimes 30 times a second. Some of the data succeeded, but some aren't. How should we handle this sort of lock issue ? thanks Richard K ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Malformed schema error on sqlite3odbc.dll with version 0.79
Hi guys, We are using sqlite as our database and noticed some weird odbc driver problem. "malformed database schema (deleteUserGroupsByUsers) - no such table: main.Users (11)" If I open the database with other tool such as sqlite studio, or firefox plug in, there is no problem - the schema check seems to be okay, and all the tables are there.. etc. Also If I use S3ODBC.dll, we don't see ths issue of the malformed database schema either. It happens only if I use sqlite3odbc.dll with version 0.79. Is this known bug ?? Thanks Richard K ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users