02:30 |
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 |
| |
~ 10 hours 24 minutes ~ |
12:55 |
signpost |
iirc gotta tell sqlite to enforce 'em. |
12:55 |
signpost |
yep, PRAGMA foreign_keys = ON; looks like |
12:55 |
* |
signpost doesn't know how often sqlite is compiled with that support enabled. |
12:58 |
signpost |
probably would've prevented that key duplication b00g |
12:58 |
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 |
12:58 |
signpost |
ossum |
12:59 |
signpost |
http://paste.deedbot.org/?id=FVzh |
13:04 |
cgra |
right |
| |
~ 1 hours 14 minutes ~ |
14:19 |
awt |
cgra: foreign key constraints would be great.? |