Apparently sqlite does not enforce foreign key integrity by default! That's incentive to use something else even for prototypes/small apps. https://stackoverflow.com/q/15301643/509706 https://twitter.com/_wilfredh/status/1195783852427481088