Re: [sqlite] import thousands of documents in SQLite

2011-04-05 Thread Matt Young
How about a text editor with search and replace. There must exist a list of the files in text form, hence search and replace gets a batch function that uses .import On Mon, Apr 4, 2011 at 2:41 PM, Simon Slavin wrote: > > On 4 Apr 2011, at 9:04pm, Gert Van Assche wrote: > > > We need to import t

Re: [sqlite] import thousands of documents in SQLite

2011-04-04 Thread Simon Slavin
On 4 Apr 2011, at 9:04pm, Gert Van Assche wrote: > We need to import thousands of documents in an SQLite db for use with FTS. > The FTS part I understand (more or less) but I don't know how to import so > many docs in the DB. > Does anyone know a tool to do this? > I won't be the one doing the im

[sqlite] import thousands of documents in SQLite

2011-04-04 Thread Gert Van Assche
All, We need to import thousands of documents in an SQLite db for use with FTS. The FTS part I understand (more or less) but I don't know how to import so many docs in the DB. Does anyone know a tool to do this? I won't be the one doing the import, but users that can't work on command line (or we