specializing in digital media technologies

I’ve just recently come across a piece of software called Jet Profiler for MySQL. This is a program that runs on Mac OS X, Linux, and Windows (it’s runs on Java), and comes in both a free and commercial version. Jet Profiler for MySQL is a diagnostic tool, used to analyze and report upon your database’s performance, specifically in terms of the queries run, the tables used, and the MySQL users. It also has more advanced capabilities, like reporting upon master/slave relationships, locking, threads, and so forth. One particularly interesting feature is that it doesn’t require any special server configuration; in fact, it doesn’t even need to be installed on the server. You can install the application on your desktop computer, create a new MySQL user on the server, and the software will connect through it. Software like this is another good way to better understand your database and your Web application.

The other three posts in my Five JavaScript Tips in Five Days series for Peachpit Press have now been posted. The full set is:

• Handling JSON Data Securely
• Debugging XML/JSON Requests
• Choosing a JavaScript Framework
• Performing Cross-Domain Ajax Requests
• Loading JavaScript Faster

If you’ve been reading my jQuery series of posts sequentially, then you saw how to incorporate jQuery into an HTML page, learned how to select elements so that you can use or manipulate them, grasped how to add event handlers, and saw some of the effects that can easily be applied. In this post, I discuss other ways you can manipulate document elements: by altering their CSS, changing their values and attributes, and by adding or removing elements. Although these techniques have an affect on the visual page, I’ve grouped them together here (separate from the effects post) as they’re all primarily about delivering content. (continue reading…)