cgra: just realized sqlite appears to support foreign key constraints. unaware of any serious downsides, i intend to employ them in a blatta patch. perceived upsides being 1) better self-documenting code, 2) less chance of bug-trashed db, 3) increased bug visibility
signpost[asciilifeform]: iirc gotta tell sqlite to enforce 'em.
signpost[asciilifeform]: yep, PRAGMA foreign_keys = ON; looks like
signpost[asciilifeform] doesn't know how often sqlite is compiled with that support enabled.
signpost[cgra]: probably would've prevented that key duplication b00g
cgra: signpost, yea, got on todo-list to see whether can runtime-check somehow if compiled with fk constraint support, and warn user if not
signpost[cgra]: ossum
cgra: right
awt[cgra|asciilifeform]: cgra: foreign key constraints would be great.?