Context Multitenancy for sqlite

[firesidewing]

Was spinning up a project and was going to do a database per organization with sqlite, as that combination seems very appealing for my use case but I got

** (Spark.Error.DslError) multitenancy -> strategy:
  Data layer does not support multitenancy

Postgres just seems too heavy weight for what i want to do, and i don't really want to have to deal with setting up a cloud database instance, was hoping to just keep it simple with sqlite. Was wondering if this is on the roadmap at all?

[zachdaniel]

Per-database multi tenancy is something we'd like to support both in postgres & sqlite, but at the moment it's something you'd effectively need to roll yourself. You can set the repo in the context:

defmodule YourChange do
  use Ash.Resource.Change

  def change(changeset, _, _) do
    Ash.Changeset.set_context(changeset, %{data_layer: %{repo: compute_repo(changeset.tenant)}})
  end

  def atomic(changeset, opts, context) do
    {:ok, change(changeset, opts, context)}
  end
end

defmodule YourPreparation do
  use Ash.Resource.Preparation

  def prepare(query, _, _) do
    Ash.Query.set_context(query, %{data_layer: %{repo: compute_repo(query.tenant)}})
  end
end

You could then add this to each resource's global change & preparation blocks:

changes do
  change YourChange, on: [:create, :update, :destroy] # destroy is off by default
end

preparations do
  prepare YourPreparation
end