Re: [sqlite] fts1 and copying memory dbs to disk

On 10/31/06, Bryan Oakley <[EMAIL PROTECTED]> wrote: Given that, is there a reliable, portable way to copy a memory db to disk, when that db makes use of the FTS1 module? I've been pondering this, and nothing good came of it :-). My best suggestion would be to modify your copy system to first

[sqlite] fts1 and copying memory dbs to disk

Is there a good way to copy a memory db to disk, when that memory db uses the FTS1 module? I've got code that uses a memory db, then copies it to disk. I use the trick of copying the schema to disk with this: diskdb transaction { memdb eval {SELECT sql FROM sqlite_master WHERE sql NOT