Hacker News new | ask | show | jobs
by bob1029 1120 days ago
I've never tried this exact thing, but I believe you could set up triggers and then have these invoke some application-defined function like:

  CREATE TRIGGER update_customer_address UPDATE OF address ON customers 
    BEGIN
      SELECT notify_table_event(tableName, id, etc...);
    END;
https://www.sqlite.org/lang_createtrigger.html

https://www.sqlite.org/appfunc.html