PyRoma 2017

The last of the PyRoma (Python User Group of Rome, Italy) periodic meetings in 2017

images/20171114.jpg

ยฉ 2017 Paolo Melchiorre answering question after his talk at the PyRoma Meetup 2017 in Rome (Italy)

๐Ÿท๏ธ Full-Text Search in Django with PostgreSQL
๐Ÿ—“๏ธ 14th November 2017
๐Ÿ—บ Rome, Italy ๐Ÿ‡ฎ๐Ÿ‡น
๐Ÿ”— roma.python.it
๐Ÿ—ฃ๏ธ ๐Ÿ‡ฎ๐Ÿ‡น (italian)
๐Ÿ”ƒ twitter.com/pauloxnet
๐Ÿ“ฝ๏ธ speakerdeck.com/pauloxnet
๐Ÿค– github.com/pauloxnet

๐Ÿ—’๏ธ Abstract

After some experiences in the implementation of full-text search functionality with different system, we have decided to use PostgreSQL to implement full-text search functionality in our next project, a website to search for shows, venues, bands and festivals.

In the past, I have worked in two different projects, a mobile platform to sell and buy used items and a sport videos sharing platform, where I used two of the most currently famous full-text search software (Elasticsearch or Solr) but I had some synchronization and management problems.

After that, in my company, we searched for new Django support of full-text search PostgreSQL implementation and we decided to use it to avoid any problems that I had in the past.

Iโ€™m going to start speaking about the full-text search in a general context and I want to show the problems I encountered implementing it in the past.

Afterwards, Iโ€™m going to talk about the PostgreSQL functionality to implement the full-text search functionality and also present the django.contrib.potgres.search module, with step-by-step demonstrations of its functions with real world data.

Finally, Iโ€™m going to show the way we use and test this functionality in our project and which functionality lacks us to have a complete implementation of full-text search in our project.

At the end, I want to present my conclusions about our solution and I want to explore some new features that will be present in the next versions of Django and PostgreSQL.

๐Ÿ”ƒ Tweet

๐Ÿ—บ Map



๐Ÿ“ฝ Slides


 2017-11-14   2 min read      Talk   #Conference ๐Ÿ—ฃ๏ธ #PyRoma ๐Ÿ #Italy ๐Ÿ‡ฎ๐Ÿ‡น #Talk ๐Ÿ’ฌ