Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Douglas E. Fajardo
users-boun...@sqlite.org] On Behalf Of Shaun Seckman (Firaxis) Sent: Thursday, October 01, 2009 8:10 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database Diff libs or applications I've been looking into using triggers to create a replay table. This seems to be pretty

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Simon Slavin
On 1 Oct 2009, at 4:10pm, Shaun Seckman (Firaxis) wrote: > I've been looking into using triggers to create a replay table. > This seems to be pretty restrictive in that it requires a trigger to > be created for each table and cannot track when tables are dropped > or created (documentation

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Pavel Ivanov
te-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Shaun Seckman (Firaxis) > Sent: Thursday, October 01, 2009 10:13 AM > To: punk...@eidesis.org; General Discussion of SQLite Database > Subject: Re: [sqlite] Database Diff libs or applications > > Are

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Shaun Seckman (Firaxis)
t: Re: [sqlite] Database Diff libs or applications Are there any limitations to this? Will this track any and all SQL actions done to the database or just table data changes? I'll hunt down the post now :) -Shaun -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Shaun Seckman (Firaxis)
ishor Sent: Thursday, October 01, 2009 10:03 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database Diff libs or applications On Thu, Oct 1, 2009 at 8:44 AM, Shaun Seckman (Firaxis) wrote: > Hello, > >                I'm looking to externally track the actions made

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Shaun Seckman (Firaxis)
opposed to the final database. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Adam DeVita Sent: Thursday, October 01, 2009 9:49 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database Diff libs or applica

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread P Kishor
On Thu, Oct 1, 2009 at 8:44 AM, Shaun Seckman (Firaxis) wrote: > Hello, > >                I'm looking to externally track the actions made to a > database so that I can apply those same actions to another database > (assuming the other database has a similar schema).   I've searched the > documen

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Adam DeVita
There has been a lot of discussion of this and several of us are doing it. Are you talking about A) DB1 which has modify data and DB2 which only receives modifications from DB1 only, or B) DB1 and DB2 both get updates independently and need to be synchronized? or C) something else Not (A or B

[sqlite] Database Diff libs or applications

2009-10-01 Thread Shaun Seckman (Firaxis)
Hello, I'm looking to externally track the actions made to a database so that I can apply those same actions to another database (assuming the other database has a similar schema). I've searched the documentation and there doesn't seem to be an easy way to extract this data so my