[[TranslatedPages]]
== Who we are? ==
http://gripuqam.org
We are french speaking so this page will be translated unsing the advise in [wiki:/faq/translate/pages]
== Wiki page we read or collaborate to write @ mayfirst ==
* [wiki:/faq/translate/pages]
* Formatting List of References
 * Title in italic
 * References
  * http://library.concordia.ca/help/citing/
  * http://library.concordia.ca/help/citing/apa.php
  * http://library.concordia.ca/help/citing/mla.php
  * http://www.chicagomanualofstyle.org/tools_citationguide.html
* Types of documents
 * Book
 * README
 * FAQ [https://en.wikipedia.org/wiki/FAQ Wikipedia]
 * HOWTO [https://en.wikipedia.org/wiki/How-to#Usage_in_the_world_of_computers Wikipedia]
 * Recipe [https://en.wikipedia.org/wiki/Recipe Wikipedia]
 * Guide [https://en.wikipedia.org/wiki/Guide Wikipedia]
* WikiFormatting
  * http://trac.edgewall.org/wiki/TracSyntaxColoring
    * Trac Syntax Coloring Example
{{{
{{{#!sh
}}}
{{{#!application/x-shellscript
}}}
}}}
{{{#!sh
path$ echo "World" ; ls ; cd ; help # comment
}}}
{{{#!comment
{{{#!application/x-shellscript
path$ echo "World" ; ls ; cd ; help # comment
}}}
}}}
{{{
{{{#!json
}}}
{{{#!application/json
}}}
}}}
{{{#!json
{
  "name": "drupal7", # comment forbidden in json
  "private": true // no coma here!
}
}}}
{{{#!comment
{{{#!application/json
{
  "name": "drupal7", # comment forbidden in json
  "private": true # no coma here!
}
}}}
}}}
    * #!diff
    * #!yml
    * #!text/x-yaml
    * #!application/x-yaml
    * #!xml
    * #!application/xml-dtd ...
    * #!html //Insert custom HTML in a wiki page.//
    * #!text/html //The result will be syntax highlighted HTML code//
    * #!text/html+twig
    * #!application/x-twig
    * #!application/x-httpd-php5	
    * #!python
    * #!php
    * #!text/x-php
    * #!text/css
    * #!js
    * #!text/javascript ...
    * **#!sql**
    * #!text/x-sql
    * #!text/x-sqlite3-console
    * #!text/x-postgresql-psql ...
    * #!text/x-mysql
    * #!text/x-diff
    * #!text/x-trac-wiki
    * #!application/x-sh-session **No macro or processor named 'application/x-sh-session' found**
* [wiki:TracQuery#UsingtheTicketQueryMacro TicketQuery Macro] (tagging tickets) examples:
  * [wiki:tzk:choices]
  * [wiki:support-team/dkg]
  * https://support.mayfirst.org/tags
  * http://trac.edgewall.org/wiki/TicketQuery
  * http://trac.edgewall.org/wiki/TracQuery
* There is somewhere a useful cloud of tags. [wiki:/faq/wordpress/WordPressInstall]
* Tag for Debian packages `[DebianPackage:python-whoosh]`[DebianPackage:python-whoosh]
== Tickets we follow ==
=== Taged with GRIP-UQAM ===
[[TicketQuery(max=10,keywords~=GRIP-UQAM,order=changetime,desc=1,format=table,col=changetime|resolution|owner|summary)]]
=== Taged with python, tendenci, django, pyramid, php, drupal7, drupal, golang, fastcgi, chelsea, ossie ===
[[TicketQuery(max=10,keywords~=python|tendenci|django|pyramid|php|drupal7|drupal|golang|fastcgi|chelsea.mayfirst.org|ossie.mayfirst.org,order=changetime,desc=1,format=table,col=changetime|resolution|owner|summary)]]
=== Reported by us ===
[[TicketQuery(reporter=https://id.mayfirst.org/gripuqam|https://id.mayfirst.org/gripuqamweb|https://id.mayfirst.org/essais)]]
=== Taged with GRIP-UQAM with description ===
[[TicketQuery(max=1,keywords~=GRIP-UQAM,format=table,col=changetime|resolution|owner|summary,rows=description)]]
== Development Tool ==
* [wiki:/faq/setup-development-workstation]
* [wiki:/setup_virtual_machine]
== Pages we may need one day ==
* [wiki:apachesolr]
* [wiki:faq/drupal/update-module]
* [wiki:create_mysql_database]
* [wiki:phpmyadmin_link]
* [wiki:support-team]
== Communication softwares ==
* https://tryit.jssip.net/
* https://live.mayfirst.org/
== WebDAV ==
* https://en.wikipedia.org/wiki/WebDAV
* https://en.wikipedia.org/wiki/SabreDAV
=== Symbolic links ===
* keyword: symbolic link web dav
=== Backup ===
* https://support.mayfirst.org/wiki/faq/member-backup
=== DNS ===
* 
{{{#!sh
$ dig @ns3.example.org +short www.example.org
}}}
== Cron ==
* Consider output to an (even empty) file a good practice allowing to check last time the command has been executed. This is because some subtle errors may prevent execution of cron commands, eg. see #11534
{{{#!sh
... &> cron/results/<file>
}}}
* Consider nice and ionice to give priority to interactive tasks
{{{#!sh
nice -n 127 ionice --class=idle ...
}}}
== Email ==
* https://support.mayfirst.org/wiki/faq/email/configure-email
* https://support.mayfirst.org/wiki/bulk-mail-relay
* https://support.mayfirst.org/wiki/email-deliverability
== [wiki:members/GRIP-UQAM/Postgres Postgres] ==
== MongoDB ==
* #11321
== Database Clients ==
* https://en.wikipedia.org/wiki/Comparison_of_database_tools
* [DebianPackage:pgadmin3]
* [DebianPackage:phpmyadmin]
 * http://www.sitepoint.com/phpmyadmin-alternatives/
* [DebianPackage:adminer]
 * https://packagist.org/packages/vrana/adminer
 * https://www.adminer.org/
 * https://github.com/vrana/adminer/blob/master/plugins/login-table.php
 * http://php.vrana.cz/architecture-of-adminer.php
 * http://www.sitepoint.com/nette-framework-first-impressions/
 * https://www.drupal.org/project/adminer (Check if bug with version 4 has been resolved!)
 * [https://www.leaseweb.com/labs/2014/04/10-developer-tools-install-ubuntu-14-04/ Install Adminer 4 in Apache]
* squirrel+sql+site:debian.org
 * 3.3.3 does not work on debian 8
 * https://en.wikipedia.org/wiki/SQuirreL_SQL_Client
 * http://squirrel-sql.sourceforge.net
* DBEdit+site:debian.org
* phpLiteAdmin+site:debian.org
 * https://en.wikipedia.org/wiki/PhpLiteAdmin
== Git ==
* Branches and tags
 * keyword: how to find the tag of a git
 * https://git-scm.com/book/en/v2/Git-Basics-Tagging
* http://stackoverflow.com/questions/978052/how-can-i-make-my-local-repository-available-for-git-pull
* http://www.git-tower.com/blog/git-cheat-sheet
== Json ==
=== .json validator ===
* keyword: linux json validator
* keyword: json validator site:debian.org
 * jsonlint
  * [DebianPackage:jsonlint]
  * {{{composer require seld/jsonlint}}}
  * https://packagist.org/packages/seld/jsonlint
 * [DebianPackage:python-json-schema-validator]
== [wiki:members/GRIP-UQAM/Bower Javascript packages: Bower] ==
== [wiki:members/GRIP-UQAM/Composer Composer] ==
== Web Applications ==
* https://www.neos.io/
* [wiki:members/GRIP-UQAM/Drupal Drupal]
== Useful Debian Packages (Chelsea) ==
* [DebianPackage:apache2-mpm-worker](debian 8 jessie [DebianPackage:apache2] which uses mpm_event by default)
 * http://httpd.apache.org/docs/2.4/
 * http://httpd.apache.org/docs/2.4/mpm.html
 * http://httpd.apache.org/docs/2.4/mod/event.html
 * http://httpd.apache.org/docs/2.4/mod/worker.html
* [DebianPackage:apache2-suexec-custom] (also debian 8 jessie [DebianPackage:apache2-suexec-pristine] or debian 7 wheezy [DebianPackage:apache2-suexec])
* [DebianPackage:libapache2-mod-fcgid]
* [DebianPackage:php5-cgi]
* since february 2016 MayFirst uses mod_proxy_fcgi + php5-fpm
== Note Altern-C ==
* Altern-C seems to use [DebianPackage:libapache2-mpm-itk](debian 7 wheezy [DebianPackage:apache2-mpm-itk])
== To keep in mind ==
[ticket:4875]
[query:id=4875]
[[TicketQuery(id=4875)]]
[[TicketQuery(id=5580)]]
[[TicketQuery(id=5605)]]
[[TicketQuery(id=6287)]]
* http://servers.mayfirst.org/
== drupal.org followup ==
* https://localize.drupal.org/comment/51445#comment-51445
== JavaScript Libraries ==
http://www.sitepoint.com/11-best-jquery-charting-libraries
== [wiki:members/GRIP-UQAM/PHP PHP Libraries] ==
== HTML Slides ==
* https://packagist.org/packages/seld/slippy
== Radical Servers ==
* https://help.riseup.net/en/security/resources/radical-servers
== Fonts ==
* [DebianPackage:fonts-font-awesome]
== HTML Programming ==
* Microformat [https://en.wikipedia.org/wiki/Microformat Wikipedia]
 * hRecipe [https://en.wikipedia.org/wiki/HRecipe Wikipedia]
== SQL Database Programming ==
=== Design Principles ===
* http://it.toolbox.com/blogs/database-soup/wrecking-your-database-33298
* https://www.percona.com/blog/2009/03/01/kiss-kiss-kiss/
* Book: https://pragprog.com/book/bksqla/sql-antipatterns
* //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)]
* //SQL - How to store and navigate hierarchies?// [https://stackoverflow.com/questions/38801/sql-how-to-store-and-navigate-hierarchies stackoverflow]
* //How to represent a data tree in SQL?// [https://stackoverflow.com/questions/2175882/how-to-represent-a-data-tree-in-sql stackoverflow]
* //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)
* //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
=== Serialized Objects ===
* https://www.percona.com/blog/2010/01/21/when-should-you-store-serialized-objects-in-the-database
== SQL ==
* https://en.wikibooks.org/wiki/Structured_Query_Language/Introduction_to_SQL
* https://en.wikipedia.org/wiki/SQL
==== Views ====
* http://www.postgresql.org/docs/current/static/sql-createview.html
* http://www.doctrine-project.org/2009/06/19/using-views-with-doctrine.html (is it always valid?)
* http://www.postgresql.org/docs/current/static/rules-materializedviews.html
==== sql procedural language ====
* https://en.wikipedia.org/wiki/SQL#Procedural_extensions
* https://en.wikipedia.org/wiki/SQL/PSM
* https://en.wikipedia.org/wiki/Stored_procedure
==== Supported features ====
===== Data Types =====
====== json ======
* SQLite https://www.sqlite.org/json1.html
====== XML ======
* Seems not yet to be in Firebird
=== Embedded Database Programming ===
* https://en.wikipedia.org/wiki/Embedded_database
 * QDBM, BDB, http://php.net/manual/en/function.dba-handlers.php
 * [DebianPackage:php-tokyo-tyrant]​
 * [DebianPackage:php7.0-interbase] (php driver does not include embeded version of interbase) [DebianPackage:libfbembed2.5]
  * https://wiki.documentfoundation.org/Development/Base/FirebirdSQL
  * https://en.wikipedia.org/wiki/InterBase
  * https://en.wikipedia.org/wiki/Firebird_%28database_server%29
 * http://www.haildb.com/
 * [DebianPackage:php5-midgard2]​
=== sqlite ===
* [https://www.sqlite.org/omitted.html SQL Features That SQLite Does Not Implement]
* https://www.sqlite.org/json1.html
* https://www.sqlite.org/fts5.html
* [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
=== HSQLDB (Hyper SQL Database) ===
* https://en.wikipedia.org/wiki/HSQLDB
=== Postgres ===
* https://wiki.debian.org/PostgreSql
* http://db.cs.berkeley.edu/papers/ERL-M85-95.pdf
* http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.133.8073&rep=rep1&type=pdf
* https://dl.acm.org/citation.cfm?id=2834495
==== Performance ====
* http://fr.slideshare.net/pgconf/five-steps-perform2009
==== Timing ====
* [http://www.postgresql.org/message-id/4D9EABDD.1060102@limsi.fr Re: What does \timing measure?]
* http://www.postgresql.org/docs/9.4/static/runtime-config-statistics.html
* http://stackoverflow.com/questions/17653884/postgres-query-execution-time
* http://stackoverflow.com/questions/9063402/get-execution-time-of-postgresql-query
==== Procedural Language ====
* https://wiki.postgresql.org/wiki/PL_Matrix
* PL/pgSQL
 * Included in postgresql~ basic Debian Package
 * http://www.postgresql.org/docs/9.3/static/plpgsql.html
 * https://en.wikipedia.org/wiki/PL/pgSQL
  * http://postgres.cz/wiki/PL/pgSQL_(en)
* [DebianPackage:postgresql-plpython-9.4] more stable and more popular that PL/Lua
* [DebianPackage:postgresql-plpython3-9.4]
* [DebianPackage:postgresql-9.4-pllua] https://github.com/pllua/pllua http://wiki.alpinelinux.org/wiki/Pllua
* [DebianPackage:postgresql-pltcl-9.4]
* [DebianPackage:postgresql-9.4-plsh]
==== General information and Feature Lists ====
* [https://www.safaribooksonline.com/library/view/postgresql-up-and/9781449373184/ch01.html PostgreSQL: Up and Running]
* [https://www.compose.io/articles/what-postgresql-has-over-other-open-source-sql-databases Advertisement by a provider]
===== Release Notes and Documentation =====
* [http://www.postgresql.org/about/news/1415/ PostgreSQL 9.2 released]
=== MySQL ===
* https://en.wikipedia.org/wiki/MySQL
==== Stored Procedure ====
* MySQL stored procedure programming
 * http://www.worldcat.org/oclc/70161318
 * http://www.worldcat.org/oclc/850445083
* MySQL Cookbook
 * http://www.worldcat.org/oclc/76905222
=== Firebird ===
* https://wiki.documentfoundation.org/Development/Base/FirebirdSQL
* http://stackoverflow.com/questions/1635273/postgres-vs-firebird
== Java Programming ==
* https://packages.debian.org/fr/libunixsocket
== Javascript Programming (Client Side) ==
=== Tree viewing ===
* https://vuejs.org/examples/tree-view.html
=== Frameworks ===
* [https://vuejs.org/guide/overview.html Vue.js]
==== Comparisons ====
* https://vuejs.org/guide/comparison.html
== Javascript Programming (Server Side) ==
* [DebianPackage:node-express], [DebianPackage:node-], https://qa.debian.org/developer.php?login=pkg-javascript-devel@lists.alioth.debian.org
== [wiki:members/GRIP-UQAM/Doctrine_(PHP) Doctrine_(PHP)] ==
== [wiki:members/GRIP-UQAM/Symfony Symfony Programming] ==