Best SQL browser for HSQLDB?

Question

Whats the best browser tool for HSQLDB databases?

There is no "the best" tool. Look for one, that fullfills most of your requirements. — Andreas Dolk, Feb 14 '11 at 10:13
Execute Query is pretty good also http://executequery.org/screenshots — Răzvan Flavius Panda, Dec 25 '13 at 06:57
This question has moved to http://softwarerecs.stackexchange.com/questions/7440/fast-to-set-up-hsqldb-database-management-gui — Nicolas Raoul, Jul 02 '14 at 03:50

score 78 · Accepted Answer · edited Feb 09 '17 at 10:35

78

HSQL has built-in GUI query tool called Database manager. In the directory of the database files run:

java -cp ../lib/hsqldb.jar org.hsqldb.util.DatabaseManager

and then setting the config to:

jdbc:hsqldb:file:databaseName

Allowed me to edit what I needed in a really convenient way.

edited Feb 09 '17 at 10:35

steve cook

2,916
2
24
46

answered Mar 01 '11 at 22:37

hawkeye

31,052
27
133
271

4

As I found out the hard way, the database name has be the filename without its extension. E.g. databasefile.data should be jdbc:hsqldb:file:databasefile – tobsen Sep 05 '11 at 12:21
22

Using `org.hsqldb.util.DatabaseManagerSwing` will get you a slightly nicer user interface. – sherb Aug 28 '13 at 03:46
Great solution for simple browsing operations... but I'm unable to perform other simmple operations, like to copy (for pasting into notepad) the content of a single record... – Pierpaolo Cira Sep 10 '15 at 10:57
@sherb: Caveat: it's also much slower than the AWT interface though. – haylem Sep 23 '15 at 12:49
note: when running the bat file to show the manager, use the standalone type – Sebas Apr 14 '17 at 15:40

Lukas Eder · Answer 2 · 2019-07-17T11:35:29.310

32

DBeaver works very nicely:

http://dbeaver.jkiss.org

Also, SQuirreL is always a safe bet for any database:

http://squirrel-sql.sourceforge.net

Meanwhile, IntelliJ has decent database tooling, too

https://www.jetbrains.com/datagrip/

edited Jul 17 '19 at 11:35

answered Feb 14 '11 at 10:07

Lukas Eder

181,694
112
597
1,319

2

This answer is best than the accepted if you also need to modify your data. – Pierpaolo Cira Dec 01 '15 at 15:14
1

Just a note - don't forget specifying the exact database file name when using the DBeaver HSQL Embeded connection. – Yuri Jul 17 '19 at 11:17
+1 for DBeaver; really useful particularly if you develop in Eclipse (you can add it as a plugin into your current IDE) – sxc731 Jan 15 '20 at 14:03

score 12 · Answer 3 · answered Feb 14 '11 at 10:11

12

I've had good experience with SQL Workbench/J. Some of the best features compared to other tools: Auto completion for tables and columns in SQL statements, Code formatting etc.

Check out the features on the project site:

http://www.sql-workbench.net/

answered Feb 14 '11 at 10:11

Martin Klinke

7,070
5
38
62

I agree, SQLWorkbench is a very good tool, light, easy to use, but full of interesting (and even rare) functionnalities (schema comparaison for example). I mostly use only this one nowadays, even instead of Eclipse integrated database viewer plugin. – SRG Mar 30 '11 at 15:37
I just tried it. Looks good but you have to get the JDBC path to the HSQLDB database file exactly right otherwise it will fail to open it silently i.e. no error messages are shown and it looks like it has opened something even though the path is completely bogus. – Glenn Lawrence Apr 09 '14 at 01:20
1

I just realized that what threw me is if you don't get the path to the existing file correct it will create a new, empty, database for you at the path you gave. – Glenn Lawrence Apr 09 '14 at 01:30

Best SQL browser for HSQLDB?

3 Answers3

Linked