1

I have a project where I need to use SQLite in a local environment but Postgres on a normal server.

Unfortunately, there is no SQLite adapter for Ecto 3 yet, forcing me to keep the Ecto and some related packages at 2.x, which caused some problems such as this one: Ecto 2.0 SQL Sandbox Error on tests

I wonder if it would be possible to specify two different versions of Ecto and thus dependencies for the environments :local and :prod. Currently it seems impossible since there is only one lockfile per project. The only way to achieve it seems to be to store two different lockfiles in the project directory? e.g. https://elixirforum.com/t/only-fetch-deps-compatible-for-a-specific-version-of-elixir/16213

xji
  • 7,341
  • 4
  • 40
  • 61
  • Well I guess for my particular issue a better solution would be to use a different branch for the SQLite version of the app. Still the original question stands. – xji Feb 06 '19 at 09:08
  • Besides the obvious solution, which is to use Postgres in your local environment while there's no SQLite adapter for Ecto 3, I think keeping two different lockfiles is the cleanest solution if you don't want to create another branch. – BitParser Feb 06 '19 at 11:43

1 Answers1

1

I haven't tried it in depth, but maybe changing the mix.exs file like this would help:

defmodule YourProject.MixProject do
  use Mix.Project

  def project do
    [
      app: :your_project,
      version: "0.1.0",
      elixir: "~> 1.7",
      start_permanent: Mix.env() == :prod,
      deps: deps(Mix.env()),
      lockfile: lockfile(Mix.env())
    ]
  end

  # Run "mix help compile.app" to learn about applications.
  def application do
    [
      extra_applications: [:logger]
    ]
  end

  defp lockfile(:local), do: "mix-local.lock"
  defp lockfile(_), do: "mix.lock"

  # Run "mix help deps" to learn about dependencies.
  defp deps(:local) do
     [{:ecto, "~> 2.0"}]
  end

  defp deps(_) do
     [{:ecto, "~> 3.0"}]
  end
end

Both the lockfile and deps are different for the :local environment.

BitParser
  • 3,748
  • 26
  • 42