It's mostly context A but sometimes context B :) Here's a better description of what will happen..
I start out with database A. This database is mostly constant. User Bob opens database A in a custom editor and performs changes and tweaks to the database. Bob then saves out his changes either in the form of some separate transaction file. User Joe opens database A in the same editor and performs different changes to the database and saves them out to a separate file as well. The third user Adam then loads up database A in another application, applies the changes from Bob, applies the changes from Joe, and then performs read-only operations from that point on. When a user has the database open in the editor to make changes, Database A can be considered constant and read-only. I needn't worry about maintaining a constant connection as the file will only ever be updated outside the use of that editor. The final order in which to apply changes needs to be flexible and at the user's discretion (this will result in a different final output but that is expected). I'm assuming I'll need a custom editor in order to load/save incremental changes as 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 applications 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) Your context implies what automated or custom solution you would use. On Thu, Oct 1, 2009 at 9:44 AM, Shaun Seckman (Firaxis) < shaun.seck...@firaxis.com> 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 > documentation and there doesn't seem to be an easy way to extract this > data so my only option seems to be utilizing some sort of library or > application to diff the two databases and generate a SQL script based on > the changes. > > > > Has anyone done this before? Does such a library or application exist? > I'm sure I could write my own if needed. > > > > -Shaun > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
