Archive

SQL Formatting

With all the abstraction layers between code & database, and now with my recent CakePHP adventures: The need for writing SQL statements deminishes. But over the years I've developed my own way of formatting them. And before I'll have to wave queries goodbye forever ;) I just want to put it out there.

Javascript equivalent for PHP's timezone_identifiers_list

This is a Javascript version of the PHP function: timezone_identifiers_list.

Javascript equivalent for PHP's date_default_timezone_get

This is a Javascript version of the PHP function: date_default_timezone_get.

Javascript equivalent for PHP's date_default_timezone_set

This is a Javascript version of the PHP function: date_default_timezone_set.

Javascript equivalent for PHP's gmdate

This is a Javascript version of the PHP function: gmdate.

Javascript equivalent for PHP's localtime

This is a Javascript version of the PHP function: localtime.

Javascript equivalent for PHP's strftime

This is a Javascript version of the PHP function: strftime.

Javascript equivalent for PHP's getenv

This is a Javascript version of the PHP function: getenv.

Javascript equivalent for PHP's putenv

This is a Javascript version of the PHP function: putenv.

Javascript equivalent for PHP's setlocale

This is a Javascript version of the PHP function: setlocale.

Boost MySQL Performance by 1200%

Sorry folks, this article was based on flawed benchmark results, I will soon post an update!

Improve MySQL Insert Performance

Sometimes MySQL needs to work hard. I've been working on an import script that fires a lot of INSERTs. Normally our database server handles 1,000 inserts / sec. That wasn't enough. So I went looking for methods to improve the speed of MySQL inserts and was finally able to increase this number to 28,000 inserts per second. Checkout my late night benchmarking adventures.