FTS of files on disk

[gedw99]

Fts of files inside the db is nice .

I was wondering if there are any strategies for doing the same on files not inside the db but on disk , that leverages the same code ?

link to project use case

timelinize/timelinize#42 (comment)

[ncruces]

I think this would best be asked in SQLite forum.

But I suspect this has something to do with external content and contentless tables.

For external content tables, you may need to create a virtual table that maps a real (rowid, path) table to (rowid, path, text) virtual table by reading text from the file. Contentless can probably avoid this mapping? I'm not sure.

Regardless, there doesn't seem to be anything missing from my driver, but if it is, please add to #54.

[gedw99]

I was thinking of that mapping idea too .

it would mean keeping 2 copies of the data ? One in the db and another out .

[ncruces]

No, it involves a virtual table that loads text from files on demand.

[gedw99]

Ah I see .

so you reference all files you have on the FS in the DB.

Then track when a file on the FS changes and then get the DB to index it and store then indexes in the DB.

just needs a glob system for the files which is pretty easy .

Did I kind of get it right ?

[ncruces]

I'm not sure, I never did anything like this.
But ISTM nothing is really missing from this end.