Foreign Key constraint doesn't work with SQLite (Chapter 9)

dree39 · February 20, 2020, 4:32pm

Hi. I’m following the Acronyms tutorial from the book and everything’s great so far. I chose to use SQLite instead of PostgreSQL and I’m saving the database on file. The problem is that the foreign key constraint explained in chapter 9 is not working as expected: I can create an acronym (with a random UUID) even if there is no existing user.

0xtim · February 22, 2020, 6:03am

@dree39 by default SQLite doesn’t support foreign key constraints (or at least enforce them). You can enable it with databases.enableForeignKeys(on: .sqlite) in configure.swift.