May 17, 2023

Deploying Elixir Apps with structure.sql in Production Environments

121

clicks

Deploying Elixir Apps with structure.sql in Production Environments

Source: fly.io

Ecto Phoenix Framework

In environments where the 'mix' build tool is not available—such as production—deploying an Elixir application after having used 'mix ecto.dump' can pose a challenge. This is especially true when older migration files have been deleted and the structure of the database must be set up from a 'structure.sql' file. The provided solution involves ensuring that 'psql' is available on the server, which may require amending the Dockerfile to install the 'postgresql-client' package. Additionally, custom functions such as 'check_and_execute_structure_sql/1' are added to the release's code, enabling the execution of the 'structure.sql' file upon deployment. This approach extracts the necessary elements from the 'mix ecto.load' task, adapting them to work in a production environment where mix is not present.

Continue reading

Related posts

Implementing OpenAI ChatGPT Streaming with Elixir

In this post by Jason Stiebs, he explains how to use Elixir to stream OpenAI Chat Response's in real time. By utilizing the ChatGPT Streaming API and the Req library, you can create a real-time interactive experience with low latency. Just follow his step-by-step guide to get started in minutes.

May 17, 2023

Exploring Nx and Tensors Beyond Machine Learning in Elixir

This post by Jason Stiebs explores the use of NX with Elixir for efficient math programming. It explains how tensors can be used to perform various mathematical operations and highlights the potential of NX for tasks like machine learning and image manipulation.

May 10, 2023

Handling Elixir Project Development Post Ecto Dump

Mark Ericksen offers a solution for developers who have deleted old migration files and are now facing a chicken-and-the-egg problem when bootstrapping a new server or setting up a clean database. By adding a step in the mix.exs file's ecto.setup task and using the ecto.load command with specific flags, developers can safely continue development with a structure.sql file generated from mix ecto.dump and without the older migrations.

May 08, 2023

© HashMerge 2024