Re: Capturing the changes in columns in a table

sub sk79, on Tuesday, January 14, 2020 10:54 AM, wrote...
>
> > 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.
That is an idea I have not thought about, Neal.  Thanks.  The boss comes up with lots of requests, and these have to be done yesterday. I will have to look into triggers. Have not used them yet. :-(

josé
<http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users