SQuirreL SQL Client
 | This article needs additional citations for verification. (December 2014) |
| SQuirreL SQL Client | |
|---|---|
| Developers | Colin Bell, Gerd Wagner, Rob Manning and others |
| Stable release | |
| Preview release | |
| Repository |
|
| Engine | |
| Operating system | Cross-platform |
| Platform | Java |
| Type | Database administration tool |
| License | LGPL |
| Website | www.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.[3]
SQuirreL SQL Client is free as open source software that is distributed under the GNU Lesser General Public License.
Feature summary
[edit | edit source]- 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.[4]
- 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.[5]
- Bookmarks - user-defined code templates. SQuirreL comes with predefined example bookmarks for the most common SQL and DDL statements.[5]
History
[edit | edit source]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 2024.[6]
Supported databases
[edit | edit source]- 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
See also
[edit | edit source]Lua error in mw.title.lua at line 392: bad argument #2 to 'title.new' (unrecognized namespace name 'Portal').
References
[edit | edit source]- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ a b Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ a b Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).