Geek Software of the Week: Linux Edition: SQuirreL SQL Client!
A great Java-based SQL Client for Linux!
“The SQuirreL SQL client provides a simple graphical interface to relational databases.
Because it is built using Java, it can access any JDBC-compliant database running on any
machine, allowing remote access to multiple databases. A SQuirreL user can:
– easily view and edit data in any JDBC-compliant database,
– view the database’s meta-data,
– work with multiple databases on both local and remote machines,
– use a single, consistent interface to work with different database engines, and
expand the tool’s capabilities and include DB-specific functionality using plugins.
The user can click on tables to view them and edit data, or use full SQL operations. Data
can be viewed in read-only mode for safety, or in an editable mode where it may be
modified by simply typing the new data into the table. All of the meta-data for the
database (eg: data types, table column names, etc.) are accessible through SQuirreL. In
cases where multiple types of database engines are being used (eg: Oracle, MySQL,
PostgreSQL, etc.), the user does not need to learn multiple DB-management tools since
SQuirreL-SQL provides a common mechanism for accessing them all. In those cases
where a Database engine has non-standard quirks, SQuirreL’s plugin architecture allows
users to include DB-specific components to handle those operations. The plugin
architecture also allows developers to create add-on functions that users may choose to
include or not as they wish.”