php developer blog

International PHP Conference Spring Edition Day 1

by Dominik Jungowski

26. Mai 2009 comments feed

Some words on the sessions I attended today, but first off: Since I only got here yesterday, I could not attend the workshop day.

MySQL Performance Tuning & Optimization Capsule (Sonali Minocha)

Some known stuff, a lot of new tweaks, optimizations and dos/don'ts I didn't know yet. For example PROCEDURE ANALYSE() was totally new to me, you would use it like this: select * from mysql.user procedure analyse(); Basically all this does is to check the results the query produces and it then tells you the optimal type you should use for each column, based on the result data. For more information check the documentation linked above. Furthermore the talk was about optimizing query cache, InnoDB specific optimizations, Index optimiazations and many more.

Sichere Applikationen auf Basis des Zend-Frameworks (Stefan Esser)

I was really looking forward to this session. Although most of the shown, like the proper use of Validators, Filters or how to access $_GET/$_POST/etc. variables correctly, there were things that were new to me, like Zend Frameworks build-in possibility against Cross-Site Request Forgery (CSRF). On one hand, I had hoped to learn a bit more, but on the other hand it maybe tells me that I'm on the right course… ;-)

Why Architecture in Web Development matters (Lars Jankowfsky)

Lars showed some really interesting basics for building a good architecture, spiced up with some examples of how they did it at Swoodoo. I already enjoyed Lars' article on architecture in the PHP magazin a while ago and this talk was a good extension to it. Generally it seems that SOA (Service Oriented Archicture) is a good way for abstraction in architecture, even though it makes integration testing harder, since you have to write more mock-up objects.

The Present and Future of PHP (Andrei Zmievski)

Everytime you think about coding in Ruby, Domo-Kun kills a kitten!

DTrace für AMP-Entwickler und Administratoren (Johannes Schlüter)

Johannes showed really nice ways to trace (and debug) processes (and with focus on php) not using strace, but Suns dtrace. It's possibilites really impressed me and there's not really anything I can say about it right now, apart from the fact that you need PHP 5.3 or MySQL 5.4 (there are backports on Solaris up to 5.1) to be able to use it for those two.

By the way: That was fun (in German) ;D