A pythonic full-text search with Paolo Melchiorre - DjangoCon US 2022

Django Python

DjangoCon US 2022: Improved Full-Text Search with Paolo Melchiorre - Learn how to optimize your search queries and improve performance with Postgres and functional indexes, while extracting language and ranking results.

Key takeaways

Full text search in Django uses Postgres as the database and supports 28 different languages.
The search query performance can be improved with the use of a big and lasting memory.
There are different ways to extract language from the search document, and the title and body text can be used.
The Postgres filter search can extract and remove HTML tags automatically.
The search query expression can be used to search for complex search queries.
The search query can be speeded up by using a functional index.
The search vector field can be used to perform fine-grained full text searches.
The fuzzy search feature in Django can ignore common words in the search query.
The trigram rank number is used to calculate the rank of the search results.
The search result can be highlighted by using the search headline function.
The extra parts of the search document can be used to create a more complete search functionality.
The search query can be used to rank the search results based on the query text and the document.
The search results can be filtered based on the search query.
The search vector field can be used to perform case-insensitive queries.
The search query can be used to search for articles in a specific language.
The search results can be ordered based on the search query.
The search results can be filtered based on the search query.
The Postgres database can be used to perform full text searches.
The Django full text search can be used to search for articles in a specific language.
The Postgres filter search can be used to extract and remove HTML tags automatically.
The search query expression can be used to search for complex search queries.
The search query can be speeded up by using a functional index.
The search vector field can be used to perform fine-grained full text searches.
The fuzzy search feature in Django can ignore common words in the search query.
The trigram rank number is used to calculate the rank of the search results.
The search result can be highlighted by using the search headline function.

A pythonic full-text search with Paolo Melchiorre - DjangoCon US 2022

More talks