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 IN(…) statements

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 . . . →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 . . . →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 latest package definitions] fink apropos . . . →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 symfony‘s debug-toolbar

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 . . . →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 . . . →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

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 “classical”behavior

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna,tincidunt vitae molestie nec,molestie at mi. Nulla nulla lorem,suscipit in posuere in,interdum non magna.