August 15, 2023

Implementing Unaccented Name Search in Postgres via Ecto

190

clicks

Implementing Unaccented Name Search in Postgres via Ecto

Source: peterullrich.com

The content provides an in-depth guide to making unaccented name search viable in a Postgres-backed Elixir application using Ecto. The crux of the problem is differentiating between names that look the same to a human reader but are treated differently by Postgres, such as 'José' and 'Jose'. To solve this, Ullrich details the use of Postgres's 'unaccent' function and shows how to integrate it with Ecto. Furthermore, he describes the process of migration to include this functionality, starting from adding the 'unaccent' extension to creating an immutable version of the 'unaccent' function and using it to index names efficiently. The article also covers the final updating of the search query to leverage the new index, ensuring that it performs well even with large data sets. Lastly, potential caveats and resources for further reading are provided to give a comprehensive understanding of the solution.

Continue reading

Related posts

Asynchronous Task Management in Phoenix LiveView

In this blog post, Mark Ericksen explains how to build an asynchronous workflow in a LiveView using Elixir's concurrency primitives. He demonstrates how to link processes, trap exits, and handle tasks, providing a step-by-step guide to achieve an elegant and efficient solution.

Aug 29, 2023

Cost Savings and Increased Performance with Elixir

Elixir, a dynamic and functional programming language, has saved businesses millions of dollars per year in server costs. Companies like Pinterest and Bleacher Report have experienced significant reductions in server expenses, with improved reliability and performance, by leveraging the power of Elixir and the underlying Erlang platform.

Aug 28, 2023

Understanding Elixir Tokenization and Parsing Using Erlang Tools

Andrea Leopardi explains how to tokenize and parse in Elixir using the leex and yecc modules. He mentions that lexers and parsers are often avoided due to their complexity, but these tools simplify the process and provide more powerful options for parsing text.

Jun 05, 2015

© HashMerge 2024