At 24./25. of September 2008 there will be the OpenExpo in Winterthur. I will be in charge of the PHP booth. I am looking for PHP-Developers, -Evangelists and -Fanboys (and girls) to help me out.

Get Discounted Abbyy Finereader 9 Pro Multilang microsoft office live small business Adobe Creative Suite 4 Web Standard Mac microsoft office professional 2007 upgrade Autocad 2011 For Mac Oem discount for microsoft office 2007 Buy Low Price Oem Adobe Photoshop Cs5 Extended Online buy microsoft office professional Microsoft Office 2011 Home And Student For Mac Oem microsoft office 2000 small business Autodesk Robot Structural Analysis Professional 2011 office downloads free microsoft office word Adobe Photoshop Lightroom 3 Oem microsoft office 2007 open license media download Denoise For Mac Oem buy microsoft office project professional 2007 sp2 for cheap Autodesk Revit Architecture 2012 discount microsoft office for college students Adobe Indesign Cs5.5 trial microsoft word Get Adobe Dreamweaver Cs5 microsoft publisher software Adobe Creative Suite 5 Master Collection Student And Teacher Edition microsoft office power point Purchase Microsoft Windows Server 2008 Microsoft Sql Server 2008 Online microsoft office templates Get Oem Adobe Cs4 Master Collection Online cheap microsoft office from canada Adobe Creative Suite 4 Web Premium Oem 2007 microsoft office word product Windows Server 2003 Standart R2 Sp2 (64 Bit) microsoft excel help Corel Painter X microsoft word 97 Autodesk Autocad Electrical 2010 (32 Bit) office microsoft word Adobe Photoshop Cs5.5 Extended Student And Teacher Edition free microsoft office lessons Discounted Oem Rosetta Stone Version 3 French All Levels Set Online how to make microsoft office ultimate 2007 genuine Rosettastone Greek Level 1, 2 3 Set microsoft virtual office Adobe Fireworks Cs4 For Mac microsoft office professional edition 2003 cd Autocad Structural Detailing 2010 32 Bit buy cheap microsoft office project professional 2007 sp2 software Discounted Oem Microsoft Office 2003 Pro With Business Contact Manager For Outlook goffice vs microsoft office Access 2010 microsoft office suite for sale Autodesk Inventor Suite 2011 microsoft office education Adobe Captivate 4 Oem microsoft office word excel software Maxon Cinema 4d R11 Studio Bundle microsoft office project professional 2007 sp2 download price: 9.90 Purchase Low Price Oem Microsoft Windows Vista Sp2 discount for microsoft office 2007 Adobe Creative Suite 5.5 Master Collection For Mac buy microsoft office professional Adobe Creative Suite 4 Production Premium microsoft office 2000 small business Microsoft Office 2011 Home Student Mac office downloads free microsoft office word Adobe Audition Cs5 Oem microsoft office 2007 open license media download Dxo Optics Pro 5.7 For Mac Oem buy microsoft office project professional 2007 sp2 for cheap Get Oem Solidworks 2009 Online discount microsoft office for college students Rosettastone Spanish (latin America) Level 1, 2, 3, 4 5 Set Mac trial microsoft word Dragon Dictate 2.1 For Mac Oem microsoft publisher software Fieldskit For Mac Oem microsoft office power point Diskcatalogmaker 6 For Mac Oem microsoft office templates Microsoft Office 2010 Professional (64-bit) cheap microsoft office from canada Adobe Pagemaker 7 Oem 2007 microsoft office word product Purchase Discounted Oem Adobe Cs4 Master Collection Online microsoft excel help Buy Oem Autodesk Autocad 2009 microsoft word 97 Purchase Discounted Oem Abbyy Finereader 8 Pro Multilang Online office microsoft word Oem Rosetta Stone Version 3 Chinese All Levels Set free microsoft office lessons Autocad Architecture 2011 Oem how to make microsoft office ultimate 2007 genuine Autodesk Navisworks Simulate 2009 microsoft virtual office Adobe Creative Suite 5 Production Premium Oem microsoft office professional edition 2003 cd Autodesk Autocad Pid 2011 buy cheap microsoft office project professional 2007 sp2 software Filemaker Pro 11 Advanced Oem goffice vs microsoft office Get Cheap Microsoft Windows Vista Sp2 Online microsoft office suite for sale Adobe After Effects Cs5 Professional microsoft office education Ashampoo Magical Snap 2 microsoft office word excel software Acid Pro 7 microsoft office project professional 2007 sp2 download price: 9.90 Discounted Rosetta Stone Version 3 English All Levels Set For Mac Online discount for microsoft office 2007 Adobe Flash Professional Cs4 For Mac buy microsoft office professional Autopano Giga 2 Oem microsoft office 2000 small business Cheap Oem Cakewalk Sonar 8 Producer Edition office downloads free microsoft office word Autocad Lt 2011 microsoft office 2007 open license media download Download Discounted Oem Microsoft Windows Server 2008 Microsoft Sql Server 2008 Online buy microsoft office project professional 2007 sp2 for cheap Purchase Microsoft Windows Server 2008 discount microsoft office for college students Finale Printmusic 2011 For Mac Oem trial microsoft word Where Can I Purchase Discounted Adobe Photoshop Cs5 Extended microsoft publisher software Purchase Oem Microsoft Windows Vista Ultimate microsoft office power point Filemaker Server 10 Advanced microsoft office templates Download Cheap Oem Adobe Cs4 Production Premium cheap microsoft office from canada Download Rosetta Stone Version 3 English All Levels Set For Mac Online 2007 microsoft office word product Littlesnapper For Mac Oem microsoft excel help Adobe Soundbooth Cs4 Oem microsoft word 97 Get Discounted Abbyy Finereader 9 Pro Multilang Online office microsoft word Desktop Poet For Mac Oem free microsoft office lessons Roxio Toast 11 Titanium For Mac how to make microsoft office ultimate 2007 genuine Download Cheap Adobe Cs4 Master Collection For Mac Online microsoft virtual office Windows Xp Professional With Service Pack 3 Oem microsoft office professional edition 2003 cd Adobe Audition Cs5.5 Mac buy cheap microsoft office project professional 2007 sp2 software Microsoft Office 2007 Professional goffice vs microsoft office Where Can I Buy Discounted Rosetta Stone Version 3 Dutch All Levels Set microsoft office suite for sale Download Discounted Abbyy Finereader 9 Pro Multilang microsoft office education Purchase Low Price Oem Adobe Creative Suite 3 Master Collection Online microsoft office word excel software Acronis True Image Home 2011 Oem microsoft office project professional 2007 sp2 download price: 9.90 Ashampoo Office 2008 discount for microsoft office 2007 Finale 2011 For Mac buy microsoft office professional Get Discounted Autodesk Autocad 2008 Online microsoft office 2000 small business Autodesk Imagemodeler 2009 Mac office downloads free microsoft office word Adobe Photoshop Cs5 Extended For Mac Student And Teacher Edition microsoft office 2007 open license media download Adobe Flex Builder 3 Pro Oem buy microsoft office project professional 2007 sp2 for cheap Adobe After Effects Cs5.5 Mac discount microsoft office for college students Purchase Cheap Abbyy Finereader 8 Pro Multilang Online trial microsoft word Buy Adobe Cs4 Master Collection microsoft publisher software Adobe Creative Suite 5 Web Premium Mac microsoft office power point Autodesk Maya 2011 For Mac Oem microsoft office templates Oem Rosetta Stone Version 3 English All Levels Set Online cheap microsoft office from canada Windows Server 2008 R2 Standart (64 Bit) 2007 microsoft office word product Rosettastone Hebrew Level 1, 2 Set Mac microsoft excel help Filemaker Pro 8.5 Advanced For Mac Oem microsoft word 97 Home Plan Easy Oem office microsoft word Cheap Oem Microsoft Windows Server 2008 Online free microsoft office lessons Adobe Illustrator Cs5 how to make microsoft office ultimate 2007 genuine Ashampoo Clipfisher microsoft virtual office Get Low Price Oem Adobe Acrobat 8 Pro microsoft office professional edition 2003 cd Adobe Contribute Cs4 Oem buy cheap microsoft office project professional 2007 sp2 software Download Oem Adobe Photoshop Cs5 Extended For Mac goffice vs microsoft office Ashampoo 3d Cad Architecture 2 Oem microsoft office suite for sale Quicken Deluxe 2009 Oem microsoft office education Data Guardian Oem microsoft office word excel software Windows Xp Professional Sp3 (32 Bit) microsoft office project professional 2007 sp2 download price: 9.90 Autodesk Viz 2008 discount for microsoft office 2007 Cheap Rosetta Stone Version 3 Chinese All Levels Set buy microsoft office professional Purchase Abbyy Finereader 9 Pro Multilang Online microsoft office 2000 small business Microsoft Windows Vista Business With Sp2 (32bit) office downloads free microsoft office word Purchase Discounted Oem Autodesk Autocad Lt 2008 Online microsoft office 2007 open license media download Adobe Photoshop Cs5 With Imageready Cs5 buy microsoft office project professional 2007 sp2 for cheap Autocad Revit Structure Suite 2009 32 Bit Oem discount microsoft office for college students Solidworks 2009 Premium Sp4 (32-bit) trial microsoft word Dvd2one Oem microsoft publisher software Autodesk Autocad Revit Architecture 2009 microsoft office power point Visio Professional 2010 microsoft office templates Low Price Rosetta Stone Version 3 French All Levels Set cheap microsoft office from canada Adobe Indesign Cs5 For Mac 2007 microsoft office word product Cheap Oem Rosetta Stone Version 3 Chinese All Levels Set For Mac microsoft excel help Autopano Giga microsoft word 97 Best Buy For Adobe Cs4 Production Premium office microsoft word Microsoft Mappoint 2011 Europe free microsoft office lessons Grandreporter For Mac Oem how to make microsoft office ultimate 2007 genuine Autodesk 3ds Max 2011 Oem microsoft virtual office Futuredecks Pro Oem microsoft office professional edition 2003 cd Quark Xpress 6.5 Passport Multilanguage For Mac Oem buy cheap microsoft office project professional 2007 sp2 software Filemaker Pro 11 Advanced For Mac goffice vs microsoft office Adobe Creative Suite 3 Web Premium For Mac Oem microsoft office suite for sale Visio Professional 2010 Oem microsoft office education Adobe Technical Communication Suite 2 Oem microsoft office word excel software Office Home And Business 2010 32-bit microsoft office project professional 2007 sp2 download price: 9.90 Expression Web 2 Oem discount for microsoft office 2007 Discounted Oem Abbyy Finereader 9 Pro Multilang buy microsoft office professional Cheap Oem Abbyy Finereader 8 Pro Multilang microsoft office 2000 small business Download Abbyy Finereader 8 Pro Multilang office downloads free microsoft office word Purchase Cheap Oem Abbyy Finereader 9 Pro Multilang microsoft office 2007 open license media download Autocad Architecture 2008 buy microsoft office project professional 2007 sp2 for cheap Adobe Flash Professional Cs5 discount microsoft office for college students Adobe Photoshop Elements 9 For Mac Oem trial microsoft word Autocad 2008 microsoft publisher software Quickbooks Pro 2011 microsoft office power point Adobe Flash Professional Cs5.5 For Mac Student And Teacher Edition microsoft office templates Windows Server 2008 Datacenter 32bit cheap microsoft office from canada Cheap Adobe Creative Suite 3 Master Collection For Mac 2007 microsoft office word product Windows Vista Ultimate 64-bit microsoft excel help Download Oem Autodesk Autocad Lt 2008 Online microsoft word 97 Acronis True Image 11 Home office microsoft word Discounted Oem Rosetta Stone Version 3 English All Levels Set For Mac free microsoft office lessons Adobe Photoshop Lightroom Oem how to make microsoft office ultimate 2007 genuine Microsoft Office 2007 Home Student microsoft virtual office Adobe Creative Suite 5 Web Premium Oem microsoft office professional edition 2003 cd Download Adobe Cs4 Production Premium buy cheap microsoft office project professional 2007 sp2 software Adobe Creative Suite 5 Design Premium For Mac Student And Teacher Edition Oem goffice vs microsoft office Autodesk Autocad Electrical 2011 microsoft office suite for sale Get Discounted Oem Rosetta Stone Version 3 Chinese All Levels Set microsoft office education Autodesk Navisworks Review 2010 32 And 64 Bit microsoft office word excel software Rosettastone Swedish Level 1, 2 3 Set microsoft office project professional 2007 sp2 download price: 9.90 Download Oem Microsoft Windows 7 Online discount for microsoft office 2007 Microsoft Office 2010 Professional Plus (32-bit) buy microsoft office professional Get Oem Rosetta Stone Version 3 Arabic All Levels Set Online microsoft office 2000 small business Autocad 2006 office downloads free microsoft office word Download Microsoft Windows 7 Enterprise Online microsoft office 2007 open license media download Autodesk Navisworks Manage 2009 buy microsoft office project professional 2007 sp2 for cheap Digital Sentry Oem discount microsoft office for college students Autocad Mechanical 2011 trial microsoft word Filemaker Pro 9 Advanced For Mac Oem microsoft publisher software Adobe Flex Builder Professional 3 microsoft office power point Discounted Microsoft Windows Server 2008 microsoft office templates Autodesk 3ds Max Design 2011 Oem cheap microsoft office from canada Autopano Giga For Mac Oem 2007 microsoft office word product Microsoft Office 2008 Home Student Mac microsoft excel help Buy Microsoft Windows Vista Ultimate Online microsoft word 97

