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.

Elixir ▷ Max

@mxgrn.com

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.

7/12/24, 6:46 pm0 reposts3 likes

Alex Loukissas

@alexloukissas.com

8 Dec 2024

Overkill but check out realtime from supabase GitHub.

Elixir ▷ Max

@mxgrn.com

9 Dec 2024

I went for the opposite of overkill and ended up with a pure SQL solution (credits to Claude): bsky.app/profile/mxgr...

Elixir ▷ Max@mxgrn.com

Poor man's audit log for Postgres tables. Pure SQL, no Elixir required. Time-to-shelf: 1 minute. Run the final part for each table you want to audit. Use Postico as the UI. gist.github.com/mxgrn/9900c2...

Cristian Álvarez

@crbelaus.com

7 Dec 2024

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...

brandur.orgEasy, alternative soft deletion: `deleted_record_insert`An alternate to traditional <code>deleted_at</code> soft deletion that stays out of the way and minimizes bugs.

kiki

@chiara.codes

8 Dec 2024

📌