On 6 Mar 2012, at 1:34pm, Larry Knibb <larry.kn...@gmail.com> wrote:
> I wouldn't initially need to support schema changes, just data > changes. And actually only data additions (INSERTs) as the first use > case. So diffing the .dumps would probably suffice. But later, I'd > want to handle UPDATE and DELETE. If you have consistent primary keys, or a way of extracting primary keys from each of your tables, then I think INSERT UPDATE and DELETE would be doable. Unless you have to worry about either FOREIGN KEY support or TRIGGERs. Then you have a situation where you either have to disable them while you're making your changes, or do some sort of dataflow analysis to figure out what order to put things in. That's tricky. I don't think I've ever seen it discussed before. But I'm not a huge expert on databases. It's a neat idea. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
