Site-Search, built in
When you have your static content hosted on RdbHost, in the
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:http://www.postgresql.org/docs/9.3/static/textsearch-intro.html
with tsquery details at:http://www.postgresql.org/docs/9.1/static/datatype-textsearch.html