| 394 | == DBAL == |
| 395 | * Has a weakness preventing to use foreign key constraints in Sqlite (a recent improvement of Sqlite), (at least in version 2.5.6 - 2.5.7). |
| 396 | * //[https://www.sqlite.org/foreignkeys.html SQLite Foreign Key Support]// |
| 397 | * Solutions are been considered! |
| 398 | * Once it will be working, Debian version still will have to wait for update. [DebianPackage:php-doctrine-dbal] |
| 399 | * While waiting to something integrated into Dbal, the following code can be executed just after connection: |
| 400 | {{{#!php |
| 401 | $pdo->exec("PRAGMA foreign_keys = ON;"); |
| 402 | }}} |
| 403 | * This can be done in a PostConnect event |
| 404 | * [https://github.com/doctrine/dbal/issues/2531 Sqlite: Add option to support PRAGMA for all connections] |
| 405 | * [http://docs.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/events.html 11. Events] |
| 406 | * [https://stackoverflow.com/questions/12585507/symfony2-doctrine-postconnect-event-never-triggered symfony2 doctrine postConnect event never triggered] |
| 407 | * [http://symfony.com/doc/current/doctrine/event_listeners_subscribers.html How to Register Event Listeners and Subscribers] [Specific to Doctrine] |
| 408 | |
| 409 | * //[https://www.thedevfiles.com/2014/08/simplifying-database-interactions-with-doctrine-dbal/ Simplifying database interactions with Doctrine DBAL]// 2014 |
| 410 | |
| 411 | * Has its own event manager (version 2.5.7) |