The initial blog was build on SQLite but migrated to PostgreSQL to take advantage of the full-text features.
The text search is against multiple fields, initially but inefficiently on the blog post title and body.
In order to optimise the search and provide more efficient results, this site uses SearchVertor in conjunction with SearchRank and weight values. It provides a fast and relevant search result.
The search results are further enhanced by the exclusion of common stop words.