Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Best SQL browser for HSQLDB? [closed]

Whats the best browser tool for HSQLDB databases?

like image 668
hawkeye Avatar asked Feb 14 '11 10:02

hawkeye


People also ask

Is HSQLDB in-memory?

HSQLDB (HyperSQL DataBase) is the leading SQL relational database system written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes. It includes a powerful command line SQL tool and simple GUI query tools.


2 Answers

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.

like image 81
hawkeye Avatar answered Nov 05 '22 01:11

hawkeye


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/

like image 44
Lukas Eder Avatar answered Nov 05 '22 02:11

Lukas Eder