[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

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.

[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

[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