Changes between Initial Version and Version 1 of Ticket #187


Ignore:
Timestamp:
11/18/09 15:52:46 (4 years ago)
Author:
dread
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #187 – Description

    initial v1  
    88 
    99Using this with sqlalchemy: http://lowmanio.co.uk/blog/entries/postgresql-full-text-search-and-sqlalchemy/ 
     10 
     11Issues with fulltext search: 
     12 
     13 * tags not indexed, so would need to 'or' search of tags. This would cause problems with the order_by of the query, since the tags wouldn't have a ranking. 
     14 * if tags are indexed then perhaps we don't want them converted into lexemes? Exact match could well be better. 
     15 * can we split the name on dash or underscore before being indexed? 
     16 * natural language search doesn't do partial words, so search for 'gov' doesn't bring up 'government'. 
     17 * do we keep the existing search system usable with a config file switch for if we install on a db aside from postgres? 
     18 * we want to weight name and title higher than other fields - achievable with custom trigger.