It’s a great opportunity to help spread PHP, meet open source guys or just hang out with other cool PHP guys. Already on the boat are Harry Fuecks (webtuesday organizer, local-hero and PHP-Book-Author), Lukas Smith (PHP Core Dev and Database Expert), Chregu Stocker (PHP Core Dev, liip CEO and Founder), Silvan Mühlemann (PHP-Evangelist, tilllate CTO and Founder) and, well, me.
(more…)

“unit testing is a test that validates that individual units of source code are working properly”, that’s what Wikipedia says about unit testing. That’s general knowledge.

But what motivates me even more than the increased software quality is that it saves me development time. This sounds odd as you might believe that TDD means writing more code.

Here’s a real-life example:
(more…)

We made it! Last Friday we have replaced the last two legacy components with their Zend Framework based counterpart: The gallery an the user registration. The whole site tilllate.com is now running on Trevi, our extension of Zend Framework. With a reach of 2.5 million unique clients a month, tilllate.com is one of the world’s biggest installation of Zend Framework.

Ciprian, Ivan, Jia-Yong, Kevin, Leo, Riv, Roger, Sanja, Thilo, Vanja, Vladimir and project manager Maarten have done a wonderful job reverse engineering the old, smelly spaghetti code and refactoring everything in a clean and solid MVC architecture: 115’480 Lines of code (Thanks StatSVN).
(more…)

