Re: [sqlite] sqlite command-line utility (was: manual? documentat ion?)

> What does the... > "(one varchar(10), two smallint)" > ...in the following example... > "sqlite> create table tbl1(one varchar(10), two smallint);" > ...mean/do? It creates the table 'tbl1' shaped like this. +-+ | one | two | +-+ | | | | | |

[sqlite] locked - what am I doing wrong?

When you first call sqlite_step() for your SELECT statement, SQLite grabs a read-lock on the database file. It doesn't release this lock until you call sqlite_finalize(). When you execute your UPDATE, SQLite needs to get a write-lock on the database file. It can't get the write-lock while

Re: [sqlite] need faster count(*)

> Doesn't sqlite "know" the number of rows in each table without > explicitly counting them? Thanks for any help Buzz No it doesn't know that. One thing you could try using is triggers. eg. Set a trigger to increment a value in some other table when a row is inserted, and decrement the value