# SQLite Triggers (+ Android Room)

DevFeed: [SQLite Triggers (+ Android Room)](<https://devfeed.tech/articles/sqlite-triggers-android-room-38622.md>)

Original publisher: [Read original article](<https://krossovochkin.com/posts/2020_01_17_sqlite_triggers_android_room/>)

Published: 2020-01-17T00:00:00Z

Content type: tutorial

Language: en

Sources: [Vasya Drobushkov](<https://devfeed.tech/sources/vasya-drobushkov.md>)

Topics: [SQLite](<https://devfeed.tech/topics/sqlite.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Android](<https://devfeed.tech/topics/android.md>), [Mobile](<https://devfeed.tech/topics/mobile.md>)

Tags: [android](<https://devfeed.tech/tags/android.md>), [logging](<https://devfeed.tech/tags/logging.md>), [room](<https://devfeed.tech/tags/room.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [triggers](<https://devfeed.tech/tags/triggers.md>)

## AI overview

A tutorial explaining SQLite triggers, including their syntax, BEFORE, AFTER, and INSTEAD OF modes, and how they respond to database events. It discusses limitations around application callbacks and suggests logging table changes as a practical use case, with Android Room included in the title.

## Source excerpt

Introduction SQLite is one of the most used database. This is because it is used on almost all mobile devices in the world. As SQLite is very similar to SQL everyone already knows the basic concepts like querying, inserting, updating, deleting data; databases and tables; joining tables etc. But SQLite also has some advanced features and this article is about one of such called Trigger. If we try to speculate on the name "Trigger" we might say that probably something will be done when some changes are made to the database. And we're pretty close to the truth.