SQuirreL SQL Client: Difference between revisions
No edit summary |
|||
Line 2: | Line 2: | ||
|name = SQuirreL SQL Client |
|name = SQuirreL SQL Client |
||
|developer = Colin Bell, Gerd Wagner, Rob Manning and others |
|developer = Colin Bell, Gerd Wagner, Rob Manning and others |
||
|latest_release_version = 3. |
|latest_release_version = 3.4.0 |
||
|latest_release_date = |
|latest_release_date = August 6, 2012 |
||
|operating_system = [[Cross-platform]] |
|operating_system = [[Cross-platform]] |
||
|platform = [[Java platform|Java]] |
|platform = [[Java platform|Java]] |
Revision as of 22:01, 7 August 2012
Developer(s) | Colin Bell, Gerd Wagner, Rob Manning and others |
---|---|
Stable release | 3.4.0
/ August 6, 2012 |
Repository | |
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.[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 is based on RSyntaxTextArea by fifesoft.com to provide syntax highlighting. It can be used to open, create, save and execute files containing SQL statements.
- Supports simultaneous sessions with multiple databases. This allows to compare data and share SQL statements between databases. [2]
- It runs on any platform that has a JVM.
- Plugin architecture to facilitate 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 are available in: (Bulgarian, Brazilian Portuguese, Chinese, Czech, French, German, Italian, Japanese, Polish, Spanish, Russian).
- Graph capabilities to create charts showing table relationships.[3]
- Bookmarks, which are 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
- Axion Java RDBMS.
- Apache Derby
- Daffodil (One$DB)
- Fujitsu Siemens SESAM/SQL-Server with the SESAM/SQL JDBC driver
- Firebird with the JayBird JCA/JDBC Driver
- FrontBase
- Hypersonic SQL
- H2 (DBMS)
- IBM DB2 for Linux, OS/400 and Windows
- Informix
- Ingres (and OpenIngres)
- InstantDB
- InterBase
- Mckoi SQL Database
- Microsoft Access with the JDBC/ODBC bridge.
- Microsoft SQL Server
- Mimer SQL
- MySQL
- Netezza
- Oracle Database 8i, 9i, 10g, 11g
- Pointbase
- PostgreSQL 7.1.3 and higher
- SAPDB
- Sybase
- Sunopsis XML Driver (JDBC Edition)
- Teradata Warehouse
- ThinkSQL RDBMS
- Vertica Analytic Database
See also
References
- ^ Wagner, Gerd; Griffin, Glenn. "SQuirreL, a Universal SQL Client" (PDF). Retrieved 2009-04-15.
- ^ Martinig, Franco. "SQuirreL SQL Client". Retrieved 1 March 2011.
- ^ a b "SQuirreL SQL Client Home Page". SourceForge.net. Retrieved 2009-04-15.