SQLite Forum

Request: stored functions/procedures
Login
> There's nothing special about triggers except that they make referential integrity easier to enforce.

That ignores race conditions in concurrent update scenarios. If that matters to your app, then triggers are the *only* way to do certain things safely in most SQL DBMSes, because it's the only way to make certain updates happen automatically *inside* the transaction.

SQLite also offers [commit hooks](https://sqlite.org/c3ref/commit_hook.html), which have much the same potential use cases, and more. Maybe that would serve the OP's needs, in fact.