Needed: An OSX SQL tool
I am constantly tortured by the lack of a good SQL Query tool in OSX. I've tried them all, and always download and try the latest version of each program that comes out. It just seems to me that they all miss the point. Each new program comes with bells and whistles for creating databases, working with user permissions, etc.
But the truth is, if you're a SQL Developer, what do you spend most of your time doing? Writing SQL code, testing it go see if you get correct results, optimizing it so it runs quickly and efficiently. To do that, you need a good large editing space, the ability to select specific text in a query space and run just the selected query, a separate display of results sets, and a way to save queries and result sets. Color coding is nice, but I'm a very experienced SQL developer so I don't need any kind of drag and drop tool for building queries.
I know of no Mac program that gives me a good editing space for queries, and lets me select and run only portions of the text in that space. Of all the tools I've used, the best is still SQLYog, an inexpensive tool for Windows. It gets almost everything right. The new SQLYog Enterprise is a great piece of software. The developer still promises a Mac version, but there's no sign of it yet.
Truthfully, this is about the only thing that keeps me from switching 100% to the Mac for my work, and it's darned frustrating.
10:07:49 AM Permalink
|
|
