When Apple announced the release of it’s latest OS X variant (OS X Lion) one it’s flag ship features was the ‘launchpad’. Providing mac users with a ‘pad’ similar to the screens found on their other iOS devices, where all installed applications can be organised into ‘pages’ and folders, much like the iPhone and iPad interfaces.
Well this new feature clearly was enough for the avid developers over at Infinite Loop, as the launchpad also hides a little secret/easter egg. With the launchpad … erm … launched, press and hold the applecmd key on your keyboard and press the ‘b’ button to cycle through various variations on your desktop wallpaper..
In a recent blog post I detailed how to use advanced SQL statements to remove applications for OS X Lion’s Launchpad. Which works well, however it can be a little frustrating if you’re constantly wanting to adjust Launchpad’s contents.
Luckily for us Lion users Andreas Ganske over at chaosspace.de has come up with a solution!
Launchpad-Control is a simple straightforward tool that enables you to hide/unhide applications at the click of a button!
It’s a system preference pane (update #1)
Displays a table with all apps that are in Launchpad
Checkboxes for every app allow you to easily specify apps you want to hide or show
Backups/Restores your original database file
It’s completely free!
You can download Launchpad-Control from chaosspace.de or by clicking here
Launchpad-Control requires OS X Lion (obviously)
Frustratingly the current implementation of the ‘LaunchPad’ in OS X Lion (10.7) seems to have one or two fairly major pit falls. One of which really frustrated me until now. On day of released I downloaded and installed Parallels Desktop 6, which the LaunchPad decided it would try and help and ‘dump’ all of the Windows App’s in the LaunchPad. Which would have been fine, however after I removed Parallels Desktop 6 trial all the Windows app’s where left orphaned on the LaunchPad.
Now users of the LaunchPad will already be aware that removing apps from LaunchPad isn’t easy unless the apps where installed via the AppStore.
But – if you are willing to dip your toe’s in SQL water you can remove the apps ‘manually’
First of all you will need a good SQL database editor. I have been using SQLite Database Browser for my iPhone app development. So grab a copy of that – and pull up your socks!
For the next part, you will either need to unhide the hidden folders and files, or open finder and use the ‘Go To Folder’ menu option to launch the hidden Library folder..
Once inside the folder locate the ‘Application Support’ folder, then inside there the ‘Dock’ folder. You should see a file with a pretty random name, and a .db extension. Create a backup of this file and copy the file into another folder such as you desktop, or your documents.
Now, launch the SQLite Database Browser you downloaded earlier, and open the .DB file from your documents folder.
The database contains a collection of tables, the important one we will be working with are:
Items – Each item on the LaunchPad is listed in this table
Apps – Each application(parent) is listed in this table
Now, click on the ‘Browse Data’ button and change the table name to ‘apps’. Navigate down the table and find the title of the application you would like to remove from the LaunchPad, once you have found it make a note of the value in the ‘bundleid’.
Now, select the Execute SQL button and copy and paste the SQL below into the window.
DELETE FROM items WHERE rowid IN (SELECT item_id FROM apps WHERE bundleid LIKE ‘bundleidhere‘);
DELETE FROM apps WHERE bundleid LIKE ‘bundleidhere‘;
Replace the green bundleidhere text in the pasted code with the value you made a note of earlier. So for my example I wanted to get rid of anything Parallels had left behind, so my SQL code looks like:
You may notice the % symbol in my code, this essential means remove an apps who’s bundleid starts with com.parallels.winapp – which captures all of the Parallels apps.
Once you have made the required changes, click the ‘Execute Query’ button. If all is well the ‘error message’ filed should read ‘No Error’. Now you can press on the Save button and close down the SQLite app.
Copy the .db file back into it’s original location (~/Library/Application Support/Dock), making sure you keep a copy of the original, just in case.
You will now need to relaunch the Dock in order for the changes to take effect. You can do this by either logging off and back on again, rebooting, force quitting or using the killall dock command in the terminal.
That’s it.. All being well your LaunchPad should now be free of the offending applications! Hopefully in the next OS X update this issue will be addressed and will be slightly more straightforward.