Hi,
I understand SQLite3 will not be able to handle any IPC related operation.
I am attempting my idea below to handle IPC with the help of SQLite3
Trigger.
*Scenario:*
I have two processes. Process – A will be responsible to create trigger &
Process -B will doing operation like update, insert or delete. Once process
– B will do update, Insert or delete, process – A will get notification
automatically.
1) Process - A create trigger where it actually select a function in
trigger action.
CREATE TRIGGER TestTrigger AFTER INSERT ON TestTbl
BEGIN
SELECT Trigger_notifier_function();
END
Note: Process - A will register function using sqlite_create_function().Mostly
Trigger_notifier_function() is dummy here.
2) Process - B will also create same name function using
sqlite_create_function().This function have some logic to handle IPC.
3) Process – B will insert data in table.
*My question:*
1) Is process – B will allow to Insert?
2) If allowed then it will select notify function from process – B or
Process - A?
3) If all works then what risk I will carry? (Like deleting row,
deleting trigger will crate any issue?)
I assume answer will valid for other operation like update & delete
operation as well.
Thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
