PHP5 and Advanced techniques
Rasmus Lerdorf will share his experience with PHP on large scale applications. He will give tips and tricks on how to deploy applications using the most advanced techniques. He will also introduce some of the new features in PHP 5 and explain how they can improve web applications.
Top
Cas d'utilisation: Caisse Populaire Desjardins
Sébastien Brodeur parlera de son expérience avec PHP à la Fédération des Caisse Populaire Desjardins. Il présentera certains projets réalisés afin de répondre aux besoins de l'équipe. Les principaux projets sont : Outil de gestion d'entrée de temps des employés, des outils de génération de rapports et de graphiques en temps réel, des outils de mise à jour des taux et de rendements ainsi que des simulateurs financiers.
Top
PHP 5 & WebServices
Ilia Alshanetsky will cover the most recent developments in the PHP 5 extensions for web services. The session will give an introduction to the new XML-RPC and SOAP extensions. Ilia will explain how those extensions can be used to communicate with distant applications transparently and how servers can be created within minutes.
Top
Clustering and Replication
Like most things with MySQL, clustering and replication is quite easy to setup and manage. With just a little help, you can have your own solutions up and running in little time. This talk will walk you through the possible configurations, including the NDB storage engine, and show you how to configure your own setup. Emphasis will be placed on the tools that make it easy to maintain your clusters.
Top
Creating a storage engine
With MySQL, you decide the storage engine system you wish to use. While MySQL comes with storage engines tuned for transaction and data warehousing systems, to some, neither of these may be the right solution. Are you a developer who has a data format that you spend time pushing into MySQL daily? Do you have your own idea about the best method for storing your data? This talk provides you with the know-how to create a read/write storage engine of your own. The talk will walk through the API and will show you the key points of how to connect your data to MySQL. You provide the data, MySQL provides the SQL, JDBC, DBD, and other connectors to make your data available to your favorite applications.
Top
Database Normalisation
In this session, Mike Hillyer of MySQL AB will introduce the audience to the principles of database normalization.
Database normalization is a process that removes redundancies from your data and not only improves the integrity of your data, it can also improve performance and storage efficiency.
This session will be appropriate for any audience members with a basic knowledge os databases and SQL and will be applicable to users of any SQL database, but will use examples based in MySQL.
Top
Dealing with hierarchical data in MySQL
In this session, Mike Hillyer of MySQL AB will introduce methods for dealing with hierarchical in MySQL.
Representing hierarchical information in a SQL database has always presented a challenge because most SQL RDBMSes are not designed to represent hierarchical information. Mike will present some tools and techniques for handling such information in SQL.
This session should be appropriate to those who have some experience with MySQL or another SQL RDBMS. The principles presented will apply to any SQL RDBMS, but MySQL will be used for demonstrations.
Top
Load-Balanced Enterprise Web Applications Over Multiple Database Servers Using PHP and MySQL
The session will detail new reporting methodologies at Name Intelligence Inc designed to efficiently run intensive database processes over our architecture. Under this scheme, expensive queries are placed in a special report queue where a reporting daemon generates the resulting reports in a way that will not bog down the MySQL servers or site performance. This is accomplished through an interesting implementation of PHP5s OO capabilities and the pcntl functions for threading and process management. This strategy, in conjunction with moving expensive queries off of the web server array, keeps all of the PHP based web tools running quickly, with a minimum of queries/page.
The session requires basic knowledge of:
- PHP5 and its new OO functions
- MySQLi API
- Exception handling
- SQL
- Binary operators (&, ~ and | )
Top
Integrating traditional PHP-driven login mechanism with Oracle's advanced security
Managing user rights is a common problem in a large enterprise. Simple security levels do not provide the flexibility to match users to the rights they are entitled to on an individual basis. Would you like to learn how to delegate this task to the database engine that would automatically recognize the user and produce the results tailored to each user's access rights? PHP developers from McGill University have developed a state-of-the-art security framework that utilizes traditional PHP-driven login mechanism, practices true row-level security, centralizes access to critical data, employs innovative database design techniques, and helps to reduce complexity of PHP applications. In this session these tools and methods will be explained as a way to increase data security without compromising performance, all while allowing appropriate user access.
Top
PEAR (the PHP Extension and Application Repository)
PEAR (the PHP Extension and Application Repository) is the major code repository for PHP. It provides you a huge number of number of open source components for PHP and a common installer infrastructure for PHP code and C modules for PHP. Since version 4.3.2 it is shipped with every PHP installation by default (since 4.3.0 for Unix systems) and it's variaty of classes for the most different purposes grows from day to day. PEAR components are ready for use with PHP4 and PHP5 and give you a stable basis for developing enterprise grade web applications. With more than 500 registered developers and over 350 packages PEAR is one of the largest PHP projects around. The project also defines standards for PHP development and implements quality assurance mechanisms.
This double-session will introduce you into using PEAR for your daily development in a workshop like way. The first third will introduce you into the project. You will see the structure of PEAR and will get to know important PEAR institutions. After that, the second part will cover the PEAR installer and it's usage. You will afterwards be able to install PEAR initially (if it's not shipped with an older PHP version), to configure the installer and to install/uninstall/upgrade/... packages. The last third of this talk will cover the active development with PEAR. A practical example application will be presented, showing the usage of PEAR code in general and some interessting packages in particular.
Top
Apache Logfile Data Mining
It is amazing the amount of information that can be gathered from the simple Apache Log files. User threads (clickstreams), Operating system use, Browser use, and much more. I've been writing custom scripts to parse logfile data in manners needed by my company for 7 years, and will share the tips and tricks I have learned. This session would start by giving an understanding of the log line format and what each section means. It would then transition into basic simple parsing of the file and the statistics that you can easily gather from it. Then we would cover some more advanced topics that require a few tricks. During that we would end up covering how to properly detect Browsers and OS's with all the variations that exist in User Agent strings. Finally we would transition into more advanced topics, discussing the LogFormat directive, what extra information you might want to add to your logfiles, and how this information can help you determine more about the people who come to your website and how well the website is running.
Top
Mathematical Programming with PHP
Intelligent Web applications require number crunching yet PHP lacks many mathematical programming tools that would help make advanced number crunching possible. In this presentation we will ask why PHP lacks math programming tools and how we might go about adding math processing capabilities to PHP. My current preference is to implement math programming tools as packages and we will spend most of our time discussing two strategic PHP-based math packages: the Probability Distributions Library Package (aka PDL Package) and the JAMA Package for linear algebra. Finally I will discuss whether we should compete with or bind to other mature open-source math libraries. My preference is to compete.
Top
PHP & Flash
Bien au-delà des simples animations, Flash présente maintenant un environnement de développement mature et un language de programation OOP complet qui rend possible la création d'applications internet riches. L'échange de données est facilité par Flash Remoting, une technologie client/serveur s'inspirant de SOAP. Nous présentons ici AMFPHP 1.0, la passerelle Remoting pour PHP permettant d'interfacer de façon sécure, rapide et transparente avec Flash.
Nous couvrirons les bases de Remoting et de AMFPHP, l'envoi transparent de résultats MySQL vers Flash et le transfert de classes actionscript vers PHP. Nous discuterons également de sujets avancés, soit l'intégration avec FlashComm, pour des applications socket en temps réel, et avec Flex, la nouvelle génération d'applications Flash basée sur XML.
Top
phpMyAdmin : plus qu'un gestionnaire MySQL
Les dernières versions de phpMyAdmin ont apporté de nouvelles fonctionnalités dont les bookmarks et la sauvegarde de requêtes MySQL, la génération de PDF, l'exportation et l'importation, l'installation commune, les tables relationnelles et autres. Cette session couvrira des fonctionnalités nouvelles ainsi que des méconnues de phpMyAdmin.
Top
SPL: Standard PHP 5 Library
This session will equip you with all the knowledge to take advantage of switching towards PHP 5 and using SPL aka Standard PHP Library. You will learn about the new exception hierarchy introduced with PHP 5.1. I will explain the error situations each exception class adresses. This way you will learn how to use exceptions correctly and how and when to extend built in exceptions. You will also learn how __autoload can be very contra productive and how SPL can help. Last but not least you will learn how to take advantage of the SPL Iterators by example. And finally the session will end with some insight about the shining bright future of SPL.
Top
Integrating PHP and Java
With PHP 5 and its new OOP model, it became easier to interface PHP and Java programs. Over a year ago, Zend and Sun Microsystems started Java Specification Request (JSR) 223 to define a standard on how to bridge between PHP and Java. There is now connectivity to connect front-end PHP servers to back-end J2EE application servers and, more specifically, the ability to call Enterprise Java Beans (EJBs) directly from PHP code. This session will tell you everything about what's coming up.
Top
Ixmati: Buisness Process Management and Workflow
Nowadays, many buisiness need to save time, save money or save anything they actually can. Unfortunately some business tend to have tasks done twice or more by many of the employees, this is unacceptable, and has to be fixed somehow. Many employees work as twice as hard as other employees in the same position, mostly because there are no metrics at all...
Ixmati is a Business Process Manager and Workflow completely written in PHP5 and using PostgreSQL as main database. Ixmati can also work with many other databases since it uses the AdoDB framework. It uses most of the new OOP features in PHP5, therefore is highly modular and scalable. Ixmati help workgroups to communicate, discuss about current instances, share files and most important; share knowledge.
Ixmati has been in use in "Comisión Nacional para el desarrollo de los Pueblos Indigenas(CDI)" for many purposes. In this session, I'll be showing how Ixmati was developed from ground up, how you can customize it, how you can write your own modules using our workflow framework.
- helpdesk for technical support in the IT department
- Bug Tracking system for the system development department
- WorkFlow system for the lawers department
Top
Use Case: Help on Board
This session will describe why and how php/mysql was chosen for the Help On Board project management application, the challenges in managing multiple sites over multiple hosting locations using the same application code set. Demonstrate the successful use of technology with our clients using www.webconference.com's webconference service during remote training sessions.
Top
Pitching PHP and Open Source Solutions to the Health Care Industry
Hans Kaspersetz will share his experience recommending PHP and open source solutions to the health care industry. The talk will cover educating clients in open source, helping these clients to identify where PHP and open source will support their objectives, and making a business case for PHP. This talk will include a brief case study of the rapid development of a cutting-edge market-shaping tool using existing open source software.
Top
Interoperabilité XML avec Tomcat (Java)
Cette conférence fait un survol des techniques qui permettent les échanges de données entres diverses plateformes serveurs, par le biais de données en XML. Plusieurs options sont présentées ainsi que le détail d'un cas concret d'interop dans un environnement distribué hétérogène. Les aspects de coordination techniques, d'implantation et d'opérations seront abordés. Pour terminer, quelques leçons apprises seront présentées, questions de vous faire profiter de nos cicatrices!
Top
The State of PHP in New York City
Staying at the forefront of web technology is imperative to the success of any business in today's global economy. Finding robust, flexible and (often) inexpensive solutions to capitalize on globalization by replacing legacy systems with web applications is a high priority formany businesses in and around New York. PHP and the AMP platform is the natural solution to this business dilemma, yet many enterprise level businesses are resistant to using the technologies, while most small and mid-sized companies have embraced this platform for years.
Top
Playing Safe
This session will deal with multiple ways to work securely with sensitive data. Included in the different methods to 'secure' information are: Using Message Digest Authentication with HMAC based methods, assymetric encryption for signed and encrypted data. The session will also include tips on when securing data doesn't make sense, why it is important to secure sensitive information and how to deal with mission-critical data in databases.
Top
Security and common vulnerabilities
Multiple PHP applications suffer from vulnerabilities caused by the ignorance of the dangers by the developpers. Chris Shiflett will explain the common vulnerabilities, where the dangers are coming from and how to protect applications against various attacks. The session will cover the best practices in data validation.
Top
Distributed Authentication with Drupal and SXIP
Hear how single sign-on was added to Drupal, the popular Open Source content management software built on PHP/MySQL. James will discuss Drupal's built-in user authentication, Drupal's hook mechanism, and how SXIP integrates cleanly to allow secure distributed users and profile sharing.
Top
Logiciel Libres en entreprise au Québec
Robert Gérin Lajoie expliquera comment les logiciels libres peuvent s'introduire dans les entreprises québécoises et les enjeux qui y sont liés. Il traitera des différentes options disponibles et en fera un comparatif.
Top
Le projet Mille et le monde de l'éducation au Québec
MILLE, Modèle d'Infrastructure de Logiciel Libre en Éducation, a pour but de réduire les coûts d'acquisition et de maintenance des infrastructures matérielles et logicielles, de réduire les coûts de développement et de maintenance des services et d'accroître l'accès à ces derniers tant à l'école qu'à la maison en proposant une architecture logicielle basée sur les logiciels libres.
Louis Fortier will present the various technologies the system requires and some of the challenges.
Top
PHP inattendu
PHP a largement dépassé le cadre du Web pour lequel il a été inventé. On trouve aussi ses applications en gestion, en administration, sur les magnétoscopes ou encore pour répondre au téléphone.
Venez voir comment PHP fait le café, maîtrise les communications avec Voice Over IP, ou encore s'affiche sur une bannière lumineuse défilante. Durant cette session, préparez-vous à être surpris par toutes les utilisations extraordinaires de PHP : saurez-vous deviner la dernière ?
Top
Administering Apache web server
Ken Coar / English Session
Although the Apache Web server has a lot of knobs and dials for controlling access and dealing with incoming requests, almost all of them are static in nature and require manual editing and reconfiguration when changes are needed. This presentation will describe some ways in which PHP can be used to automate some of this in real time; the specific case study will deal with handling abusive spiders and Web crawlers.
Top
How to make your own ASF project
Ken Coar / English Session
The Apache Software Foundation is one of many organisations that supports the development of open software. Unlike a lot of them, though, its main focus is on community development rather than code. This presentation will give a brief outline of what it means to be part of an Apache project, and then describe the steps involved in bringing an existing project, or a new one, to petition to become part of the Apache organisation.
Top
