As a developer I’m always wondering how much time I’ve got connect to databases and interacting with way more them then I’d prefer. My tool for these moments is SQuirreL, a Universal SQL Client.
SQuirreL SQL Client is a program written in Java that allows me to view the contents of a database, execute SQL commands and perform a number of other functions. The list of supported JDBC-compliant databases is so impressive:
- Apache Derby (formerly Cloudscape)
- Firebird with the JayBird JCA/JDBC Driver.
- Hypersonic SQL.
- IBM DB2 for Linux, OS/400 and Windows.
- Interbase with the Interclient JDBC driver.
- Microsoft Access with the JDBC/ODBC bridge.
- Microsoft SQL Server with the Microsoft, WebLogic and jTDS JDBC drivers.
- MySQL with the MM MySQL JDBC driver.
- Oracle 8i, 9i and 10g with the Oracle thin and OCI drivers.
- PostgreSQL 7.1.3 and higher.
- and so on…
SQuirreL’s default language is English and the contributors has added translation packages for several others. With a plugin architecture, new functionalities are released to each new version. Did I mention it is Hibernate HQL supported too? Does not matter what database I will be connected, this simple front end open source application makes my day a bit more easier.
[repost from my old blog]