Alexey Zakhlestins blog

Just notifying all interested parties, that my “Application Server in PHP” and “MySQL Query Builder” projects are moved to GitHub.
Their new homes are:

Application Server in PHP
MySQL Query Builder

p.s. newest release of MySQL Query Builder has support for subqueries in IN(…) statements

Google announced the list of students, they will be sponsoring this summer to work on open-source projects. My congratulations to everyone, who succeeded.

Lukas Kahwe Smith just posted the following to php.internals mailing list:

Ok, it seems that MySQL AB is finally committing to fix up PDO_MySQL and to generally accept the fact that PDO is the future. Of course mysqli will also be actively maintained. But they will also make mysqlnd play nicely with PDO etc.
They have a [...]

I have released mysql-query-builder 1.0.2. Still lacks formal documentation, but 100% covered by unit-tests which can be treated as such.
MySQL Query Builder is a set of PHP5 Classes which can… (surprise!) build correct MySQL5 queries for use with PDO’s prepare/execute. This things rocks really hard if you need to implement some kind of database layer [...]

I have my first package officially included in fink-unstable, today: lighttpd 1.4.13 (it might take several hours before this link will have information).
Feel free to test it and drop a comment to me
If you are using unstable distribution, it should be as easy as:

fink selfupdate [to [...]

Robin Schumacher wrote an article about the new feature of MySQL 5.0.37: Using the New MySQL Query Profiler
this is definitely something worth reading and using. I wonder, if such thing could be integrated in symfony’s debug-toolbar

Konstantin Osipov of MySQL mentioned in his blog, that there is patch submitted, which allows using Query Cache simulateously with Prepared Statements. I believe a lot of us were waiting for this quite a long time.
This means, that we would be able to use native mysql’s prepared statements without speed penalty and switch off the [...]

Sun Optimized AMP Stack for the Solaris 10 OS .
Sun offers a new recipe for success — the Solaris OS + AMP (Solaris 10 OS, Apache, MySQL, and PHP). For customers committed to the open AMP stack, this “recipe” provides the same Web applications they know and use, but on a more secure open-source platform [...]

MySQL is a very strange database. That’s why it has such strange bugs
It does support cross-database delete, but only if you do not specify aliases for tables. Unfortunately, there are situations, when aliases are vital

MySQL console has a long history of not properly counting column-widths for multibyte data. This was fixed in 4.1.12/5.0.25
Although, with a little catch. You have to start mysql console with “–default-character-set=utf8″ key or it will fall back to it’s “classical” behavior