SQLite Forum

get changed columns data (previous/ after) on update row and previous data before delete row
Login
I am looking for possible approaches can be used to fetch only changed columns names data (previous/ after) on row update and complete previous data before row delete operation.
I was looking at some references where triggers and update hook can be used to do so. On trying update hook, I noticed that only the row ID will be sent on insert/ update/ delete operation but that doesn't serve the purpose.
Looking for recommendation on how to achieve "fetch only changed columns names data (previous/ after) on row update and complete previous data before row delete operation." and if possible some examples on how that approach can be used.