Changes between Version 162 and Version 163 of members/GRIP-UQAM


Ignore:
Timestamp:
Aug 22, 2016, 2:55:53 PM (5 years ago)
Author:
Grip Uqam
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • members/GRIP-UQAM

    v162 v163  
    177177== Web Applications ==
    178178* https://www.neos.io/
    179 * [wiki:members/GRIP-UQAM/Drupal Drupal]
     179* **[wiki:members/GRIP-UQAM/Drupal Drupal]**
    180180== Useful Debian Packages (Chelsea) ==
    181181* [DebianPackage:apache2-mpm-worker](debian 8 jessie [DebianPackage:apache2] which uses mpm_event by default)
     
    212212* Microformat [https://en.wikipedia.org/wiki/Microformat Wikipedia]
    213213 * hRecipe [https://en.wikipedia.org/wiki/HRecipe Wikipedia]
    214 == SQL Database Programming ==
    215 === Design Principles ===
    216 * http://it.toolbox.com/blogs/database-soup/wrecking-your-database-33298
    217 * https://www.percona.com/blog/2009/03/01/kiss-kiss-kiss/
    218 * Book: https://pragprog.com/book/bksqla/sql-antipatterns
    219 * //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]
    220  * Review [http://shop.oreilly.com/product/9781934356555.do O'Reilly]
    221 * //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]
    222 === Tree or Hierarchical Data ===
    223 * nested-set, closure-table and materialized-path.
    224 * //Tree_(data_structure)// [https://en.wikipedia.org/wiki/Tree_(data_structure) Wikipedia]
    225 * 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)]
    226 * //SQL - How to store and navigate hierarchies?// [https://stackoverflow.com/questions/38801/sql-how-to-store-and-navigate-hierarchies stackoverflow]
    227 * //How to represent a data tree in SQL?// [https://stackoverflow.com/questions/2175882/how-to-represent-a-data-tree-in-sql stackoverflow]
    228 * //Models for hierarchical data// [http://www.slideshare.net/billkarwin/models-for-hierarchical-data SlideShare]
    229 * //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)
    230 * //Closure Table – Store Hierarchical Data Seamlessly | PostgreSQL// [http://technobytz.com/closure_table_store_hierarchical_data.html technobytz] (short HOWTO)
    231 * //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]
    232 * //Storing hierarchical data: Materialized Path// [https://bojanz.wordpress.com/2014/04/25/storing-hierarchical-data-materialized-path/ Blog]
    233 === Blobs for documents ===
    234 * FAQ: http://stackoverflow.com/questions/211895/storing-documents-as-blobs-in-a-database-any-disadvantages
    235 === Serialized Objects ===
    236 * https://www.percona.com/blog/2010/01/21/when-should-you-store-serialized-objects-in-the-database
    237 == SQL ==
    238 * https://en.wikibooks.org/wiki/Structured_Query_Language/Introduction_to_SQL
    239 * https://en.wikipedia.org/wiki/SQL
    240 ==== Views ====
    241 * http://www.postgresql.org/docs/current/static/sql-createview.html
    242 * http://www.doctrine-project.org/2009/06/19/using-views-with-doctrine.html (is it always valid?)
    243 * http://www.postgresql.org/docs/current/static/rules-materializedviews.html
    244 ==== sql procedural language ====
    245 * https://en.wikipedia.org/wiki/SQL#Procedural_extensions
    246 * https://en.wikipedia.org/wiki/SQL/PSM
    247 * https://en.wikipedia.org/wiki/Stored_procedure
    248 ==== Supported features ====
    249 ===== Data Types =====
    250 ====== json ======
    251 * SQLite https://www.sqlite.org/json1.html
    252 ====== XML ======
    253 * Seems not yet to be in Firebird
    254 === Embedded Database Programming ===
    255 * https://en.wikipedia.org/wiki/Embedded_database
    256  * QDBM, BDB, http://php.net/manual/en/function.dba-handlers.php
    257  * [DebianPackage:php-tokyo-tyrant]​
    258  * [DebianPackage:php7.0-interbase] (php driver does not include embeded version of interbase) [DebianPackage:libfbembed2.5]
    259   * https://wiki.documentfoundation.org/Development/Base/FirebirdSQL
    260   * https://en.wikipedia.org/wiki/InterBase
    261   * https://en.wikipedia.org/wiki/Firebird_%28database_server%29
    262  * http://www.haildb.com/
    263  * [DebianPackage:php5-midgard2]​
    264 === sqlite ===
    265 * [https://www.sqlite.org/omitted.html SQL Features That SQLite Does Not Implement]
    266 * https://www.sqlite.org/json1.html
    267 * https://www.sqlite.org/fts5.html
    268 * [https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=816463 Please enable FTS5 support] https://tracker.debian.org/media/packages/s/sqlite3/rules-3.11.0-3
    269 === HSQLDB (Hyper SQL Database) ===
    270 * https://en.wikipedia.org/wiki/HSQLDB
    271 === Postgres ===
    272 * https://wiki.debian.org/PostgreSql
    273 * http://db.cs.berkeley.edu/papers/ERL-M85-95.pdf
    274 * http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.133.8073&rep=rep1&type=pdf
    275 * https://dl.acm.org/citation.cfm?id=2834495
    276 ==== Performance ====
    277 * http://fr.slideshare.net/pgconf/five-steps-perform2009
    278 ==== Timing ====
    279 * [http://www.postgresql.org/message-id/4D9EABDD.1060102@limsi.fr Re: What does \timing measure?]
    280 * http://www.postgresql.org/docs/9.4/static/runtime-config-statistics.html
    281 * http://stackoverflow.com/questions/17653884/postgres-query-execution-time
    282 * http://stackoverflow.com/questions/9063402/get-execution-time-of-postgresql-query
    283 ==== Procedural Language ====
    284 * https://wiki.postgresql.org/wiki/PL_Matrix
    285 * PL/pgSQL
    286  * Included in postgresql~ basic Debian Package
    287  * http://www.postgresql.org/docs/9.3/static/plpgsql.html
    288  * https://en.wikipedia.org/wiki/PL/pgSQL
    289   * http://postgres.cz/wiki/PL/pgSQL_(en)
    290 * [DebianPackage:postgresql-plpython-9.4] more stable and more popular that PL/Lua
    291 * [DebianPackage:postgresql-plpython3-9.4]
    292 * [DebianPackage:postgresql-9.4-pllua] https://github.com/pllua/pllua http://wiki.alpinelinux.org/wiki/Pllua
    293 * [DebianPackage:postgresql-pltcl-9.4]
    294 * [DebianPackage:postgresql-9.4-plsh]
    295 ==== General information and Feature Lists ====
    296 * [https://www.safaribooksonline.com/library/view/postgresql-up-and/9781449373184/ch01.html PostgreSQL: Up and Running]
    297 * [https://www.compose.io/articles/what-postgresql-has-over-other-open-source-sql-databases Advertisement by a provider]
    298 ===== Release Notes and Documentation =====
    299 * [http://www.postgresql.org/about/news/1415/ PostgreSQL 9.2 released]
    300 === MySQL ===
    301 * https://en.wikipedia.org/wiki/MySQL
    302 ==== Stored Procedure ====
    303 * MySQL stored procedure programming
    304  * http://www.worldcat.org/oclc/70161318
    305  * http://www.worldcat.org/oclc/850445083
    306 * MySQL Cookbook
    307  * http://www.worldcat.org/oclc/76905222
    308 === Firebird ===
    309 * https://wiki.documentfoundation.org/Development/Base/FirebirdSQL
    310 * http://stackoverflow.com/questions/1635273/postgres-vs-firebird
    311214== Java Programming ==
    312215* https://packages.debian.org/fr/libunixsocket
     
    322225== [wiki:members/GRIP-UQAM/Doctrine_(PHP) Doctrine_(PHP)] ==
    323226== [wiki:members/GRIP-UQAM/Symfony Symfony Programming] ==
     227== [wiki:members/GRIP-UQAM/SQL SQL Database Programming] ==