Cloud version

[MichaelDBA]

Since you are simply using an extension that uses SQL, you can make this available for contexts like the cloud that do not have access to the underlying operating system. Just simply import the file supa_audit--0.2.3.sql but first add the creation of the uuid ossp extension to the top of that file: CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

This could simply be added to the documentation instead of adding it as a feature request.

[olirice]

We chose to leave that option out of the README because it doesn't leave a good upgrade path unless the user is willing to periodically check back at the repo and run any new upgrade scripts.

We're still seeing occasional new issues that require updates to the extension. Once that tails off it might make sense to add a SQL only install option in the README for people on hosted platforms.

Would you be interested in opening a PR to update the README with the instructions + the upgrade caveat?

[MichaelDBA]

Sure, PR is ready

[olirice]

Note to self:

Once the extension has been stable w/ no major reported bugs for a few months, document installing as a SQL script.

Ref: https://github.com/supabase/supa_audit/issues/31#issuecomment-1101472001

TODO:

• [ ] Add caveats that it is the users responsibility to check back for upgrade scripts

[MichaelDBA]

Good point about that caveat.