3 ms·
SQLite has foreign keys, but they are disabled by default for backwards-compatibility reasons. https://sqlite.org/foreignkeys.html https://sqlite.org/foreignkey
by joppy 6y ago
SQLite has foreign keys, but they are disabled by default for backwards-compatibility reasons. https://sqlite.org/foreignkeys.html https://sqlite.org/foreignkeys.html
- gralx 6y agoAnd it's not possible to enable them by default - there is no existing configuration setting to override that design choice. They hope to include the feature in SQLite4, as I understand it.
- ComputerGuru 6y agoSQLite 4 was killed off in favor of just bringing a few changes to SQLite 3 iteratively. https://www.sqlite.org/src4/doc/trunk/www/index.wiki https://www.sqlite.org/src4/doc/trunk/www/index.wiki