Re: [sqlite] import thousands of documents in SQLite
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 <slav...@bigfraud.org> wrote: > > 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 import, but users that can't work on command > > line (or we don't want them to do this). > > Employ a programmer to write you a program that will do it. That's what > they're for. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] import thousands of documents in SQLite
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 import, but users that can't work on command > line (or we don't want them to do this). Employ a programmer to write you a program that will do it. That's what they're for. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] import thousands of documents in SQLite
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 don't want them to do this). Your advise is highly appreciated, Thank you all. gert ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
