Best way to get rows changed in an sqlite db -


i'm watching sqlite db app uses.

i want know changes have been made since last checked.

i can dump sql , diff against last dump, seems there should better way.

is there?

thanks, kent

ps not coy, specifics: i'm managing photos shotwell, has great gui. i'm mirroring shotwell's db in postgresql, i've restructured , augmented liking. after shotwell session, involves adding, tagging, adjusting ... want apply changes postgres.

add field named _changed table(s). on every manipulation (update, insert into...) of row set field current timestamp. can check rows have been updated since.


Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -