We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
Full Text Search with Django and PostgreSQL: More Facets, Less Dependencies! - DjangoCon US 2022
Django and PostgreSQL team up to bring you full-text search with faceting, reduced dependencies, and improved database performance, all wrapped up in a reusable alpha app.
- JavaScript is used to create facets for filtering search results
- Database performance is improved by using search vectors and queries
- The reusable app is only in alpha but is useful for faceted navigation
- Reducing dependencies is achieved by using PostgreSQL’s full-text search instead of Elasticsearch
- Joining the Cactus team would provide experience working on diverse projects
- There is a limit to the number of rows in the database
- Filters in the left navigation bar show different classifications, categories, and genres
- PostgreSQL converts documents or text into lexemes and provides simple syntax for search queries
- Faceting with PostgreSQL is less complex than with Elasticsearch
- Django filter is a great tool for filtering data
- Django Haystack provides a search interface to Elasticsearch
- User experience with PostgreSQL is similar to Elasticsearch but with less complexity
- The reusable app is free and open source