Squirrel Sql Client

SQuirreL SQL Client
Developer(s)	Colin Bell, Gerd Wagner, Rob Manning and others
Stable release	Template:SQuirreL SQL Client version / Template:SQuirreL SQL Client version
Preview release	20231120_2225 / November 20, 2023; 7 months ago
Operating system	Cross-platform
Platform	Java
Type	Database administration tool
License	LGPL
Website	www.squirrelsql.org

Short description: Database administration tool

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.^[2]

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.^[3]
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)
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.^[4]
Bookmarks - user-defined code templates. SQuirreL comes with predefined example bookmarks for the most common SQL and DDL statements.^[4]

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 was still under active development in 2020.^[5]

Supported databases

Axion Java RDBMS.
Apache Derby
ClickHouse
Fujitsu Siemens SESAM/SQL-Server with the SESAM/SQL JDBC driver
Firebird with the JayBird JCA/JDBC Driver
Hypersonic SQL
H2 (DBMS)
IBM Db2 for Linux, IBM i and Windows
Informix
Ingres (and OpenIngres)
InstantDB
InterBase
Mckoi SQL Database
Microsoft Access with the JDBC/ODBC bridge.
Microsoft SQL Server
Mimer SQL
MonetDB
MySQL
Netezza
Oracle Database 8i, 9i, 10g, 11g
Pointbase
PostgreSQL 7.1.3 and higher
SAPDB
Sybase
Sunopsis XML Driver (JDBC Edition)
Teradata Warehouse
Vertica Analytic Database

References

↑ ^1.0 ^1.1 "SQuirreL SQL Client - Browse /3-snapshots at SourceForge.net". sourceforge.net. https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/.
↑ Wagner, Gerd; Griffin, Glenn. "SQuirreL, a Universal SQL Client". http://squirrel-sql.sourceforge.net/paper/SQuirreL_us.pdf. Retrieved 2009-04-15.
↑ Martinig, Franco. "SQuirreL SQL Client". http://www.methodsandtools.com/tools/tools.php?squirrel. Retrieved 1 March 2011.
↑ ^4.0 ^4.1 "SQuirreL SQL Client Home Page". SourceForge.net. http://squirrel-sql.sourceforge.net/. Retrieved 2009-04-15.
↑ Bell, Colin. "SQuirreL SQL Client - Browse Files at SourceForge.net". https://sourceforge.net/projects/squirrel-sql/files/. Retrieved 19 February 2020.

External links

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/SQuirreL SQL Client. Read more

[SQuirreL_SQL_snapshots-1] 1.0 ^1.1 "SQuirreL SQL Client - Browse /3-snapshots at SourceForge.net". sourceforge.net. https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/.

[squirrel-faq-2] Wagner, Gerd; Griffin, Glenn. "SQuirreL, a Universal SQL Client". http://squirrel-sql.sourceforge.net/paper/SQuirreL_us.pdf. Retrieved 2009-04-15.

[3] Martinig, Franco. "SQuirreL SQL Client". http://www.methodsandtools.com/tools/tools.php?squirrel. Retrieved 1 March 2011.

[squirrel-sql-4] 4.0 ^4.1 "SQuirreL SQL Client Home Page". SourceForge.net. http://squirrel-sql.sourceforge.net/. Retrieved 2009-04-15.

[5] Bell, Colin. "SQuirreL SQL Client - Browse Files at SourceForge.net". https://sourceforge.net/projects/squirrel-sql/files/. Retrieved 19 February 2020.