django-haystack/postgres-fts-backend

postgres-fts-backend lets you add full-text search to a Django web app without standing up a separate search server. If you've ever wanted something like Elasticsearch or Solr but didn't want the operational headache of running and maintaining another service, this project points you toward the search capabilities already built into PostgreSQL, the database you're likely already using. Under the hood, it's a backend for django-haystack, which is a popular search layer for Django apps. Haystack is designed to work with multiple search engines, and this package adds PostgreSQL's native full-text search as one of those options. You install it, tell Haystack to use it, and your search queries get routed through PostgreSQL instead of an external system. It also supports fuzzy search, meaning if someone searches for "Janee" but the real name is "Jane," it can still find a match using PostgreSQL's built-in similarity matching. This is a good fit for founders or small teams who need search functionality but don't want to add infrastructure. A blog platform, a job board, or a directory site could use this to let users search through content with typo tolerance, all powered by the database they already have. It also supports languages beyond English, you can configure it for Spanish, for example, so word stemming and matching respect the rules of that language. There are some tradeoffs. PostgreSQL's full-text search doesn't support "more like this" recommendations, and spelling suggestions aren't available. It's also worth noting it requires fairly recent versions, Python 3.12+, Django 5.0+, and PostgreSQL, so it's aimed at projects on the newer end of the stack.