Then we run sqlite3 in terminal providing database name and we’re ready: % sqlite testdb Create tables
![db browser for sqlite trigger db browser for sqlite trigger](https://software-advice.imgix.net/managed/products/screenshots/mn.png)
Setupįirst of all we’ll download SQLite command line tool for our platform following instructions here. timestamp - is timestamp of when insertion was done.It has the following structure: _id | timestamp | payload
![db browser for sqlite trigger db browser for sqlite trigger](https://www.revove.com/img/sqlite-viewer/tabular-bar.png)
We’ll store that information in the log table.
![db browser for sqlite trigger db browser for sqlite trigger](https://1.bp.blogspot.com/-ZRX-DbdCWSU/XojOkIOk5yI/AAAAAAAAC1U/YC4bYBfCDQwavpSqB9GD98l5ZqMPpsX3QCLcBGAsYHQ/w1200-h630-p-k-no-nu/SQLite%2BExpert%2BProfessional%2B5.3.5.474%2BDatabase%2BManagement%2BDownload.png)
Triggers are database operations that are automatically performed when a specified database event occurs. 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. But SQLite also has some advanced features and this article is about one of such called Trigger. 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. This is because it is used on almost all mobile devices in the world.