Best SQL browser for HSQLDB?

Question

Whats the best browser tool for HSQLDB databases?

Answer 1

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.

Answer 2

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/

Answer 3

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/