Unlike most other programming languages, you can use both undefined and null values in JavaScript. This can confuse someone who comes to JavaScript from another programming language. When an object is undefined, it means that it still has to be declared or has been declared and not given a value. Null is a special value…
Assertion is a technique you can 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 is simple to…
It is common to want to join several smaller strings into a large string. The obvious way to do this is with a string concatenation operation, but in JavaScript, this can have a negative effect on performance. This is because the string concatenation operations can produce too many intermediate strings, making it perform poorly. As…
The most popular open-source database engine in the world, MySQL is a powerful database engine 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 more than 20…
Security is an essential consideration for any computer system 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 waiting to be found. The user table stores user accounts,…
On a standard MySQL installation, remote access is disabled by default. This is great if you are sitting next to your server but generally 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…
It does not matter what data is stored in your database, you want to prevent unauthorized access. If the data is not secure, then anyone with the time and motivation can potentially access it over the internet. Once they are in your database, they can take all your data or delete it if they want….
It does not matter how well you can write queries in MySQL; if the underlying schema is not optimized, it will slow your database performance down. This is not just removing unwanted fields, but you need to make sure that your fields are storing data with the correct size. One example of this is a…
One of the big deciding factors in the performance of your database is the design of the database. Research from various parties, including Oracle, has found that poor database design is a major factor in poor database performance and unscheduled system downtime. One great way to improve the performance of your MySQL database is to…
Even the best MySQL implementation will sometimes have problems with processes taking too long and hogging the CPU and memory. This will have a knock-on effect on any other processes running on the server and can have a significant effect on performance. In an ideal world, you could just increase the resources available to the…
