Re: Capturing the changes in columns in a table
sub sk79 <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CA+gZn2mB2GB22XJ7v2v=pvTnqffDf=6zGRTN2ut0n0yX0_+xxQ@mail.gmail.com> |
> Yes, a dumb of a system is provided daily There are some great solutions already here for offline processing as stated in your question. However, something you might also want to consider (if you have requisite access to the system) is to use ‘after insert’ trigger(s) to online capture the change log into a table and dump that table along with other tables. This would be easiest and fastest solution while not needing any indexes to be added or queries to be optimized. - Neal > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users