OurBigBook About$ Donate
 Sign in+ Sign up
by Ciro Santilli (@cirosantilli, 37)

SQL TRIGGER

 ... Database Type of database Relational database Relational database management system SQL SQL keyword
 0 By others on same topic  0 Discussions  Updated 2025-06-12  +Created 1970-01-01  See my version
Tags: Database 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 (12)

  1. SQL keyword
  2. SQL
  3. Relational database management system
  4. Relational database
  5. Type of database
  6. Database
  7. Software
  8. Computer
  9. Information technology
  10. Area of technology
  11. Technology
  12.  Home

 Incoming links (1)

  • SQL TRIGGER in Sequelize

 View article source

 Discussion (0)

+ New discussion

There are no discussions about this article yet.

 Articles by others on the same topic (0)

There are currently no matching articles.
  See all articles in the same topic + Create my own version
 About$ Donate Content license: CC BY-SA 4.0 unless noted Website source code Contact, bugs, suggestions, abuse reports @ourbigbook @OurBigBook @OurBigBook