Middle+

Have you used triggers in practice?

sobes.tech AI

Answer from AI

In Golang practice, I often use database-level triggers, for example, in PostgreSQL or MySQL, to automatically perform actions when data changes. In Go itself, triggers as such are absent, but you can implement similar logic through middleware or hooks in ORM.

Example: in PostgreSQL, you can create a trigger that logs an event or updates another table when a record is inserted into a table.

CREATE FUNCTION log_insert() RETURNS trigger AS $$
BEGIN
  INSERT INTO audit_log(table_name, operation, changed_at) VALUES (TG_TABLE_NAME, 'INSERT', now());
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER trg_after_insert
AFTER INSERT ON users
FOR EACH ROW EXECUTE FUNCTION log_insert();

In Go, you can respond to events through ORM, for example, GORM supports hooks like BeforeCreate, AfterCreate, etc., which allow implementing logic similar to triggers but at the application level.

Previous Next