January 01, 2022

Optimizing Database Queries Using Elixir's Ecto and Telemetry

116

clicks

Optimizing Database Queries Using Elixir's Ecto and Telemetry

Source: johnelmlabs.com

The article outlines the process of detecting slow database queries in an Elixir application through Ecto's Telemetry events. John Curran explains that Telemetry can provide detailed information about query performance and can be used in conjunction with tools like LiveDashboard to visualize this data. He covers what Telemetry is and its role in the BEAM ecosystem, detailing how it can emit events with both measurements and metadata during process execution. Specifically, Curran teaches how to log slow Ecto queries by attaching event handlers to `:query` events, providing guidance on writing an event handler that logs queries taking longer than 500ms. He also explains metadata contents provided by the event, which includes the query string, making it easier to identify problematic spots. Additionally, Curran illustrates how to set up performance graphs on LiveDashboard to monitor Ecto performance visually. Finally, the utility of Telemetry as a diagnostic and monitoring tool within the Elixir/Phoenix framework is emphasized, showcasing the ability to log slow queries and visualize database query performance through LiveDashboard.

Organizing Email Logic within Phoenix Framework

Yevhenii Kurtov provides a structured guide for handling email logic in Phoenix projects. He emphasizes the need to keep the email subsystem separate from the host application, and recommends using libraries like Oban and Bamboo for scheduling and sending emails.

Jan 18, 2022

Managing Files in Elixir's Livebook

Peter Ullrich shares a cheatsheet on how to work with files in Livebook. He explains how to upload files, process their contents, and download files with ease.

Nov 06, 2023

Elixir's Flexibility in the Monolith vs. Microservices Debate

Elixir offers a simple way to avoid the monolith vs. microservices debate by providing clear modular boundaries in code and easy extraction of modules to separate services if needed. The author explains why microservices are often overused and emphasizes the importance of building modular software and investing in DevOps.

May 08, 2023