Right now adding, updating, or deleting relies on explicitly calling stored procedures in the database to modify the respective periods for each category. This should be changed to automatically update the periods on any transaction modification without having to explicitly call the procedure.
This simplifies the client interface: we just have to modify the transaction row and the periods are safely updated. It also ensures better database consistency: if I manually delete a transaction in the Supabase dashboard, then I don't have to worry about consistency with the periods table as the trigger will handle it.
Right now adding, updating, or deleting relies on explicitly calling stored procedures in the database to modify the respective periods for each category. This should be changed to automatically update the periods on any transaction modification without having to explicitly call the procedure.
This simplifies the client interface: we just have to modify the transaction row and the periods are safely updated. It also ensures better database consistency: if I manually delete a transaction in the Supabase dashboard, then I don't have to worry about consistency with the periods table as the trigger will handle it.