For now over three years we are working with unit tests. I’d like to share some of those experiences.

As we have two frameworks in place for our website, I can compare two different strategies for unit tests.

In our homemade legacy framework we were using SimpleTest. Mainly because I read PHP|Architect’s Guide to PHP Design Patterns and Simpletest was Jason‘s framework of choice.

We have a cron job running which runs all tests every hour. The results of the tests are being shown on a page. The results are also displayed in Nagios.

(more…)

Last week, I was lucky to go to QCon 2008 in London to meet with all the big names in the software industry. This was a great opportunity to see what everyone’s working on and to get a feeling for the newest trends in software development. Here’s what my gut says about the world of software development after QCon 2008 (part 1):

(more…)

Trevi is not only a fountain in Italy, it’s our new application framework as well. We migrated our first pages to this new platform and brought them online three weeks ago. But let me explain the story of Trevi.

Another Framework?

There’re already thousands of web frameworks out there so I would sink into the ground if we really wrote another one. But serving pages for 2 million unique clients, it would also not have been a solution to just go to a shop and take the beautiful looking, nice boxed xyz framework from a big company. So my co-worker (and Trevi project lead) Maarten started a year ago to evaluate a framework that fits our needs best.
(more…)

On the view of your database the worst thing you can do in your web app is paging. Paging is horrible in the view of performance. To explain let me make a little example:

