Changes between Version 119 and Version 120 of members/GRIP-UQAM

Timestamp:

May 4, 2016, 1:45:10 PM (9 years ago)

Author:

Grip Uqam

Comment:

--

members/GRIP-UQAM

@@ -936 +936 @@
 * https://www.percona.com/blog/2009/03/01/kiss-kiss-kiss/
 * Book: https://pragprog.com/book/bksqla/sql-antipatterns
-* Book: //SQL design patterns : the expert guide to SQL programming// [http://www.worldcat.org/title/sql-design-patterns-the-expert-guide-to-sql-programming/oclc/86074635 WorldCat]
+* //SQL antipatterns : avoiding the pitfalls of database programming// [http://www.worldcat.org/title/sql-antipatterns-avoiding-the-pitfalls-of-database-programming/oclc/886727368 WorldCat][https://pragprog.com/book/bksqla/sql-antipatterns The Pragmatic Bookshelf]
+ * Review [http://shop.oreilly.com/product/9781934356555.do O'Reilly]
+* //SQL design patterns : the expert guide to SQL programming// [http://www.worldcat.org/title/sql-design-patterns-the-expert-guide-to-sql-programming/oclc/86074635 WorldCat] [http://www.rampant-books.com/book_0601_sql_coding_styles.htm Rampant]
 === Tree or Hierarchical Data ===
+* nested-set, closure-table and materialized-path.
 * //Tree_(data_structure)// [https://en.wikipedia.org/wiki/Tree_(data_structure) Wikipedia]
 * Joe Celkos: //Trees and Hierarchies in SQL for Smarties// [http://www.worldcat.org/title/joe-celkos-trees-and-hierarchies-in-sql-for-smarties/oclc/795963625 WorldCat] [http://aleph.unisg.ch/hsgscan/hm00391779.pdf Table of Content (pdf)]
@@ -944 +947 @@
 * //Models for hierarchical data// [http://www.slideshare.net/billkarwin/models-for-hierarchical-data SlideShare]
 * //How to represent a tree structure numerically in SQL Server// [https://yellowpencil.com/blog/how-to-represent-a-tree-structure-numerically-in-sql-server/ yellowpencil] (short HOWTO)
-* [http://technobytz.com/closure_table_store_hierarchical_data.html closure_table_store_hierarchical_data.html]
-* FAQ: [https://stackoverflow.com/questions/192220/what-is-the-most-efficient-elegant-way-to-parse-a-flat-table-into-a-tree what-is-the-most-efficient-elegant-way-to-parse-a-flat-table-into-a-tree]
+* //Closure Table – Store Hierarchical Data Seamlessly | PostgreSQL// [http://technobytz.com/closure_table_store_hierarchical_data.html technobytz] (short HOWTO)
+* //What is the most efficient/elegant way to parse a flat table into a tree?// [https://stackoverflow.com/questions/192220/what-is-the-most-efficient-elegant-way-to-parse-a-flat-table-into-a-tree stackoverflow]
+* //Storing hierarchical data: Materialized Path// [https://bojanz.wordpress.com/2014/04/25/storing-hierarchical-data-materialized-path/ Blog]
 === Blobs for documents ===
 * FAQ: http://stackoverflow.com/questions/211895/storing-documents-as-blobs-in-a-database-any-disadvantages
@@ -1119 +1123 @@
 * doctrine/doctrine-bundle [https://symfony.com/doc/current/book/doctrine.html DoctrineBundle] - Adds support for the Doctrine ORM
  * doctrine/orm has to be required if needed
+ * Extensions:
+  * https://symfony.com/doc/master/bundles/StofDoctrineExtensionsBundle/index.html
+   * http://symfony.com/doc/current/cookbook/doctrine/common_extensions.html
+   * https://packagist.org/packages/stof/doctrine-extensions-bundle
+  * KNP
 * TwigBundle - Adds support for the Twig templating engine
 * symfony/security-bundle SecurityBundle - Adds security by integrating Symfony's security component