How to Create a Data History
Hello,
I am currently developing a web application and using SupaBase as my database. Each person can write a note, and I would like to keep a version of each note. This versioning would allow me to offer my users a history of their modifications.
How can I do this with SupaBase? I have seen solutions like pgaudit, is this the way to go? Or would it be better to manually create a "history" table and use triggers and functions to duplicate the data?
Thanks in advance for your help!
I am currently developing a web application and using SupaBase as my database. Each person can write a note, and I would like to keep a version of each note. This versioning would allow me to offer my users a history of their modifications.
How can I do this with SupaBase? I have seen solutions like pgaudit, is this the way to go? Or would it be better to manually create a "history" table and use triggers and functions to duplicate the data?
Thanks in advance for your help!
