Version 160 (modified by 9 years ago) ( diff ) | ,
---|
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
- 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
- Trac Syntax Coloring Example
- http://trac.edgewall.org/wiki/TracSyntaxColoring
- 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
Taged with python, tendenci, django, pyramid, php, drupal7, drupal, golang, fastcgi, chelsea, ossie
Results (1 - 10 of 1097)
Ticket | Modified | Resolution | Owner | Summary |
---|
Reported by us
No results
Taged with GRIP-UQAM with description
Results (1 of 21)
Ticket | Modified | Resolution | Owner | Summary |
---|
Development Tool
Pages we may need one day
Communication softwares
WebDAV
Symbolic links
- keyword: symbolic link web dav
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 ...
- https://support.mayfirst.org/wiki/faq/email/configure-email
- https://support.mayfirst.org/wiki/bulk-mail-relay
- https://support.mayfirst.org/wiki/email-deliverability
Postgres
MongoDB
Database Clients
- https://en.wikipedia.org/wiki/Comparison_of_database_tools
- pgadmin3
- phpmyadmin
- 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
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
- jsonlint
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
drupal.org followup
JavaScript Libraries
http://www.sitepoint.com/11-best-jquery-charting-libraries
PHP Libraries
hybridauth/hybridauth
http://hybridauth.sourceforge.net/userguide.html
$ composer require hybridauth/hybridauth
Google::
- easy
- easy
OpenID::
- easy (no secret information needed)
- https://github.com/hybridauth/hybridauth/tree/master/additional-providers/hybridauth-yahoo-openid
- http://hybridauth.sourceforge.net/userguide/tuts/specific-provider-wrapper.html
- https://login.yahoo.com/
- a mobile phone number is required to register a new account
- yahoo Application consumer key
- Not clear if the domain root URL can be used as redirect URI
- Using the domain root URL as redirect URI results in an error at the time of clicking the icon on the registered web site
- It is not possible to register inside Microsoft developper website a redirect URI similar to the one used for Google, because some caracteres are not accepted.
- one could try to make a simpler redirection URI which would redirect to the one simililar to the one used for Google.
- microsoft oauth2 application id
- Getting Your Client ID for Web Authentication
- https://account.live.com
- Mes applications
- https://developers.facebook.com/apps needs a phone number (sound or text) or a credit card
jessie (stable) | bpo | stretch (testing) | /usr/share/php/ | ||||
composer/composer | 2016-03-27 | b | # | composer | Composer | ||
hybridauth/hybridauth | 2016-01-12 | 2.6 | |||||
psr/log | 2012-12-21 | 1.0 | 1.0 | 1.0 | php-psr-log | Psr/Log | |
symfony/symfony | 2016-02-28 | 3.0 | 2.3 | 2.8 | php-symfony-framework-bundle | Symfony/Bundle/FrameworkBundle | |
https://packagist.org/packages/ | DebianPackage | /usr/share/php/ | |||||
https://packagist.org/packages/ | DebianPackage | /usr/share/php/ | |||||
https://packagist.org/packages/ | DebianPackage | /usr/share/php/ | |||||
https://packagist.org/packages/ | DebianPackage | /usr/share/php/ | |||||
https://packagist.org/packages/ | DebianPackage | /usr/share/php/ |
HTML Slides
Radical Servers
Fonts
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
Serialized Objects
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
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
- SQL Features That SQLite Does Not Implement
- https://www.sqlite.org/json1.html
- https://www.sqlite.org/fts5.html
- Please enable FTS5 support https://tracker.debian.org/media/packages/s/sqlite3/rules-3.11.0-3
HSQLDB (Hyper SQL Database)
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
Timing
- 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
- 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
Release Notes and Documentation
MySQL
Stored Procedure
- MySQL stored procedure programming
- MySQL Cookbook
Firebird
- https://wiki.documentfoundation.org/Development/Base/FirebirdSQL
- http://stackoverflow.com/questions/1635273/postgres-vs-firebird
Java Programming
Javascript Programming (Client Side)
Tree viewing
Frameworks
Comparisons
Javascript Programming (Server Side)
- node-express, node-, https://qa.debian.org/developer.php?login=pkg-javascript-devel@lists.alioth.debian.org
PHP Security Programming
- http://stackoverflow.com/questions/6474783/which-server-variables-are-safe
- http://stackoverflow.com/questions/4247704/how-tamper-proof-is-the-server-variable-in-php
PHP Programming
- http://php.net/manual/en/language.constants.predefined.php
- http://php.net/manual/en/function.getcwd.php
- http://stackoverflow.com/questions/4645082/get-absolute-path-of-current-script
- php+curent+directory
- http://php.net/manual/en/reserved.variables.environment.php
- http://php.net/manual/en/function.phpinfo.php
- http://php.net/manual/en/function.readlink.php
- http://stackoverflow.com/questions/12580330/php-dirname-returns-symlink-path
- https://bugs.php.net/bug.php?id=46260
- php+symlink+path
- http://php.net/manual/en/function.dirname.php
Namespaces
- https://www.youtube.com/results?search_query=php+namespaces
- http://knpuniversity.com/screencast/php-namespaces-in-120-seconds
Libraries
doctrine/orm
Doctrine Console
- http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/tools.html
- https://sonata-project.org/bundles/admin/2-3/doc/getting_started/creating_an_admin.html
$ php bin/console doctrine:generate:entity --entity="AppBundle:Category" --fields="name:string(255)" --no-interaction $ php bin/console doctrine:generate:entity --entity="AppBundle:BlogPost" --fields="title:string(255) body:text draft:boolean" --no-interaction
Relations
- Les relations entre entités avec Doctrine2 OpenClassrooms
- Les relations entre entités dans Symfony2 avec Doctrine lafermeduweb
Cascade
- doctrine ondelete
- doctrine one to many cascade
- 8. Working with Associations readthedocs
- Doctrine Cascade Options for OneToMany// stackoverflow
- cascade={“remove”} VS orphanRemoval=true VS ondelete="CASCADE stackoverflow
Events
Extensions - Behaviors
Gedmo are a standard, but Translatable is criticized
- gedmo/doctrine-extensions
- https://github.com/Atlantic18/DoctrineExtensions#extensions-and-documentation
- https://github.com/Atlantic18/DoctrineExtensions/tree/master/doc
- https://atlantic18.github.io/DoctrineExtensions/
- Gedmo l'extension Doctrine 2 dans Symfony2 2012 overblog
- knplabs/doctrine-behaviors
Compatibility Issues between Extensions
- SoftDeleteable - Sortable
- Sluggable, Translatable and Tree
Audit, Revision or Loggable
- Versioning of entities and their associations simplethings/entity-audit-bundle
- https://sonata-project.org/bundles/doctrine-orm-admin/master/doc/reference/audit.html
- Loggable
- Helps tracking changes and history of objects, also supports version management Gedmo
- Admin support picoss/sonata-extra-admin-bundle doc/audit_manager
- YouTube
- Loggable is able to track lifecycle modifications and log them using any third party log system KNP Labs
- Helps tracking changes and history of objects, also supports version management Gedmo
Blameable
- Updates string or reference fields on create, update and even property change with a string or object (e.g. user) Gedmo
- Track creators and updators of a given entity KNP Labs
Filterable
- Simple filter result KNP Labs
Geocodable
- Extensions to PostgreSQL platform in order to work with cube and earthdistance extensions KNP Labs
IpTraceable
- Inherited from Timestampable, sets IP address instead of timestamp Gedmo
Joinable
- KNP Labs
Loggable (see Audit, Revision)
References
- Supports linking Entities in Documents and vice versa Gedmo
ReferenceIntegrity
- Constrains ODM MongoDB Document references Gedmo
Revision (see Audit, Loggable)
Sluggable
- Urlizes your specified fields into single unique slug Gedmo
- Sluggable generates slugs (uniqueness is not guaranteed) for an entity KNP Labs
- Sluggable, Translatable and Tree (Compatibility issue)
SoftDeleteable
- Allows to implicitly remove records Gedmo KNP Labs
- SoftDeleteable - Sortable (Compatibility issue)
- Admin support picoss/sonata-extra-admin-bundle
- keyword: SoftDeleteable
- StofDoctrineExtensionsBundle softdelete - How do I use it? stackoverflow
- Episode 39 - Utiliser l'extension softdeleteable avec Symfony2 DevAndClick YouTube (fr)
Sortable
- Makes any document or entity sortable Gedmo KNP Labs
- SoftDeleteable - Sortable (Compatibility issue)
Timestampable
Translatable
- Gives you a very handy solution for translating records into different languages Gedmo
- KNP Labs
- Sluggable, Translatable and Tree (Compatibility issue)
Translator
- Explicit way to handle translations Gedmo
Tree
- This extension automates the tree handling process and adds some tree specific functions on repository. (closure, nestedset or materialized path) Gedmo KNP Labs
- Sluggable, Translatable and Tree (Compatibility issue)
Uploadable
- Provides file upload handling in entity fields Gedmo
Symfony Programming
- http://fr.slideshare.net/AcquiaInc/create-a-symfony-application-from-a-drupal-perspective
- https://www.youtube.com/results?search_query=symfony
- https://www.youtube.com/results?q=knpuniversity
Tutorials
- Jobeet Tutorial with Symfony2 fr
- DevAndClick YouTube
Software using Symfony
EZ Plateform
- EZ Plateform and Symfony Article from Symfony Finland
- https://packagist.org/packages/ezsystems/ezplatform
- http://share.ez.no/downloads/downloads
- https://doc.ez.no/display/TECHDOC/Requirements (Postgres install not yet supported 2016-04)
- https://doc.ez.no/display/TECHDOC/Using+Composer
Symfony Programming Tools
Hacking
autoload.php
- https://github.com/symfony/symfony-standard/blob/master/app/autoload.php The original
- https://github.com/symfony-cmf/standard-edition/blob/master/app/autoload.php Almost the same, maybe slightly older version
- https://github.com/symfony-cmf/cmf-sandbox/blob/master/app/autoload.php Locale component additions and others
MicroKernel
- http://symfony.com/blog/new-in-symfony-2-8-symfony-as-a-microframework
- https://symfony.com/doc/current/cookbook/configuration/micro-kernel-trait.html
- https://www.youtube.com/results?search_query=symfony+microkernel
- https://knpuniversity.com/screencast/new-in-symfony3/micro-kernel
- https://www.youtube.com/results?search_query=micro+symfony
- http://knpuniversity.com/screencast/micro-symfony
Components
Form
Translation
- see Bundle-Form-Translation
- see Bundle-Admin-Translation
Routing
RouteCollection vs RouteCollectionBuilder
add(string $name, Route $route) | $this addRoute(Route $route, string|null $name = null) |
Route add(string $path, string $controller, string|null $name = null | |
new RouteCollection()->add('root', new Route('/', [ '_controller' => 'FrameworkBundle:Redirect:redirect', 'route' => 'sonata_admin_dashboard', 'permanent' => true, ])); // to check | new RouteCollectionBuilder()->addRoute(new Route('/', [ '_controller' => 'FrameworkBundle:Redirect:redirect', 'route' => 'sonata_admin_dashboard', 'permanent' => true, ]), 'root' ); // to check |
Does not exist: cf $loader->import(...) | RouteCollectionBuilder import(mixed $resource, string|null $prefix = '/', string $type = null) |
Does not exist: cf addCollection | mount($prefix, RouteCollectionBuilder $builder) |
$collection = new RouteCollection(); $routing = $loader->import( "@SonataAdminBundle/Resources/config/sonata_admin.xml" ); $routing->setPrefix('/admin'); $collection->addCollection($routing); | $routes->mount('/admin', $routes->import('@SonataAdminBundle/Resources/config/routing/sonata_admin.xml')); |
Bundles
symfony/framework-standard-edition
- https://github.com/symfony/symfony-standard
- https://github.com/symfony/symfony-standard/blob/master/app/AppKernel.php
- symfony/framework-bundle FrameworkBundle - The core Symfony framework bundle
- Some components may sometimes be required
- symfony/console (for console)
- symfony/process (for console server:run)
- symfony/validator
- symfony/expression-language
- symfony/psr-http-message-bridge
- zendframework/zend-diactoros
- Some components may sometimes be required
- SensioFrameworkExtraBundle fr- Adds several enhancements, including template and routing annotation capability
- If you plan to use or create annotations for controllers, make sure to update your
autoload.php
by adding the following line...
- If you plan to use or create annotations for controllers, make sure to update your
- doctrine/doctrine-bundle DoctrineBundle - Adds support for the Doctrine ORM
- TwigBundle - Adds support for the Twig templating engine
- symfony/security-bundle SecurityBundle - Adds security by integrating Symfony's security component
- symfony/security may need to be also required
- symfony/swiftmailer-bundle SwiftmailerBundle - Adds support for Swiftmailer, a library for sending emails
- MonologBundle - Adds support for Monolog, a logging library
- WebProfilerBundle (in dev/test env) - Adds profiling functionality and the web debug toolbar
- SensioDistributionBundle (in dev/test env) - Adds functionality for configuring and working with Symfony distributions
- sensio/generator-bundle SensioGeneratorBundle fr (in dev/test env) - Adds code generation capabilities
- Choosing the annotation format expects the SensioFrameworkExtraBundle to be installed
- There should be one line of imports in the
config.yml
file! (otherwise changes may not be added to it!) - Generating a New Bundle Skeleton
- in composer.json (for autoload):
"autoload": { "psr-4": { "": "src/" } }
$ php bin/console generate:bundle --namespace=AppBundle --bundle-name=AppBundle --format=annotation --dir=../src --no-interaction Bundle generation > Generating a sample bundle skeleton into app/../src/AppBundle OK! > Checking that the bundle is autoloaded: OK > Enabling the bundle inside /...app/AppKernel.php: OK > Importing the bundle\'s routes from the app/config/routing.yml file: OK > Importing the bundle\'s services.yml from the app/config/config.yml file: OK Everything is OK! Now get to work :).
- files touched:
- app/../src/AppBundle (directory and content generated)
- app/AppKernel.php
- app/config/routing.yml
- app/config/config.yml (see note about line of import)
- in composer.json (for autoload):
- DebugBundle (in dev/test env) - Adds Debug and VarDumper component integration
Bundles documented by symfony.com
- doctrine/doctrine-fixtures-bundle symfony.com fr
- sonata-project/admin-bundle symfony.com cmf/tutorial
- stof/doctrine-extensions-bundle symfony.com
User
- friendsofsymfony/user-bundle
Social Login
OAuth
- hwi/oauth-bundle
- friendsofsymfony/oauth-server-bundle (server)
- http://knpuniversity.com/screencast/oauth
- https://www.youtube.com/results?search_query=oauth
HybridAuth
OpenID
Form related
Admin sonata-project/admin-bundle
- symfony.com sonata-project.org
- sonata-project/doctrine-orm-admin-bundle sonata-project.org
- sonata-project/doctrine-phpcr-admin-bundle
- sonata-project/doctrine-mongodb-admin-bundle
- http://stackoverflow.com/questions/22916083/sonata-admin-bundle-adding-link-to-related-entities-in-configure-list
Admin without Admin Bundle
Default value
- keyword: sonata admin getnewinstance
- https://sonata-project.org/bundles/admin/master/doc/cookbook/recipe_custom_action.html
- https://stackoverflow.com/questions/10546168/setting-default-value-in-symfony2-sonata-admin-bundle
Translation sonata-project/translation-bundle
- sonata-project.org
- see Doctrine-Extensions-Translatable
- see Bundle (Component)-Form-Translation
Tree
Formatter
CKEditor
- http://www.techtonet.com/sonata-add-ckeditor-in-admin-textareas/
- https://stackoverflow.com/questions/20269617/how-to-add-ckeditor-to-sonata-admin-backends-textareas
CKEditor
Tree
- symfony-cmf/tree-browser-bundle
- http://www.codeproject.com/Tips/418196/Editing-Tree-Structures-in-Symfony
- http://knpbundles.com/keyword/tree-symfony-bundle
Tag and Taxonomy
News, Newsletter
Search
Payment
Help Desk, Bug Tracking and Ticket
CLI code generation example
$ php bin/console generate:bundle --namespace=AppBundle --bundle-name=AppBundle --format=annotation --dir=../src --no-interaction $ php bin/console assets:install ../web --symlink --relative $ php bin/console doctrine:generate:entity --entity="AppBundle:Category" --fields="name:string(255)" --no-interaction $ php bin/console doctrine:generate:entity --entity="AppBundle:BlogPost" --fields="title:string(255) body:text draft:boolean" --no-interaction $ php bin/console doctrine:schema:create $ php bin/console doctrine:schema:update # after modification
See
- sensio/generator-bundle
- doctrine/orm