Text file management software

Question

Is there a software which can tag plain text files, organize and index them like Calibre and provide extensive content searching (I can search the content of the text files)?

Answer 1

I am tempted to say SQLite with the FTS4 full text search extension (standard).

CREATE VIRTUAL TABLE text_files USING FTS4(file_id INTEGER PRIMARY KEY, file_content BLOB);
CREATE TABLE text_information(file_id INTEGER REFERENCES text_files(file_id), file_path TEXT, file_size INTEGER, whatever_you_want…);

With some C program it is easy to store a file into your database. Then a simple query performs full text search (syntax)

SELECT * FROM text_files WHERE file_content MATCH 'hello';