[sqlite] attach readonly db to main db that is readwrite

My primary database is opened for read/write. I use the ATTACH command to attach a second database that lives in a read-only filesystem. It appears to mostly work, but is there anything I should be aware of or concerned about? One thing I noticed is if I run "ANALYZE" once the read-only is

[sqlite] duplicate a prepared statement?

through the results of these queries in step with each other, not serially. I was hoping to avoid preparing the same sql multiple times, on the assumption that it would be more efficient to somehow duplicate a prepared statement. Is this possible? Nick Hodapp

[sqlite] memory usage after VACUUM

I'm using sqlite in an iOS app, via the popular FMDB wrapper. My profiling tool is showing me that the app is using 2.5 MB of memory before a VACUUM, and nearly 6MB after. The tool shows that the extra memory was allocated by sqlite3MemMalloc(). If I close and re-open the database then the

[sqlite] FTS3 query question

MATCH in the requested context". Any pointers, please? Nick Hodapp ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] fts3 issue with tokenizing of content during a query

ns on the client, and to wrap search terms in dummy xml tags like this. But I feel I shouldn't have to do this... Any feedback appreciated... Nick Hodapp ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] custom fts3 tokenizer, used in read-only?

to the Porter tokenizer? And I can do that by registering a custom tokenizer-module in my read-only application that specifies the Porter functions, but has the name of the custom tokenizer I used to index the XHTML data. Does that seem reasonable? Nick Hodapp D. Richard Hipp wrote: > > &g

[sqlite] custom fts3 tokenizer, used in read-only?

table for a read-only query. Is it possible to change this behavior (or, is the tokenizer actually required for a read-only query?) If I register a dummy tokenizer with the same name in my read-only application, would that work? Nick Hodapp ___ sqlite