SQLite triggers and events in other processes

Question

I'm new to triggers, so apologize if this is a stupid question.

Is it possible for a trigger (or some other database engine) to trigger an event in another process. For example, I need the application to become familiar with certain activities (updating in a specific table with specific data), but I would prefer that this process does not check the database. Does anyone know if it is possible to trigger a trigger (or maybe a stored procedure) to create an event or other asynchronous notification mechanism in another process?

[NOTE: the recipient application is written in C # and the database is sqlite]

Answer 1

Yes, write a trigger that fires according to your criteria and calls the external function that you defined. I forgot that SQLite calls custom external functions, but they are.

Answer 2

This is possible with some DBMSs, but not with SQLite. SQLite support for triggers VERY basic ...

EDIT: this is actually possible, but the actual notification will be made by your program, not SQLite itself. You can define a function in C # that you would map to a SQLite function, and call that function in a trigger.