Tatoeba / tatoeba2

Tatoeba is a platform whose purpose is to create a collaborative and open dataset of sentences and their translations.
https://tatoeba.org
GNU Affero General Public License v3.0
697 stars 132 forks source link

Fulltext search criterion on translation #1576

Open jiru opened 6 years ago

jiru commented 6 years ago

Allow to search a sentence from the language A whose translation in the language B contains some particular word. This would be quite useful as explained on the Wall.

Technically, we need to intersect two searches from two different indexes, but it looks like Sphinx doesn’t allow to do this directly. I think it should be possible to perform the two searches separately and intersect the results ourselves.

jiru commented 1 month ago

Manticore 6.3.0 has an SQL JOIN operator. While they say it’s still in beta, maybe this could be used to solve this issue.