On Apr 17, 2012, at 12:51 AM, Simon Slavin wrote: > Now, consider what it takes if you're logging value changes instead of > commands issued. Your first problem is figuring out which rows exist.
Why? Each row is time boxed. There is no ambiguities about what exists when. > Are you storing triplets, or complete rows ? Let's assume complete rows for simplicity's sake. > What SELECTs are you going to do ? As mentioned: select * from foo join bar on bar.bar_key = foo.bar_key where foo.foo_key = 1 and julianday( ... ) between foo.valid_from and foo.valid_to and julianday( ... ) between bar.valid_from and bar.valid_to _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
