Support for multi schema versioning about ex_audit HOT 2 OPEN

I have thought of this as well, mainly to be able to track schemas that have a different set of primary keys (for example the intermediate tables in many-to-many relationships).

I'd have to think about it a little more, but feel free to come up with suggestions!

from ex_audit.

My original use case was to track tables on multiple Postgres schemas.

I was thinking of moving the responsibility of tracking to the schemas themselves. We could still have a default version schema defined via configuration but the onus of deciding which schemas to track would be left to the schemas.

e.g:

config :ex_audit,  version_schema: MyApp.Version

defmodule MyApp.User do
  use Ecto.Schema

  use ExAudit.Track, with: MyApp.UserVersion

  schema "users" do
    field :email, :string
    field :name, :string

    timestamps()
  end
end

MyApp.UserVersion would set @schema_prefix to whatever the user wanted.

This of course does not address your comment about composite primary keys but it would lay the foundation for such work. This change would be a major rewrite so I don't know if you're interested.

Do you see any compatibility problems with the other features currently provided?

from ex_audit.