graphical JDBC Clients

jdbc_clients.rst

SQuirreL SQL

• URL: http://www.squirrelsql.org
• Open Source
• Plugins - maybe develop a crate plugin for better support?
• currently developed

SQL Workbench

• URL: http://www.sql-workbench.net
• last build 04.2014
• issues when querying data: `Connection: createStatement(int resultSetType, int resultSetConcurrency) not supported`
• database browser works, even basic `CREATE TABLE` works

RazorSQL

• URL: http://www.razorsql.com/
• 30 Days Trial, otherwise 100 - 90 $ per user
• best experience, displays most columns correctly and has lots of features, simply select crate-jdbc jar and there you go

DbVisualizer Free/Pro

• URL: http://www.dbvis.com/
• Free version is free
• quite good experience
• Configure additional driver at `Tools / Driver Manager` and add a new driver from jar file.
• seems not to accept the `jdbc:crate://... syntax, but `crate://... works fine.
• editing only via SQL Commander / SQL editor