News for hackers. Stuff that matters.
Re:Open Source SQL Editors by bsg75 on Monday January 28, 2013 @11:59AM (#5129305)
Also not open source, DbVisualizer (http://www.dbvis.com) has been my primary SQL editor / query tool since moving off Windows as my desktop.

There is a free version, but the paid version has some nice basic charting, and recently a decent explain plan visualizer.

Many of the f/oss SQL tools are coming along, but lack some of the features that the Windows/BI world is accustomed to.

Edit: Link spelling

Re:Open Source SQL Editors by mynegation on Monday January 28, 2013 @12:31PM (#5129461)
Correct link is http://www.dbvis.com/
Re:Open Source SQL Editors by don_draper on Monday January 28, 2013 @01:23PM (#5129786)
This is one of the few dev tools I pay for.
Re:Open Source SQL Editors by Dillie-O on Monday January 28, 2013 @09:42AM (#5128647)
While they're not open source, I've been EXTREMELY happy with the freeware versions of the TOAD tools that Quest has had out for quite a while now. They have specific versions for each of the major platforms, and the only purchasing the pro versions gives you some advanced import/export functionality, but nothing I haven't been able to accomplish through other means.

http://toadworld.com/

Re:Open Source SQL Editors by mmsimanga on Monday January 28, 2013 @09:53AM (#5128680)
I do like the freeware version of Toad for MySQL from Quest. I have used it quite extensively in the past. Lately though HeidiSQL -http://www.heidisql.com/ has gotten so good I have had no need for the Quest MySQL software.
Re:Open Source SQL Editors by jcoby on Monday January 28, 2013 @12:13PM (#5129368)
On MacOS/MySQL I use Sequel Pro (http://www.sequelpro.com). Stable development is a little slow but the nightlies are fairly stable.

I really wish I could find something like Sequel Pro that worked with PostgreSQL. PgAdmin III is.. functional but weird.

I've been tempted to add support to Sequel Pro myself but I don't know much about ObjC.

Re:Open Source SQL Editors by bsg75 on Monday January 28, 2013 @12:36PM (#5129497)
Re:Open Source SQL Editors by narcissus on Monday January 28, 2013 @09:59AM (#5128706)
Heidi SQL was mentioned in passing in the article, but I wanted to "+1" it. Admittedly it's only MySQL (with some level of MSSQL support now... not sure what that level is) but I do like that it runs fine in Wine and it has a lovely 'find text across server' feature that let's you dig into any database / table that you have access to.
Re:Open Source SQL Editors by mmsimanga on Monday January 28, 2013 @01:38PM (#5129879)
+1 for HeidiSQL! Its a nifty little program and does not hog system resources.
Re:Open Source SQL Editors by axisK on Monday January 28, 2013 @10:55AM (#5128970)
I love squirrel, if anyone is trying it out though just be aware of the default 100 or 1000 row limit. It's great for select statements but don't forget to disable it when running updates on a dataset.
Re:Open Source SQL Editors by zeruch on Monday January 28, 2013 @12:19PM (#5129404)
Sequel Pro, the MySQL Workbench, and on Windows, I'm partial to HeidiSQL (oddly, its FOSS, but hasn't been ported to anything other than Windows)
Re:Open Source SQL Editors by dguaraglia on Tuesday January 29, 2013 @01:05PM (#5135292)
It's not that weird, considering the program was apparently written in Delphi. There were some efforts to port Delphi to Linux a few years ago (Kylix) and the Lazarus project provides a portable runtime of something resembling Delphi, but still lightyears away from providing code compatibility.

Kind of a shame though, as it looks like a really nice program.

Re:Open Source SQL Editors by narcissus on Tuesday January 29, 2013 @06:42PM (#5137160)
For what it's worth HeidiSQL runs just fine in Wine. There are a handful of small visual glitches but none big enough to bother me at least. Give it a go.
Re:Open Source SQL Editors by saosebastiao on Monday January 28, 2013 @12:15PM (#5129385)
Does anybody know of any pure command-line multi-platform clients?