Enable SQLite foreign key on post-connect

[Ocramius]

Apparently, SQLite has supported foreign keys for ages! All we need to do is (according to https://sqlite.org/foreignkeys.html) run a statement on post-connect:

PRAGMA foreign_keys = ON;

Not sure where to do it exactly, but this would be a very welcome addition.

[Federkun]

Not sure where to do it exactly

I've an event subscriber to enable that: would you suggest to add an SqliteSessionInit.php?

[Ocramius]

@Federkun yup 👍

[drhsqlite]

SQLite has a compile-time option to enable foreign_key enforcement by default. https://www.sqlite.org/compile.html#default_foreign_keys

The default build of SQLite has foreign_key enforcement turned off by default due to backwards-compatibility concerns.

[Ocramius]

Compile-time is not in our ballpark: we are a lib sitting on top of pre-compiled php binaries.

…

On 12 Sep 2017 22:20, "Richard Hipp" ***@***.***> wrote: SQLite has a compile-time option to enable foreign_key enforcement by default. https://www.sqlite.org/compile.html#default_foreign_keys The default build of SQLite has foreign_key enforcement turned off by default due to backwards-compatibility concerns. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#2833 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAJakA5GiHKvU9pCW5X7ALDDPJMat7uEks5shueAgaJpZM4PK8b7> .

[DontShootMe]

Hello,
Just a little up about this functionality.

Have you found any good approach, because foreign keys are missing for ages ?

Many thanks all, for all your work
You are all amazing

[alexander-schranz]

I did stumble over #5404 and asking myself if FK is now supported via dbal?

[derrabus]

Yes. I think, we can close this issue.

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.