Site-Search, built in

When you have your static content hosted on RdbHost, in the files table, you can easily add a site search capability using PostgreSQL's very capable text search capabilities.

The files table has a tsvec field, containing a tsvector representation of the file body.

It can be searched using a query like:

SELECT path from lookup.files WHERE %(search_words)::tsquery @@ tsvec;

The query string ('%(search_words)' in the example) should be a list of lexemes, with logical operators & and | and parenthesis used to clarify.

'! (fire | burn)' 'help & (rescue | rain)'

Documentation on PostgreSQL's search capabilities is at:

with tsquery details at: