Using Firebug

March 20, 2011

JavaScript is easy to write, but can be difficult to debug effectively due to the limited debugging functionality it provides. One big difficulty is the lack of an effective way to display debugging messages. You can overcome these limitations with the help of external debuggers. If you are developing JavaScript code for the Firefox browser, [...]

Read More

Null, Undefined and Delete

March 19, 2011

Unlike most other programming languages, you can use both undefined and null values in JavaScript. This can be confusing for someone who comes to JavaScript from another programming language. When an object is undefined, it means that it has still to be declared or has been declared and not given a value. Null is a [...]

Read More

Assertion

March 19, 2011

Assertion is one of the common techniques that people use to debug JavaScript code. You use assertion to ensure that an expression evaluates to true during script execution. This means that if any expression evaluates to false there is possibly a bug in your code. There is no inbuilt assert function in JavaScript, but it [...]

Read More

Joining Strings Together

March 19, 2011

It is common to wish to join several smaller strings together into a large string. The obvious way to do this is with a string concatenation operation, but in JavaScript this can have a bad affect on performance. This is because the string concatenation operations can produce too many intermediate strings, which will make it [...]

Read More

MySQL Tips and Tricks

March 16, 2011

The most popular open-source database engine in the world, MySQL is a powerful database engine that is known for its high performance, reliability and ease of use. Many large internet companies use MySQL to power their databases and applications based on the LAMP stack (Linux, Apache, MySQL, PHP/Perl/Python). MySQL is platform independent and runs on [...]

Read More

Remove Obsolete Privileges

March 15, 2011

Security is an important consideration for any computer systems and MySQL is no exception to this rule. One big security problem that administrators can often overlook is obsolete accounts. These accounts were created for people who no longer use them and are big security holes just waiting to be found. The user table stores user [...]

Read More

Control remote access

March 14, 2011

On a standard MySQL installation, remote access is disabled by default. This is great if you are sat next to your server, but inconvenient if you are not. With the advent of modern support teams spanning the globe, it is entirely possible to administer a server that is in a different country or continent and [...]

Read More