<span title="Home" class="fa-solid-900 icon"></span> Home

Technology

Area of technology

Information technology

Computer

Software

Database

Relational database

Relational database management system

SQL keyword

{c}
{tag=Database trigger}
{wiki}

<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>:
  * https://stackoverflow.com/questions/24870416/counter-cache-column-in-postgresql
* <SQLite>
  * https://stackoverflow.com/questions/35255304/sqlite-create-trigger-for-insert-or-update

<ORM>:
* <Sequelize>: <SQL TRIGGER in Sequelize>


SQL TRIGGER

SQL TRIGGER in Sequelize

SQL TRIGGER

 Ancestors (11)

 Incoming links (1)

Discussion (0)

Articles by others on the same topic (0)

SQL TRIGGER

 Ancestors (11)

 Incoming links (1)

Discussion (0) Subscribe (1)

Articles by others on the same topic (0)

Discussion (0)