Reputation:
I have tried SQLite in Java, but the speed is slow due to the JDBC driver. Then I tried HSQLDB and thought the speed is good, but I cannot find a good management tool for HSQLDB such as phpMyAdmin for MySQL or SQLite Manager for SQLite.
I'd like to use the manager tool to prepare the test data for unit tests, or use the manager tool to navigate the data after doing some small experiments.
Is there any good tool?
Upvotes: 12
Views: 37241
Reputation: 1238
Here are a couple other suggestions you might checkout:
Razor has the best feature set, but is paid. The others are good at different things and worth checking into.
Upvotes: 13
Reputation: 104196
This would only have meaning if you are running in HSQLDB server mode. If you are running in memory or file mode, then you either can't access the DB from another process or doing so would lock it.
In Server mode you could use any universal client. JDBC driver is the hsqldb.jar itself.
Upvotes: 4
Reputation: 61
I've used Squirrel SQL. It's a universal client for any JDBC database.
See: http://squirrel-sql.sourceforge.net/
Upvotes: 2
Reputation: 30994
Actually HSQL brings its own management tool (which is not super). See http://hsqldb.org/doc/guide/apf.html
Upvotes: 3