#32492: Add django API for Postgres pg_trgm word_similarity, fuzzy full-text
search.
-------------------------------------+-------------------------------------
Reporter: Taneli | Owner: Nikita
| Marchant
Type: New feature | Status: assigned
Component: contrib.postgres | Version: dev
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Nikita Marchant):
Hi 👋
I've open a pull request (https://github.com/django/django/pull/14833)
implementing the `trigram_word_similar` lookup and updating the
documentation.
I also wrote a test, but for it to be meaningful, i needed a longer string
that the 16 chars available on `CharFieldModel.field` in the tests. I did
increase the limit to 64 and updated the migration at the same time. Is
this the right approach or should it create a new model or a new migration
? (As the test database is recreated almost each time, i guessed that
modifying a migration is not a big deal but i could be wrong).
I ran the tests on PostgreSQL 13.4 on Mac with Python 3.9.1
I also have some code (adding `TrigramWordSimilarity` and
`TrigramWordDistance`) almost ready for the rest of the ticket but i still
have some troubles/questions because the order of the arguments of
`WORD_SIMILARITY()` is meaningful, unlike for `SIMILARITY()`. Should we
discuss it here or on GitHub ?
--
Ticket URL: <https://code.djangoproject.com/ticket/32492#comment:7>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/065.43c2694d8dd59b8e87e25aacf5b86fe1%40djangoproject.com.
