1. Open the Firefox tools menu and click on error console.
2. Paste the following command into the code box as a single line (as pictured):
   Components.classes["@mozilla.org/browser/nav-history-service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL("VACUUM");
3. Hit [enter] or click the evaluate button.

As we reported earlier today, switching gears from alpha into beta, Adobe has revealed Apollo's true name, AIR. Short for Adobe Integrated Runtime, the framework remains largely the same but gains some new functionality under the hood. Expect to find embedded SQLite support, WebKit HTML rendering, drag & drop support, support for PDF and general improvements to window management and networking.

So what's in it for users? Sure, its got some great functionality geared towards web developers, but what's the use unless there are some real useful applications for AIR? I did some digging around and have found 3 AIR apps that I think have some usefulness, and show some promise for AIR. If anything, by the end of this article you'll get tired of reading the acronym AIR.

Salsa - A simple Amazon S3 client
Salsa is a super simple client to copy files between Amazon S3 and your computer. It's just a simple uploading and downloading interface, that's all. Amazon S3 has been called a cost-effective backup solution, and this app could make that practical on a desktop level. Salsa is considered 'alpha' quality, but if I needed a simple, secure method for backing up files I can see its value. Salsa is available on the Adobe Labs AIR:Applications:Samples wiki page. It would be great to see this little app mature a bit and move beyond the lab.

Tweetr - Twitter client
Yeah, we love Twitter around here at DLS, it's a little shameless. There's no shortage of ways to go about tweeting, and Tweetr is a nicely done implementation in AIR. The interface reminds me of a little bit iChat, a little bit Twitterrific. While not perfect, it's lightweight and does a fine job. I like how you can view your replies and direct messages as well. Check it out at http://www.tweet-r.com.

Fresh - RSS feed reader
Another one straight outta Adobe Labs is Fresh, a straightforward feed reader app. What I like about Fresh is that it's pretty full featured for only being a sample: OPML import/export, tabbed interface, integrated web view for stories, themes and more. Obviously an application like this isn't very innovative or groundbreaking, but it's a good demonstration of AIR's abilities: structured content, feed retrieval, ui elements, and HTML rendering. Check it out on the Adobe Labs AIR:Applications:Samples wiki page.

If you'd like to keep an eye on upcoming AIR applications, here's some good sites to keep your browser or feed reader pointed at:

• AIRApps.net
• Mike Chambers' Blog
• Adobe Labs Wiki: AIR

Not with a real vacuum, silly, but with SQLite's vacuum command! If you fancy yourself a bit of Terminal adventure, this simple command can supposedly increase Mail's responsiveness. Especially helpful if you have a hefty mailbox like I do.

1. Quit Mail (if it's open)
2. Open Terminal (in /Applications/Utilities)
3. At the shell prompt, type: sqlite3 ~/Library/Mail/Envelope\ Index and press Enter.

You'll be greeted with:

SQLite version 3.1.3
Enter ".help" for insructions
sqlite>

4. At the sqlite> prompt type: vacuum subjects; and press Enter.
There will be a short delay while sqlite optimizes the subjects table, depending on how large your mailbox is this could take anywhere from 30 seconds to 5 minutes or more.
5. Once you're returned to the sqlite> prompt, press Control-D to exit.
6. Restart Mail and enjoy your newfound speediness!

Please be aware that you do this at your own risk. There's a potential for data loss, so if you want to be extra cautious backup the ~/Library/Mail/Envelope Index file before attempting this trick.

[via Hackszine.com]