members/GRIP-UQAM – Support

Context Navigation

Version 162 (modified by Grip Uqam, 9 years ago) ( diff )
--

TranslatedPages

Who we are?

http://gripuqam.org We are french speaking so this page will be translated unsing the advise in faq/translate/pages

Wiki page we read or collaborate to write @ mayfirst

faq/translate/pages
Formatting List of References
- Title in italic
- References
Types of documents
- Book
- README
- FAQ Wikipedia
- HOWTO Wikipedia
- Recipe Wikipedia
- Guide Wikipedia
WikiFormatting
- http://trac.edgewall.org/wiki/TracSyntaxColoring
  - Trac Syntax Coloring Example
```
{{{#!sh
}}}
{{{#!application/x-shellscript
}}}
```
    path$ echo "World" ; ls ; cd ; help # comment
```
{{{#!json
}}}
{{{#!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
TicketQuery Macro (tagging tickets) examples:
There is somewhere a useful cloud of tags. faq/wordpress/WordPressInstall
Tag for Debian packages [DebianPackage:python-whoosh]python-whoosh

Tickets we follow

Taged with GRIP-UQAM

Results (1 - 10 of 21)

1 2 3 →


Ticket	Modified	Resolution	Owner	Summary

1 2 3 →

Taged with python, tendenci, django, pyramid, php, drupal7, drupal, golang, fastcgi, chelsea, ossie

Results (1 - 10 of 1097)

1 2 3 4 5 6 7 8 9 10 11 →


Ticket	Modified	Resolution	Owner	Summary

1 2 3 4 5 6 7 8 9 10 11 →

Reported by us

No results

Taged with GRIP-UQAM with description

Results (1 of 21)

1 2 3 4 5 6 7 8 9 10 11 →


Ticket	Modified	Resolution	Owner	Summary

1 2 3 4 5 6 7 8 9 10 11 →

Development Tool

Pages we may need one day

Communication softwares

WebDAV

Symbolic links

keyword: symbolic link web dav

Backup

https://support.mayfirst.org/wiki/faq/member-backup

DNS

$ 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
```
... &> cron/results/<file>
```
Consider nice and ionice to give priority to interactive tasks
```
nice -n 127 ionice --class=idle ...
```

Email

Postgres

MongoDB

#11321

Database Clients

https://en.wikipedia.org/wiki/Comparison_of_database_tools
pgadmin3
phpmyadmin
- http://www.sitepoint.com/phpmyadmin-alternatives/
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!)
- 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
  - jsonlint
  - composer require seld/jsonlint
  - https://packagist.org/packages/seld/jsonlint
- python-json-schema-validator

Javascript packages: Bower

Composer

Web Applications

Useful Debian Packages (Chelsea)

apache2-mpm-worker(debian 8 jessie apache2 which uses mpm_event by default)
apache2-suexec-custom (also debian 8 jessie apache2-suexec-pristine or debian 7 wheezy apache2-suexec)
libapache2-mod-fcgid
php5-cgi
since february 2016 MayFirst uses mod_proxy_fcgi + php5-fpm

Note Altern-C

Altern-C seems to use libapache2-mpm-itk(debian 7 wheezy apache2-mpm-itk)

To keep in mind

4875 id=4875 No results No results No results No results

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

PHP Libraries

HTML Slides

https://packagist.org/packages/seld/slippy

Radical Servers

https://help.riseup.net/en/security/resources/radical-servers

Fonts

fonts-font-awesome

HTML Programming

Microformat Wikipedia
- 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 WorldCatThe Pragmatic Bookshelf
- Review O'Reilly
SQL design patterns : the expert guide to SQL programming WorldCat Rampant

Tree or Hierarchical Data

nested-set, closure-table and materialized-path.
Tree_(data_structure) Wikipedia
Joe Celkos: Trees and Hierarchies in SQL for Smarties WorldCat Table of Content (pdf)
SQL - How to store and navigate hierarchies? stackoverflow
How to represent a data tree in SQL? stackoverflow
Models for hierarchical data SlideShare
How to represent a tree structure numerically in SQL Server yellowpencil (short HOWTO)
Closure Table – Store Hierarchical Data Seamlessly | PostgreSQL technobytz (short HOWTO)
What is the most efficient/elegant way to parse a flat table into a tree? stackoverflow
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

Views

sql procedural language

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
- php-tokyo-tyrant
- php7.0-interbase (php driver does not include embeded version of interbase) libfbembed2.5
- http://www.haildb.com/
- php5-midgard2

sqlite

HSQLDB (Hyper SQL Database)

https://en.wikipedia.org/wiki/HSQLDB

Postgres

Performance

http://fr.slideshare.net/pgconf/five-steps-perform2009

Timing

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)
postgresql-plpython-9.4 more stable and more popular that PL/Lua
postgresql-plpython3-9.4
postgresql-9.4-pllua https://github.com/pllua/pllua http://wiki.alpinelinux.org/wiki/Pllua
postgresql-pltcl-9.4
postgresql-9.4-plsh

General information and Feature Lists

Firebird

Java Programming

https://packages.debian.org/fr/libunixsocket

Javascript Programming (Client Side)

Tree viewing

https://vuejs.org/examples/tree-view.html

Frameworks

Vue.js

Comparisons

https://vuejs.org/guide/comparison.html

Javascript Programming (Server Side)

node-express, node-, https://qa.debian.org/developer.php?login=pkg-javascript-devel@lists.alioth.debian.org

Context Navigation

Who we are?

Wiki page we read or collaborate to write @ mayfirst

Tickets we follow

Taged with GRIP-UQAM

Results (1 - 10 of 21)

Taged with python, tendenci, django, pyramid, php, drupal7, drupal, golang, fastcgi, chelsea, ossie

Results (1 - 10 of 1097)

Reported by us

Taged with GRIP-UQAM with description

Results (1 of 21)

Development Tool

Pages we may need one day

Communication softwares

WebDAV

Symbolic links

Backup

DNS

Cron

Email

Postgres

MongoDB

Database Clients

Git

Json

.json validator

Javascript packages: Bower

Composer

Web Applications

Useful Debian Packages (Chelsea)

Note Altern-C

To keep in mind

drupal.org followup

JavaScript Libraries

PHP Libraries

HTML Slides

Radical Servers

Fonts

HTML Programming

SQL Database Programming

Design Principles

Tree or Hierarchical Data

Blobs for documents

Serialized Objects

SQL

Views

sql procedural language

Supported features

Data Types

json

XML

Embedded Database Programming

sqlite

HSQLDB (Hyper SQL Database)

Postgres

Performance

Timing

Procedural Language

General information and Feature Lists

Release Notes and Documentation

MySQL

Stored Procedure

Firebird

Java Programming

Javascript Programming (Client Side)

Tree viewing

Frameworks

Comparisons

Javascript Programming (Server Side)

Doctrine_(PHP)

Symfony Programming

Download in other formats: