SQL Workbench is an SQL query tool clearly built by engineers for engineers. The kind of attention these developers obviously pay to both feature design and details is really an example how professional tools should be built.
To begin with, it does not assume much about the environment. It is a Java application so it runs on most desktop operating systems and it uses JDBC to access databases, so it can work with basically any RDBMS out there. This means that you can derive value from its use in a wider set of use cases and that you don’t have to learn to use another tool to get the job done on another database.
While it is not FOSS, it does support some of the basic freedoms: the rights to distribute and use the software in any way (other than to sell it, apparently). Unfortunately, this does not include the right to modify it and it is a bit of a mystery why. I would very much like to see it released under GPLv3 or a similar licence and who knows? We might get to see the day…
It seems appropriate to start a review of an SQL query tool from its SQL handling capabilities. (više…)