I wanted for a long time to have one database client to access databases of different types like HSQLDB, MySQL, SQLite, etc. I finally found an interesting one in Java. It only needs to have the JDBC driver for the RDBMS that should be accessed. This is a free software tool named SQuirreL SQL (home page).
I also wanted to access SQLite databases throught this client or any
Java code. Finding the JDBC driver for SQLite is quite hard, but here is
a working one. To use it with SQuirreL SQL, simply place the JDBC
jar file in the lib directory of SQuirreL installation and add a new
JDBC driver with the class