PyCon US 2023 PyCon US 2023 logo

PyCon US is the largest and longest-running annual gathering for the community using and developing the open-source Python programming language.

© 2023 Paolo Melchiorre CC BY-SA “Paolo Melchiorre after his talk at PyCon US 2023 in Salt Lake City (USA)”
© 2023 Paolo Melchiorre CC BY-SA “Paolo Melchiorre after his talk at PyCon US 2023 in Salt Lake City (USA)”

🏷️ Title

A pythonic full-text search

🗓️ Date

23th April 2023

🗣️ Language

🇬🇧 English

📍 Location

Salt Lake City, US 🇺🇸

🔗 Web

https://us.pycon.org/2023/schedule/presentation/148/

🗒️ Abstract

Keeping in mind the pythonic principle that “simple is better than complex” we’ll see how to implement full-text search in a web service using only latest versions of Django and PostgreSQL and we’ll analyze the advantages compared to more complex solutions based on external services.

📜 Description

A full-text search on a website is the best way to make its contents easily accessible to users because it returns better results and is in fact used in online search engines or social networks.

The implementation of full-text search can be complex and many adopt the strategy of using dedicated search engines in addition to the database, but in most cases this strategy turns out to be a big problem of architecture and performance.

In this talk we’ll see a pythonic way to implement full-text search on a website using only Django and PostgreSQL, taking advantage of all the innovations introduced in latest years, and we’ll analyze the problems of using additional search engines with examples deriving from my experience on djangopoject.com.

Through this talk you can learn how to add a full-text search on your website, if it’s based on Django and PostgreSQL, or you can learn how to update the search function of your website if you use other search engines.

🗺 Map

🎥 Video

www.youtube.com/watch?v=NS31C726xEw

📊 Slides

speakerdeck.com/pauloxnet/a-pythonic-full-text-search-pycon-us-2022