[pcplantdb] [permaculture] Groundnut, apios americana and PIW status
bear at ursine-design.com
Mon Feb 13 15:21:48 EST 2006
Those are some major issues.
Is this an artifact of the substring searching algorithm?
Can a better scoring method be implemented?
Latin name match: high
Common name: high
String search: lower
We might also want to consider a word index table. Split all the text
into words (on space, period, hyphen, etc), insert into the table, and
increment a word count field each time (counts could be useful). That
table might also be useful in fine tuning search results. We could store
search terms, find what's not matching etc.
I know PHP offers a method to test the similarity of 2 strings, and also
convert a string to a simplified phonetic representation. The phonetic
could help find misspelled words, I'm also wondering if MySQL offers a
similarity search to use in 'similar word' suggestions.
Regarding the page appearance, I really haven't looked at dev a whole
lot in terms of design.
If I could get a templating language to work in that'd be nice. Either
some PHP/Python crossover, a TAL templating system (native Python), or
maybe Django. A little more Model/View/Controller like (Code <---> Content).
If Chad can process the variables for me, and pass them to the template,
I can handle layout/HTML, and it's a lot nicer then writing HTML inside
First impressions are important. So maybe we should wait to wrap those
More information about the pcplantdb