Foreign keys are silently ignored, indeed it seems almost none of the data integrity you expect a database to provide is there with SQLite. Ditto for MySQL. The key words are "you expect a database to ...

When they need a relational database, software developers and system administrators often choose MySQL or PostgreSQL. For a lighter and simpler solution, however, developers should consider SQLite. It ...