SELECT SQL_CALC_FOUND_ROWS gb.*,
 u.username,
        u.uid,
        u.geschlecht,
        u.mitfoto,
        [... some more fields...]
FROM member_gold_guestbook gb
LEFT JOIN users u ON u.uid=gb.uid_from
[... some more left joins...]
WHERE gb.uid_to='22152'
AND visible='1'
LIMIT 0,10;

That’s not that bad at all, but when you go to page 300 your database server will hate you for this. The database server has not only to calculate the 10 items you want to show but also all 3000 previous items.

Sure you may argue nobody will ever go to page 300. Somebody will not, but “googlebot” and his evil brothers will. And the bad thing is that you can do nothing against it, as long as you need paging. There are just a few tricks that may reduce your server load a bit.

(more…)

In many companies, management decides to setup a web proxy server to be able to control/disable the non-busines-related content. YouTube could probably be blamed for many hours spent doing non-business stuff.

Well, I use YouTube myself. Sometimes when taking a break and sometimes to listen to music that goes with the video, and you don’t have to watch it at all, but it’s probably the fastest way find and listen to a certain song if it’s available. Well, this time, YouTube will be a critical factor to finding the elegant solution.

(more…)

Consider you have a set of data that is changing dynamically for each page request and you need to cache that data the fastest way possible. You can’t cache dynamic and unpredictable data as a whole, can you? Hence, we would put each data entry into cache separately to be able to fetch it separately and dynamically. But this means bombing your cache infrastructure with with requests.

