Re: [sqlite] Track DML (from certain clients only)

2011-09-02 Thread Tim Streater
On 02 Sep 2011 at 16:58, Stephan Beal wrote: > On Fri, Sep 2, 2011 at 5:32 PM, Frans Knibbe wrote: > >> If SQLite could log this statement including the comment, it would still be >> possible to distinguish sources. Or reject the logging of

Re: [sqlite] Track DML (from certain clients only)

2011-09-02 Thread Stephan Beal
On Fri, Sep 2, 2011 at 5:32 PM, Frans Knibbe wrote: > If SQLite could log this statement including the comment, it would still be > possible to distinguish sources. Or reject the logging of statement with a > trigger similar to the one you proposed.. > Why not just write

Re: [sqlite] Track DML (from certain clients only)

2011-09-02 Thread Black, Michael (IS)
] on behalf of Frans Knibbe [frans.kni...@geodan.nl] Sent: Friday, September 02, 2011 10:32 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Track DML (from certain clients only) Hello Michael, I am sorry for being unclear, I will try to explain: What would work is each application writing

Re: [sqlite] Track DML (from certain clients only)

2011-09-02 Thread Frans Knibbe
, September 02, 2011 9:16 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Track DML (from certain clients only) Hello Michael, Thanks for the quick response. Yes, I could add a field to put the source string in. But I would not like to bother applications with having to inse

Re: [sqlite] Track DML (from certain clients only)

2011-09-02 Thread Black, Michael (IS)
, 2011 9:16 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Track DML (from certain clients only) Hello Michael, Thanks for the quick response. Yes, I could add a field to put the source string in. But I would not like to bother applications with having to insert rows

Re: [sqlite] Track DML (from certain clients only)

2011-09-02 Thread Frans Knibbe
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Frans Knibbe [frans.kni...@geodan.nl] Sent: Friday, September 02, 2011 4:21 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Track DML (from certain clients only) Hello all, I am trying to use SQLite as

Re: [sqlite] Track DML (from certain clients only)

2011-09-02 Thread Black, Michael (IS)
e-users-boun...@sqlite.org] on behalf of Frans Knibbe [frans.kni...@geodan.nl] Sent: Friday, September 02, 2011 4:21 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Track DML (from certain clients only) Hello all, I am trying to use SQLite as a data store for a P2P (peer to peer) system.

[sqlite] Track DML (from certain clients only)

2011-09-02 Thread Frans Knibbe
Hello all, I am trying to use SQLite as a data store for a P2P (peer to peer) system. There could be several applications reading from and writing to the database. One of these is the P2P module. It reads local additions to the database (only INSERTs are allowed, rows are never DELETEd or