SQLite parses and stores foreign key constraints, but does not enforce them. The
simple solution of this problem is creating insert,update and delete triggers which
mimic the enforcing behaviour of other RDBMS. sqlitefktg does just that - automatically.
Features
- automatic generation of foreign key enforcing triggers based on the data fetched from the database,
- may be used as a command-line tool, as well as inside your own application,
- 2-phase detection/generation process allows the advanced user to customize the end result.
More information here <http://coobs.eu.org/sqlitefktg/>
_