Jump to content

SQuirreL SQL Client

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by 2a02:6b8:0:81f::1:4f (talk) at 01:50, 13 November 2016 (→Supported databases). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

SQuirreL SQL Client
Developer(s)Colin Bell, Gerd Wagner, Rob Manning and others
Stable release
3.7.1 / May 9, 2016
Repository
Operating systemCross-platform
PlatformJava
TypeDatabase administration tool
LicenseLGPL
Websitewww.squirrelsql.org

The SQuirreL SQL Client is a database administration tool. It uses JDBC to allow users to explore and interact with databases via a JDBC driver. It provides an editor that offers code completion and syntax highlighting for standard SQL. It also provides a plugin architecture that allows plugin writers to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. As this desktop application is written entirely in Java with Swing UI components, it should run on any platform that has a JVM.[1]

SQuirreL SQL Client is free as open source software that is distributed under the GNU Lesser General Public License.

Feature summary

  • Object Tree allows for browsing database objects such as catalogs, schemas, tables, triggers, views, sequences, procedures, UDTs, etc.
  • The SQL Editor, based on RSyntaxTextArea by fifesoft.com, provides syntax highlighting. It can open, create, save and execute files containing SQL statements.
  • SQuirreL supports simultaneous sessions with multiple databases. This allows comparing data and sharing SQL statements between databases.[2]
  • SQuirreL runs on any platform that has a JVM.
  • A plugin architecture facilitates database vendor-specific extensions (information or actions not available using standard JDBC - see SQuirreL SQL Client Plugin API for more details)
  • Translations for the user interface exist in: (Bulgarian, Brazilian Portuguese, Chinese, Czech, French, German, Italian, Japanese, Polish, Spanish, Russian).
  • Graph capabilities can generate charts showing table relationships.[3]
  • Bookmarks - user-defined code templates. SQuirreL comes with predefined example bookmarks for the most common SQL and DDL statements.[3]

History

The SQuirreL SQL project was developed by a team of Java developers around the world and led by Colin Bell. It has been hosted as a SourceForge project since 2001, and is still being developed today.

Supported databases

See also

References

  1. ^ Wagner, Gerd; Griffin, Glenn. "SQuirreL, a Universal SQL Client" (PDF). Retrieved 2009-04-15.
  2. ^ Martinig, Franco. "SQuirreL SQL Client". Retrieved 1 March 2011.
  3. ^ a b "SQuirreL SQL Client Home Page". SourceForge.net. Retrieved 2009-04-15.
Retrieved from "https://en.wikipedia.org/w/index.php?title=SQuirreL_SQL_Client&oldid=749205555"