Date: 2024-10-02
Time: 11:40–12:30
Room: The Forum
Level: Intermediate
"Advancing Search with PostgreSQL" is a session that details how PostgreSQL's features can be effectively used to significantly enhance the search functionality in any application.
In this session, we'll share insights on how we used PostgreSQL to facilitate precise searches across multiple fields in our mobile application. The techniques include using LIKE and ILIKE operators and integrating a trigram-based search to handle potential misspellings, thereby increasing the search accuracy.
Additionally, we implemented search based on similarity using data in vector types and created a Retrieval-Augmented Generation (RAG) application. By leveraging PostgreSQL's features and functionality, we developed a comprehensive search solution, which led us to victory at the TIDE NATO Hackathon.
While our application's case study involves a drug search, the techniques and principles shared in this session can be adapted to improve search functionality in a wide range of applications. Join us to learn how PostgreSQL can be harnessed to enhance your application's search capability.