Best SQL browser for HSQLDB? [closed]

Solution 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.

Solution 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/

Solution 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/