How to Fetch data from MySQL to JSON Format using Phoenix-Elixir App

Hey @JeanWin25 welcome. To accomplish something like this you need to break down the problem. If you’re new to the language, then the first step is just getting familiar with basic Elixir. I like learning from books, so I used Search when I started. There are lots of resources out there though to fit various learning styles, and if you search the forums there are a variety of resource compilation threads.

From there you’ll want to learn the basics of Phoenix and Ecto. Phoenix will let you handle web requests, an Ecto will let you make queries into MySQL.

Start off by defining a basic Phoenix app. From there define your MySQL DB model using Ecto.Schema. The key point is above your schema you indicate that it should be JSON encoded.
E.g:

@derive {Poison.Encoder, except: [:__meta__]}
schema "authors" do
   field :name, :string
   has_many :books, Book
end

In the above I’m using the Poison JSON encoder.

I usually use the console to test things out as well.