Re: [sqlite] Detecting real updates

2009-10-22 Thread Simon Slavin
On 22 Oct 2009, at 3:51pm, Marian Aldenhoevel wrote: > Is there a way to have sqlite3 detect the actual changes after I did a > number of INSERT OR UPDATE statements? Using a trigger maybe? > > If so I could keep the intermediate storage nicely organized and still > not incur a lot of read-and-th

[sqlite] Detecting real updates

2009-10-22 Thread Marian Aldenhoevel
Hi, My application is downloading data from the internet, parses and transforms it and (currently) stores it in a sqlite3-database. The data parses out into a small variable number of records with just two fields each. Whenever that data changes, either the number of records or the actual val