Sqlite

[stefnotch]

Sqlite has a lot of questionable decisions, due to legacy reasons. One always has to make sure to enable all the strict stuff and whatnot to get a sane database.

Foreign key constraints are disabled by default (for backwards compatibility), so must be enabled separately for each database connection
https://www.sqlite.org/foreignkeys.html

• https://www.sqlite.org/stricttables.html
• https://www.sqlite.org/quirks.html