PyCon IT 2017 “Otto”

PyCon Italia is the national conference where professionals, researchers and enthusiasts of the most beautiful programming language gather together.

images/20170408.jpg

ยฉ 2017 Paolo Melchiorre taking a selfie after his talk at the PyCon IT 2017 in Florence (Italy)

๐Ÿท๏ธ Full-Text Search in Django with PostgreSQL
๐Ÿ—“๏ธ 8th April 2017
๐Ÿ—บ Florence, Italy ๐Ÿ‡ฎ๐Ÿ‡น
๐Ÿ”— www.pycon.it
๐Ÿ—ฃ๏ธ ๐Ÿ‡ฎ๐Ÿ‡น (italian)
๐Ÿ”ƒ twitter.com/pauloxnet
๐Ÿ“ท flickr.com/people/paulox_net
๐Ÿ“Š๏ธ speakerdeck.com/pauloxnet
๐ŸŽฅ youtube.com/c/PaoloMelchiorre
๐Ÿค– 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

๐Ÿ“ท Photos

PyConIT 8 2017 Day 2

๐Ÿ—บ Map



๐Ÿ“Š Slides


๐ŸŽฅ Video



 2017-04-08   2 min read      Talk   #Conference ๐Ÿ—ฃ๏ธ #PyCon ๐Ÿ #Italy ๐Ÿ‡ฎ๐Ÿ‡น #Talk ๐Ÿ’ฌ