SQL TRIGGER

SQL's implementation of database triggers.

This feature is really cool, as it allows you to keep caches up to date!

In particular, everything that happens in a trigger happens as if it were in a transaction. This way, you can do less explicit transactions when you use triggers. It is a bit like the advantages of SQL CASCADE.

DBMS:

PostgreSQL:
- stackoverflow.com/questions/24870416/counter-cache-column-in-postgresql
SQLite
- stackoverflow.com/questions/35255304/sqlite-create-trigger-for-insert-or-update

ORM:

Sequelize: SQL TRIGGER in Sequelize

 Ancestors (11)

SQL keyword
SQL
Relational database management system
Relational database
Database
Software
Computer
Information technology
Area of technology
Technology
 Home

 Incoming links (1)

SQL TRIGGER in Sequelize