Caching Text Elements

Let’s get more concrete. To translate tilllate.com into all different languages, we use text elements (like gettext). For storage we are using MySQL and thus each text element is a row in the translation table. While this storage is very easy to maintain, it is quite silly to use in production, where you have ~100 text elements per page and peaks of 1500 page requests per second with a resulting 150’000 MySQL queries per second. Don’t even ask, we don’t do it. But even for a highly scalable memcached infrastructure, a 150’000 requests per second just isn’t easy to digest.

Let’s talk about a better solution. It consists of three concepts: Two-Tiered Caching, Incremental Caching and Cache Versioning.
(more…)

After a long day of meetings and other tedious manager work the perfect way to relax is to code. The best is a mini-projects where you see your results after an hour or so. I call these tasks “Plausch-Projekte” (“plah-oosh project” =”fun projects”).

This week my plah-oosh projects were two metric tools for Ganglia. Besides Nagios Ganglia is the main monitoring tool for our cluster. We monitor something like 20 metrics like load, memory, disk usage, network activity.

Ciprian and Stefan recently built a script to monitor apache (bytes/sec, hits/sec, idle processes etc.) via the /server-status interface. Based on their work I hacked two scripts:

ganglia_mysql_metrics.php monitors multiple mysql parameters like queries/sec, slow queries/sec, threads connected:

ganglia_squid_metrics.php reports regularly about squid metrics: Requests/sec, service time, available file descriptors:

The scripts are quick and dirty code. Procedural. Not well documented. Does only read the mcast_port from the config file and ignores the rest. But it might be a good base to be used on your cluster too. Just call them every minute via the crontab.