Pathwalker (pathwalker) wrote,

Full Text Searches

Ever wonder how many times the word heath shows up in Wuthering Heights? Now you can find out.

I've been playing with ways of searching text that is stored in PostgreSQL. The tsearch module appears to really rock - it's simple to add to an existing table (one new column, index and trigger have to be added) and it is really fast.

I've been testing it out on a copy of Wuthering Heights.

If anyone is feeling bored, they can play around with a simple web front end here.
  • Post a new comment


    default userpic
    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.