search

wellcometrust / reach

Wellcome tool to parse references scraped from policy documents using machine learning
MIT License
26 stars 4 forks source link

Implement Postgres SQL search in 'Search Policy Docs' and 'Find Citations' #523

Closed dd207 closed 4 years ago

dd207 commented 4 years ago

Users need a consistent and quality search logic in the product.

Discussions with @jdu meant that postgres tsvector or tsquery is the recommended search logic to use across both aspects of the product.

https://www.postgresql.org/docs/10/datatype-textsearch.html

dd207 commented 4 years ago

Can we work on this next sprint @SamDepardieu? If you're done with QA of the tables.

SamDepardieu commented 4 years ago

Yes, I'm already including it so the big PSQL update will be complete when we release it

dd207 commented 4 years ago

Thanks Sam - want to make sure it's tracked through the system 👍

dd207 commented 4 years ago

@jdu I'm going to put this in sprint backlog as I know this is being implemented in amongst the other tasks on Postgres SQL