August 05, 2024

Efficiently Update Multiple Records in Ecto Using PostgreSQL and Fragments

372

clicks

Efficiently Update Multiple Records in Ecto Using PostgreSQL and Fragments

Source: geekmonkey.org

Fabian Becker details a method to update multiple records efficiently in an Elixir application using Ecto. The article walks through a scenario of updating a parent-child hierarchy in a database, which is achieved by using Ecto's `update_all/2` function in conjunction with PostgreSQL's `unnest` function. The process involves transforming tuples of record IDs and their new values into arrays and utilizing Ecto query fragments to perform the update in a single efficient database call.

Creating a Navigation Table of Contents for Phoenix Blogs with MDEx

The article demonstrates how to use the MDEx markdown parser to generate IDs and anchor links for headings in a Phoenix blog and create a Table of Contents component.

Aug 04, 2024

Overview of Gleam v1.4.0 Features and Enhancements

Louis Pilfold discusses the release of Gleam v1.4.0 and highlights its key features such as shorthand syntax for labels, code actions, label access completion, signature help, and more.

Aug 02, 2024

Introducing ErrorTracker: A Built-in Elixir Error Reporting and Tracking Tool

Cristian Álvarez Belaustegui discusses the challenges with third-party error reporting tools and introduces ErrorTracker, a self-hosted error tracking solution for Elixir applications.

Jul 31, 2024