Move to GitHub

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 . . . → Read More: Move to GitHub

GSoC is about to start

Google announced the list of students, they will be sponsoring this summer to work on open-source projects. My congratulations to everyone, who succeeded. . . . → Read More: GSoC is about to start

PDO gets official support from MySQL AB

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 budget . . . → Read More: PDO gets official support from MySQL AB

mysql-query-builder 1.0.2

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 . . . → Read More: mysql-query-builder 1.0.2

lighttpd package in fink

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 get . . . → Read More: lighttpd package in fink

MySQL AB :: Using the New MySQL Query Profiler

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 . . . → Read More: MySQL AB :: Using the New MySQL Query Profiler

prepared statements vs the query cache.

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 emulation

Patch . . . → Read More: prepared statements vs the query cache.

Sun Optimized AMP Stack for the Solaris 10 OS

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 with . . . → Read More: Sun Optimized AMP Stack for the Solaris 10 OS

mysql bug

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 . . . → Read More: mysql bug

MySQL console and utf-8

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 . . . → Read More: MySQL console and utf-8