Tag: SQLITE

A while back, Jason mentioned giving your Firefox performance a boost by limiting the length of time items are saved in history. At Mozilla Links, they've shared another handy tip from Mozilla developer Jeremy Orem. His advice: take a vacuum to your SQLite databases. Here's how to do it: Open the Firefox tools menu and click on error console. Paste the following command into the code ...

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 ...

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. Quit Mail (if it's open) Open Terminal (in /Applications/Utilities) At the shell prompt, type: sqlite3 ~/Library/Mail/Envelope\ Index and press ...