Re: [sqlite] Inter Process Communincation using SQLite3 Trigger

2013-11-01 Thread techi eth
Thanks for answer. I am in sync with your answer. I believe their is no risk from SQLite3 point of view to handle the mentioned case. On Fri, Nov 1, 2013 at 6:47 PM, Igor Tandetnik wrote: > On 11/1/2013 5:58 AM, techi eth wrote: > >> 1) Is process – B will allow to

Re: [sqlite] Inter Process Communincation using SQLite3 Trigger

2013-11-01 Thread Igor Tandetnik
On 11/1/2013 5:58 AM, techi eth wrote: 1) Is process – B will allow to Insert? Sure, why not. 2) If allowed then it will select notify function from process – B or Process - A? The custom function will be called in process B - the process doing the insertion. 3) If all

[sqlite] Inter Process Communincation using SQLite3 Trigger

2013-11-01 Thread techi eth
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,