take a look at the postgres fulltext search capabilities, I can't make any
promises for your old postgres version
another common approach is to index the search into elasticsearch and
querying elasticsearch for the searches, it should handles misspellings and
return the search results fast, but yo
Django 1.10, Postgres 9.1 (for the moment), Python 2.7 (for the moment)
on Ubuntu 16.04
The search I need is an intersection hit.
We have a substance model with fields for ...
- name
- molecular formula with subscripted unicode numbers
- CAS number
plus a Synonym model in 1:n with substance a
2 matches
Mail list logo