Best practises on Audit logs
Hi!
Can someone enlighten me on how to best do audit logging in Supabase? I know there’s a pgAdudit extensions; however, that seems to be logging on lower level than what’s preferred (?).
Has anyone setup there own audit table and track each transaction in their database? Based on my research, what I found is to create a new table in a «audit» space and create a function that you then invoke into your respective tables. The audit table will then keep information of old and new values, who performed the action, etc… anything else obvious ways that I am missing out on?
Can someone enlighten me on how to best do audit logging in Supabase? I know there’s a pgAdudit extensions; however, that seems to be logging on lower level than what’s preferred (?).
Has anyone setup there own audit table and track each transaction in their database? Based on my research, what I found is to create a new table in a «audit» space and create a function that you then invoke into your respective tables. The audit table will then keep information of old and new values, who performed the action, etc… anything else obvious ways that I am missing out on?
