Enable Foreign Keys in a SQLite Database

The Problem

As is ¤well documented, SQLite does not support foreign key constraints. So Theory did some research on how to add foreign key constraint functionality to SQLite databases.

The Solution

(There is an ¤online tool which automatically generates the triggers proposed below based on the input CREATE TABLE statement.)