Free sql client software for linux

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. The minimum version of Java supported is 1.4.x. We recommend 1.5.x. See the Old Versions page for versions of SQuirreL that will work with older versions of Java.

SQuirreLs functionality can be extended through the use of plugins. A short introduction can be found here. To see the change history (including changes not yet released) click here.

Susan Cline graciously took the time to document the steps she followed to setup an Apache Derby database from scratch and use the SQuirreL SQL Client to explore it.
Quite some time ago Kulvir Singh Bhogal wrote a great tutorial on SQuirreL and published it at the IBM developerWorks site. He has kindly allowed us to mirror it locally. The tutorial is not really up to date but especially for doing the first steps it is still of help.

SQuirrel was originally released under the GNU General Public License. Since version 1.1beta2 it has been released under the GNU Lesser General Public License.

Whats New in This Release:

1716859 Cant see data in content tab or row count tab (MS SQLServer databases
with a dash ("-") in their name would cause the content tab or row count
tabs to render no data.

1714476: (DB copy uses wrong case for table names) The copy operation would
sometimes fail to select records from the source table. Since the
case for the source table is always known to be correct, the plugin
no longer erroneously attempts to correct the case.

1700093: Formatter fails for insert script with multiple subselects

Refactoring Plugin: SQL-Server needs eol between GO and statement.

Fixed bug which appeared while editing tables in PostgreSQL 8.1. If the table
was created without an OID column, the last column would not be editable.

Fix for issue where dates arent correctly displayed or updated when using
treat date as timestamp pref in the SQl Editor result panel.

Use the last directory that a file was imported from when importing additional
files for binary fields.

1699294: Squirrel imports BLOB, but does not update data

Oracle Plugin: Handle slashes when they are used as statement separators.

137984 (Bug in alias delete) The problem was that notifications were being
sent to the alias drop-down that the item was being deleted which trigger an
update and new selection forcing the connect to alias window to be launched.
Now, the alias drop down is disabled while the update is happening and enabled
immediately afterward.

Messa is an instant messager client and server. The client has a curses interface and works on the console. Messa supports multilingual messages and private messages.

The server supports monoprocess operation (without threads), the ability to choose the listening port, and the ability to run under the console.

Oww Client is a graphical client program for One-Wire Weather (Oww) servers. Oww Client is based on GTK+, displaying lists of collected weather data from one or more servers.
Enhancements:
- Owwl was enhanced to include new sensor types (mainly for cryogenic readout).
- A status window was added.
- Reconnexion is now automatic, after the remote server drops it.

SOAP::XML::Client is a simple frame work for talking with web services.

This package is the base class for talking with web services, there are specific modules to use depending on the type of service you are calling, e.g. SOAP::XML::Client::DotNet or SOAP::XML::Client::Generic

This package helps in talking with web services, it just needs a bit of XML thrown at it and you get some XML back. Its designed to be REALLY simple to use.

SMM++ Mud Client project is a client with mapping functionality and lots of other features.
SMM++ Mud Client is a mud client with extended and unique features.
Aside from all standard mud client functionality like ANSI color support, aliases, action triggers, and tab-completion, SMM++ features a highly-customizable user interface (labels, buttons, and menus) and unique and powerful mapping capabilities, and SMM++ is the only mapping crossplatform (Tcl/Tk based) mud client available.
Enhancements:
- ::smm::action replaced with ::smm::reaction (pretty stable)
Added:
- ::smm::pasteok hook (not tested extensively, yet)

SQL Admin is a Java client application to connect and send queries to different databases through JDBC.
SQLAdmin uses the brand new SWT Toolkit. The main idea is to create a multiplatform and multidatabase thin client. For example, you can connect to an Microsoft SQL Server from a Linux machine, or connect to a PostgreSQL/Linux server from a Windows machine using the same application.
Main features:
- Based on the SWT Tookit. Java applications can use the native Toolkit with a platform independant API. For example, SQLAdmin uses GTK2 in Linux
- Lightweight : The application itself is small, and the SWT provides a nice gui with a very small footprint
- Abstract JDBC driver backend. User should configure only basic parameters like server, port, and login without the need to know about Class names or JDBC URLs
- Graphical view of connections and database metadata such as schemas, tables and fields
- Multiple query execution. Also supports embedded comments on SQL Text
- Log window to view system messages and query results
- Table structure view
- Fast table rows view

PHP FTP Client is an FTP client that is useful for allowing people behind a firewall access to FTP without opening the FTP ports inside the firewall.
It could be used as a front end to a local FTP server, and therefore allow the administrator to provide access to the FTP server only from localhost.
Main features:
- Provide FTP access through a firewall which blocks FTP
- Provide a front end to an FTP server which only allows access to the web server, thus reducing the risk of the FTP server being attacked.
Enhancements:
- Have corrected problems with missing files. Was a case of linking against files I shouldnt have been.
- Added an FAQ, which currently only explains how to use the multi-file upload feature.