Changes between Version 2 and Version 3 of members/GRIP-UQAM/PHP/Packages


Ignore:
Timestamp:
Jan 15, 2017, 12:34:10 PM (5 years ago)
Author:
Grip Uqam
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • members/GRIP-UQAM/PHP/Packages

    v2 v3  
    392392* [https://packagist.org/packages/doctrine/dbal doctrine/dbal]
    393393* [https://packagist.org/packages/aura/sql aura/sql]
     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)
    394412= Static site generator =
    395413* [https://packagist.org/packages/spress/spress spress/spress]