Make Your MySQL Tables Strict
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 strict, to ensure smooth...
mysql
A collection of 13 posts
Find Duplicate Input With MySQL
Back to basic, let's brush up on some SQL :) At my company we have employees creating customer accounts every day. Sometimes we make mistakes, for instance, we forget to check if...
Running Ruby on Rails on Nginx
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, only highlight 1 aspe...
Convert All Tables to InnoDB
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 that MyISAM is better...
Access MySQL Without Password
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
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 comes to backwards com...
Create Youtube-Like IDs With PHP/Python/Javascript/Java/SQL
IDs are often numbers. Unfortunately there are only 10 digits to work with, so if you have a lot of records, IDs tend to get very lengthy. For computers that's OK. But human beings...
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....
Boost MySQL Performance by 1200%
Sorry folks, this article was based on flawed benchmark results, I will soon post an update!
The Pragmatic SQL Style Guide
Code spends more time being read then being written. I think naturally this is true for queries as well. So it might help if we teach ourselves some guidelines as how to nicely for...
How Virtualization Will Improve Your Code
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 code. This has to do wit...
Enhance PHP Session Management
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 activity. Without session...
Survive Heavy Traffic With Your Webserver
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. But still it served p...