Andy Bennett wrote: >> foreign key constraints > > my experience with other engines taught me that it makes experimenting at the > monitor harder.
Then don't use them. :) But do you actually want 'wrong' data? > Are there any efficiency benefits or is it just there to enforce data > integrity? Constraints just are additional checks. (FKs require certain indexes, but you would want to have those anyway.) > It looks like they have to be enabled on a per connection basis. In this case > I (currently) > control all the client code but is it possible for the foreign key > relationships to get out > of sync if one of the connections omits to apply the pragma? Yes. You could run PRAGMA foreign_key_check afterwards. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
