MonetDB and SQLWorkbench
Hi,
I have hacked SQLWorkbench to work with MonetDB.
SQLWorkbench is a detabase-independent GUI query tool, written in Java.
To support MonetDB in SQLWorkbench, a new entry needs to be added in DatabaseTemplates.xml, which is contained in sqlworkbench.jar.
This modifed files are available: http://www.uptime.jp/downloads/monetdb/SQLWorkbench/
It seems working well so far, and this patch is supposed to be contributed to the SQLWorkbench upstream.
If you are looking for a nice GUI tool to issue queries to MonetDB, take a look.
Regards,
Hi Satoshi
Thanks for this contribution. I'm sure it will find its way in the community.
regards, Martin
On 7/27/13 7:00 AM, Satoshi Nagayasu wrote:
Hi,
I have hacked SQLWorkbench to work with MonetDB.
SQLWorkbench is a detabase-independent GUI query tool, written in Java.
To support MonetDB in SQLWorkbench, a new entry needs to be added in DatabaseTemplates.xml, which is contained in sqlworkbench.jar.
This modifed files are available: http://www.uptime.jp/downloads/monetdb/SQLWorkbench/
It seems working well so far, and this patch is supposed to be contributed to the SQLWorkbench upstream.
If you are looking for a nice GUI tool to issue queries to MonetDB, take a look.
Regards,
Hi, Thanks for sharing. We use SQLWorkbench too. It works fairly well for us even without modifications. It works the best with the latest dev build. Before that there was an issue with displaying objects with underscore in the name. We use Workbench for: - developing procedures and functions from scripts - querying data - generating inserts for tables - inline data modifications from Database Explorer Could you please elaborate on the changes you made? Thank you, Radovan
On 07/27/2013 07:00 AM, Satoshi Nagayasu wrote:
Hi,
I have hacked SQLWorkbench to work with MonetDB.
SQLWorkbench is a detabase-independent GUI query tool, written in Java.
To support MonetDB in SQLWorkbench, a new entry needs to be added in DatabaseTemplates.xml, which is contained in sqlworkbench.jar.
This modifed files are available: http://www.uptime.jp/downloads/monetdb/SQLWorkbench/
It seems working well so far, and this patch is supposed to be contributed to the SQLWorkbench upstream.
If you are looking for a nice GUI tool to issue queries to MonetDB, take a look.
Regards,
Hi,
(2013/07/27 23:33), Radovan Bičiště wrote:
Hi, Thanks for sharing. We use SQLWorkbench too. It works fairly well for us even without modifications. It works the best with the latest dev build.
Thanks for the comment. I didn't know that SQLWorkbench can work with MonetDB without modification, and a SQLWorkbench guy told me the same on the sqlworkbench list.
https://groups.google.com/forum/#!topic/sql-workbench/JoPdcdsdl5g
Before that there was an issue with displaying objects with underscore in the name.
Thanks for the info. I had tried the latest stable release, so will check the dev build too.
We use Workbench for:
- developing procedures and functions from scripts
- querying data
- generating inserts for tables
- inline data modifications from Database Explorer
Could you please elaborate on the changes you made?
Well, I just added an entry for MonetDB in DatabaseTemplates.xml in the sqlworkbench.jar. Then, I can choose MonetDB in the pull-down menu on the connection dialog.
Regards,
participants (3)
-
Martin Kersten
-
Radovan Bičiště
-
Satoshi Nagayasu