Elixir connect to mysql example

conn.ex

defmodule Conn do
  def test do
    stat = "select * from users limit 10;"

    :emysql.add_pool :demo_pool, [
      size: 1,
      user: 'root',
      password: 'root',
      database: 'demo',
      encoding: :utf8    # you will need this
    ]

    res = :emysql.execute :demo_pool, stat
    rows = :emysql.as_proplist res
    # from keyword list to elixir map
    Enum.map rows, &Enum.into(&1, %{})
  end
end

mix.exs

defmodule SomeProject.Mixfile do
  use Mix.Project

  ##
  # bla, bla, bla
  ##

  # Add crypto, emysql to application start link.
  def application do
    [applications: [:crypto, :emysql]]
  end
  
  # Add emysql dependencies
  defp deps do
    [{:emysql, github: "Eonblast/Emysql", ref: "HEAD"}]
  end
end