Categories: "Full Stack Dev & Design"

How to check what MySQL version I am using?

In order to determine which MySQL version you're running you can type the following command: mysql -V

Sample results:

# mysql -V
mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)

# mysql -V
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2

Now, if you want to query for the version number while beign logged in (PHP script for example), just go with: SELECT VERSION(); .

I believe this is only working since MySQL 4 though.

Easy web snapshots

I think the easiest site for making quick web snapshots is thumbalizr ...

Mac OS vs Windows font rendering

I want to recommend this post by Joel Spolski about differences in font rendering philosophy between Mac OS & Windows.

I never really understood why Apple failed to render sharp fonts on screen. Now I understand the purpose. I'm still not sure which is best though... ;)

About the PHP 5 migration chicken & egg issue

It's been 3 years since PHP 5 has been released. Yet PHP 4 still rules on the vast majority of web hosting platforms.

This is annoying for PHP open source developers who cannot leverage the potential of PHP 5 as long as they need to support PHP 4. This is also annoying for the PHP development group since they still need to support PHP 4 instead of focusing on PHP 6.

In a way it is also annoying for the web hosts themselves, since they too need to deal with clients who want PHP4 compatibility and others who want PHP5 features.

What strikes me is that the solution seems obvious, and yet the PHP team fails to recognize it.

The only reason webhosting providers haven't massively upgraded to PHP 5 yet is because it would break applications running on their current client's site. It may also prevent new clients from installing well known applications (phpBB...) which may fail on PHP5.

Of course, that would not have been such an issue if PHP5 was indeed upward compatible with PHP4. But it isn't! (object references, clone keyword, etc.) So what do we do now?

Web hosts install PHP5 next to PHP4, but you need to rename your scripts to script.php5 instead of script.php ... which breaks existing URLs... so no-one uses that either.

The real simple solution would be for the PHP team to release some PHP 5.x version which would actually behave like PHP 4 (completely!) with a simple config switch. It could then be installed in place of PHP 4 without breaking anything.

Once that is done, any PHP application that is PHP5 aware would just include something like this:

PHP

ini_set'compatibility''5' );

and everything would be fine.

Maybe PHP5 should have 2 separate php.ini files. Maybe that ini_set() call should be required to come at the very top of the script. Maybe it should be a different function. But all in all, the solution seems so simple you have to wonder why anyone would want to support the older version for 3 years instead...

Still dreaming about the ideal FTP tool

Besides the basics, there's three simple things I'd expect from an FTP client:

  1. Symetrically navigate in subfolders locally and remotely with single clicks;
  2. Upload files and overwrite the server side only if the local file is newer;
  3. Search the server for old files that no longer exist locally (with an option to ignore folders that contain user uploaded content).

I have never ever found a Windows tool doing all 3 ! :'(

  • CuteFTP 8 Pro does #1 and that's about it (Its folder sync tools are basically a joke : it compares dates without comparing times!)
  • FileZilla 2.32 does #2 but that's about it.
  • My old DreamWeaver MX does #3 but is so painfully slow that it's barely bearable!

I'm so impatient to see FileZilla 3 as well as the new DreamWeaver CS3... but I fear I'm gonna be disappointed again... :-/

Maybe I should start to figure out how to run rsync on Windows right now... |-|