Generally these days I’m tending to access mysql from the CLI but when writing a data importer script I needed to be able to see what tables I was accessing from two different dbs. Initially I was looking for an ERD tool but I stumbled across the successor to CocoaMysql, Sequel Pro. It’s both well executed and free which makes it my kind of app!
Here’s a post I wrote over on the Project Fondue Blog about our use of Loggerhead with mod_wsgi under Apache. Loggerhead is the rather nice branch viewer for bazaar branches as used on Launchpad.net.
If you’re not already subscribed to the Project Fondue blog feed then I can recommend it, as there should be some interesting posts coming out of there in the coming months (yes I’m unashamedly biased!).
I found the changing with the workspace with the mouse wheel really annoying. To disable it go to System => Preferences => CompizConfig (available if the compizconfig-settings-manager package is installed) and uncheck “Viewport Switcher” which is under the “Desktop” heading.
© Copyright 2004-10 Stuart Colville, all rights reserved. May contain traces of Muffin. Powered by WordPress. Hosting by Slicehost.com This page was baked in 0.736s.
I’ve also been using Sequel Pro for the last month or so. Apart from the occasional UI glitch whereby the main ‘content’ pane gets messed up until you flick to another tab and back, it’s been working very nicely.
My favourite feature (which wasn’t in the version of CocoaMysql I was using) is Copy Create Table Syntax from the Table menu. This generates the SQL CREATE TABLE statement required to create that table on another copy of the database, and puts it on your clipboard.
have you found an ERD tool btw.?
@matths: No kind of got side-tracked there on that one. Any suggestions, or are you looking for one as well?
Anyone have experience connecting Sequel Pro to a DB on Slicehost?
@jojo: The way to do this is to tunnel the connection via ssh.
See: http://www.whoopis.com/howtos/mysql_ssh_howto.html when the tunnel is up and running you can just connect sequel pro to the local end of the tunnel.