Whats the best browser tool for HSQLDB databases?
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.
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/
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/
精彩评论