mysql

Make Your MySQL Tables Strict

1 minute read

When you're upgrading to MySQL 5.6 you may notice strict mode is turned on by default. You can disable it, but now might be a good time to get your schemas s...

Running Ruby on Rails on Nginx

3 minute read

If you want to set up Ruby on Rails on Ubuntu Lucid from scratch, there are quite some articles online to choose from. I found most of them involve compiling...

Convert All Tables to InnoDB

2 minute read

Some time ago I was in the situation where I was looking at 200 MyISAM tables screaming to get converted to InnoDB for performance reasons. You probably know...

Access MySQL Without Password

less than 1 minute read

If you want to do command-line MySQL administration like restoring databases or dumping statistics, you need the root account and it's password. Or do you?

Prepare for PHP 5.3

4 minute read

PHP 5.3 is a big leap forward for PHP and brings of a lot of neat features. However, big leaps can also mean big changes and potentially big breakage when it...

Improve MySQL Insert Performance

11 minute read

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 / s...

SQL Formatting

4 minute read

With all the abstraction layers between code & database, the need for writing SQL statements deminishes. But over the years I've developed my own way of ...

How Virtualization Will Improve Your Code

11 minute read

Good testing will result in better code. If you have to wait endlessly for on SVN commits, uploads or compile steps, you will simply produce less inventive c...

Enhance PHP Session Management

6 minute read

In PHP, sessions can keep track of authenticated in users. They are an essential building block in today's websites with big communities and a lot of user ac...

Survive Heavy Traffic With Your Webserver

7 minute read

Recently two of my articles reached the Digg frontpage at the same day. My web server isn't state of the art and it had to handle gigantic amounts of traffic...