4 ms·
> Not a solid guarantee How so? Are you saying that sqlite would ignore the connection string?
by angra_mainyu 3y ago
> Not a solid guarantee
How so? Are you saying that sqlite would ignore the connection string?
- progmetaldev 3y agoAn older version that doesn't support the feature will probably just ignore the addition to the connection string.
- progmetaldev 3y agohttps://sqlite.org/foreignkeys.html#fk_enable https://sqlite.org/foreignkeys.html#fk_enable Judging by the documentation, if you issue a PRAGMA foreign_keys; and no row is returned containing a 0 or 1, then you are using an unsupported version of SQLite, or the library was compiled with foreign key support disabled. I am struggling to find any documentation that states if anything will occur if enabling foreign keys in the connection string, when the version does not support foreign keys.
- graemep 3y agoI mean it is too easy to get wrong through human error or buggy application code.