[sqlite] FTS management

the site I need to know if this is an efficient way to keep the FTS table updated. Also, is there any pragma or so to tell FTS to automatically search for parts of words, instead of requiring users to add *? As said, thanks for any help and sorry for my bad english. -- Saluti da Gabriele F

[sqlite] Query with subqueries: is this the good way to go?

k=utenti.id INNER JOIN categorie ON otopic.categoria=? WHERE otopic.pub=1 ORDER BY otopic.sticky,otopic.inserito DESC Sorry for table names in italian utenti = users messaggi = messages -- Saluti da Gabriele Favrin http://www.favrin.net ___ sqlite-users

[sqlite] Questions about table optimization

ies, and so on... Or such a select would be complicated and is best to count so an index for replyto is required, and it's already there) and do a 2nd select? Thanks in advance and sorry for my BAD english. -- Saluti da Gabriele Favrin http://www.favrin.net ___