Should I use triggers in sqlite?

Question

SQLite

Should I use triggers or move the logic to the application side?

Answer 1

Since sqlite is an embedded DBMS, I don't see much point in using triggers in it. Unless you have denormalized data and want to keep it consistent with triggers, then that's an option. And for other cases, triggers are not particularly welcome in large DBMSs.