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 values in existing records, my application needs to forward the complete set to an embedded system over a serial link. So the intermediate storage is mainly used to have a status-quo to compare against. 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-then-update overhead to detect the changes. The alternative is to just prepare it in the format that would be sent over the link, record that in a blob and check on changes on that single item. Losing the ability to easily query the data to check it manually. Ciao, MM _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
