Post

Could you recommend an #ElixirLang library for tracking changes in the database, such as for audit purposes? I need it to work with Postgres and Ecto.

I just realized that, for my purposes, I don't even need Elixir or Ecto. Aside from the UI, this should be achievable with pure SQL. Lo and behold, ChatGPT provided exactly what I needed: a log of JSON-formatted differences for changes in selected tables.

I was going to suggest this same approach: triggers that convert the updated/deleted row to a JSON object that can be logged or archived. @brandur.bsky.social provides a great example in brandur.org/fragments/de...