Audit log

[simonw]

Record who made what changes to ACLs and when.

I can display this on the bottom of the table page from #4 (and then in other places too later on).

[simonw]

While exploring this I span off this idea:

• Foreign key labels for tables with unique indexes on multiple columns simonw/datasette#2413

[simonw]

Ran this:

files-to-prompt datasette_acl/__init__.py datasette_acl/templates/table_acls.html | llm --system 'Suggest changes to add an Audit history list at the bottom of the table_acls page showing all changes made to that table in the past' -m claude-3.5-sonnet

Result: https://gist.github.com/simonw/de11a5f38cc580872a8a478f3d7fe6be

[simonw]

This will do for the moment:

It cuts off at 50 items. It would be neat to be able to link to a full paginated/faceted/filtered view of the entire audit log for viewing beyond 50. That's tricky as the table is in an internal database, but it would be neat to figure out a way to do that.