Sessions

You don't need Elasticsearch! Fuzzy Search with PostgreSQL and Spring Data

Thomas Gräfenstein - E.ON One

Have you ever needed to implement a search feature that’s error-tolerant, fast, and delivers relevant results regardless of the natural language and you didn’t want to run your own Elasticsearch or Opensearch cluster?

Look no further! In this talk, we’ll explore how PostgreSQL’s powerful tools enable fuzzy text search. From similarity scoring to trigram matching, discover practical techniques to build robust search capabilities. And the best part? You will learn how to seamlessly integrate these features into your application using Spring Data JPA, all while ensuring your code remains clean, abstract, and reusable.