Howdy, I need to monitor changes in an an sqlite3 file an application uses.
I make copies periodically, so I have 2 files shotwell_2011-07-21.db and shotwell_2011-07-22.db For example, I'm interested in PhotoTable, which had rows added, deleted and changed between those days. Figuring out additions seems straightforward, there is an 'id' column. I would like advice on ways to determine changes and deletions. I'm currently accessing the files via Python's sqlite3 library, though plan to start using SqlAlchemy. I expect I'm not the first to have interest in this, but have been unable to locate any discussion of it. Thanks, Kent _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
