PHP DEVELOPERS

First TYPO3 Conference in Asia

From 17 to 19 August 2012, the first TYPO3 Conference in Asia will take place in Phnom Penh, capital of Cambodia: T3CON12 ASIA!

Browser stats for January

It’s time for the browser stats for January; as always according to StatCounter.

Your donation for keeping this series up and running would be much appreciated.

Benchmarking MariaDB-5.3.4

Last weekend Vadim from Percona published his MariaDB 5.3.4 benchmark results. As the new benchmark guy at Monty Program I take this oportunity to add some more results of my own. One question in the comments to Vadim was if it is fair to compare MariaDB-5.3 with MySQL-5.5. Or if this comparison should be done with MySQL-5.1. The answer is: it does not matter much. MySQL-5.5 and MySQL-5.1 show very similar results in the Sysbench OLTP benchmark. So I created a Sysbench environment pretty much like…

PDO vs. MySQLi: Which Should You Use?

When accessing a database in PHP, we have two choices: MySQLi and PDO. So what should you know before choosing one? The differences, database support, stability, and performance concerns will be outlined in this article. Summary PDO MySQLi Database support 12 different drivers MySQL only API OOP OOP + procedural Connection Easy Easy Named parameters Yes No Object mapping Yes Yes Prepared statements (client side) Yes No Performance Fast Fast Stored procedures Yes Yes Connection It’s a cinch…

CakePHP 2.1 Release Candidate is out

The first, and hopefully only, release candidate for CakePHP 2.1 was released. If you have an application running on 2.0 or planning to migrate, this is the best moment to start checking this version out!

How to recover deleted rows from an InnoDB Tablespace

In my previous post I explained how it could be possible to recover, on some specific cases, a single table from a full backup in order to save time and make the recovery process more straightforward. Now the scenario is worse because we don’t have a backup or the backup restore process doesn’t work. How can I recover deleted rows? We’re going to follow the same example as in my previous post so we need to delete the records of the employee 10008 from the table “salaries”.…

How to convert MySQL’s SHOW PROFILES into a real profile

SHOW PROFILES shows how much time MySQL spends in various phases of query execution, but it isn’t a full-featured profile. By that, I mean that it doesn’t show similar phases aggregated together, doesn’t sort them by worst-first, and doesn’t show the relative amount of time consumed. I’ll profile the “nicer_but_slower_film_list” included with the Sakila sample database to demonstrate: mysql> SET profiling=1; mysql> pager cat > /dev/null mysql> SELECT * FROM…

SQLyog Query Profiler re-invented.

Baron Schwartz from Percona has  just re-invented the SQLyog Query Profiler. Refer: http://www.mysqlperformanceblog.com/2012/02/20/how-to-convert-show-profiles-into-a-real-profile/ The SQLyog Query Profiler was introduced in SQLyog 8.o in February 2009 – exactly 3 years ago. The funny thing is actually that Baron Schwartz reviewed it before release (at friendly commercial terms) at the time. The SUM-aggregation and the ORDERING that we did (and it was solely our decision – not Baron’s…

The iPhone monoculture

This is getting frustrating. The official CSS WG blog: Discussed problem of WebKit monopoly on mobile and the consequent pressure for other engines to implement -webkit- properties. Zeldman: Webkit monoculture: threat or menace? Guys, stop it. This is simplistic us vs. them thinking. It’s not helpful. Now if you would say there’s an iPhone monoculture among web developers, you’d be right. But whose fault is that?

Hidden Pics: My first App on Windows Phone marketplace

My first app on Windows Phone marketplace