SQuirreL SQL Client / News: Recent posts

SQuirreL has a new SQuirreL source code repository: GIT

To create a local clone of the repository use the command line:

git clone git://git.code.sf.net/p/squirrel-sql/git squirrel-sql-git

or

git clone http://git.code.sf.net/p/squirrel-sql/git squirrel-sql-git

Registered developers should use:

git clone ssh://<sf user="" name="">@git.code.sf.net/p/squirrel-sql/git squirrel-sql-git</sf>

Great thanks to Venkatram Akkineni for preparing the repository and for helping to import it to SQuirreL.

SQuirreL is updated to Sourceforge Allura.

The most important changes are the new SVN repository URLs:
To checkout SQuirreL from subversion use the command:
svn checkout svn://svn.code.sf.net/p/squirrel-sql/code/trunk/sql12
or
svn checkout http://svn.code.sf.net/p/squirrel-sql/code/trunk/sql12

Registered developers should use:
svn checkout --username=<SF user name> svn+ssh://<SF user name>@svn.code.sf.net/p/squirrel-sql/code/trunk/sql12

A description how to set up SQuirreL for the Starschema BigQuery database can be found here:
http://code.google.com/p/starschema-bigquery-jdbc/wiki/SQuirreLSQL

The latest French translation update is available here:
http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/squirrelsql-translations/src/main/resources/squirrel-sql_fr.jar

Directions how to activate the translation update can be found here:
http://squirrel-sql.sourceforge.net/index.php?page=translations

Version 3.4 is available for download. For a complete list of all changes see our change log:
http://squirrel-sql.svn.sourceforge.net/viewvc/squirrel-sql/trunk/sql12/doc/src/main/resources/changes.txt

We are planning to release version 3.4 soon. It would be great if as many users as possible could have a look at the latest snapshot which is essentially the planned release version. Thanks.

The snapshot can be downloaded from
http://sourceforge.net/projects/squirrel-sql/files/3-snapshots/Snapshot-20120711_1724/

For those interested in programming SQuirreL there is a new instruction that explains how to set up your IDE to quickly test and debug code changes for SQuirreL and SQuirreL plugins.

See:
http://www.squirrelsql.org/IDEsetup/SQuirreLIDE.html

New Multisource Plugin:
- Allows SQuirreL to support native multiple source queries where one SQL query spans multiple sources.
- The Plugin supports standard SQL including joins, group by, aggregation, LIMIT, and ordering where tables may come from one or more sources.
- The Plugin will perform function translation where a user requests a function that is not supported on a certain source.
- Added a new UnityJDBC default driver definition that supports this virtualization.... read more

It's been a while since the last release (December 2010), so the list of changes is quite extensive:

3.3.0 (11/20/2011)

Enhancements:

Hibernate Plugin:
Directories containing archive files (Jars, Zips) can now be added to a Hibernate configuration's classpath.
All files in the directory will be added as classpath entries.

Hibernate Plugin:
HQL errors during results reading are now displayed as a result tab. (Similar to the new SQL error display.)... read more

Tom Snyder published an article on how to install SQuirreL SQL for use with DB2 on MCPressOnline.com, which is a popular site for the IBM i (AKA AS/400) community. The article can be found here:
http://www.mcpressonline.com/programming/sql/an-open-source-db2-sql-graphical-tool-that-you-can-use-for-all-your-databases.html

A nice introduction to SQuirreL can be found at:
http://www.cubrid.org/using_cubrid_in_squirrel_sql_client

3.2.1 (12/29/2010)

Enhancements:

Feature request 3030479: New global preference that allows scrollable tabbed pane for Session tabs.
Feature request 1608435: (checkbox in I18N administration: "show only bundles with missing translations").
Thanks to Ivo Neri for the patch.

New icons in Object tree

Updated translation for Italian (Thanks to Ivo Neri)

New translation
Japanese (Thanks to Toshiki IGA)... read more

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Enhancements
- New default editor (RText) is used instead of the classic NetBeans Editor
- New plugin for Netezza database
- Connection keep-alive configuration for Sessions
- New Polish translation
- Custom driver properties can now be added or removed
- Support for generating Oracle SQL*Loader control files
- The Graph plugin allows constraints to be added graphically using the model
- Many other improvements were made for performance and ease-of-use.

SQuirreL SQL Client: Version 3.0.3 released

3.0.3 (11/29/2009)

Enhancements:

Feature request 1656320:
Background Color Configuration is now available via a new tab ("Color Properties") in Alias
Properties dialog.

Bug-Fixes:

Correcting the error that database specific keywords are not in the SchemaInfo/SchemaInfoCache

Better table header rendering for MAC OS (Patch ID 2856103)... read more

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

3.0.1 (3/23/2009)

Changes since 3.0:

Enhancements:

- New Korean translation available (Thanks to Youngwoo Kim)

Bug-Fixes:

2686268: OS X Look and Feel is Incorrect
2645286: Quotes missing in squirrel-sql.sh (Thanks to mdykierek for the patch)
2531193: Oracle create table script the "ON UPDATE" is wrong
2644778: "Contents Tab SQL filter" and "Limit cell edit WHERE clause size" dialogs didn't work... read more

3.0 (2/21/2009)

Enhancements:

Dataimport Plugin:
* SuggestColumns: if columns in database and in the first line of the file
are equal, they are matched for the import.

Sybase Plugin:
* New ExceptionFormatter for SQLWarnings: better viewing warnings while the parameter
showplan is on (set showplan on)

Look an Feel Plugin:
* Made Nimbus look and feel available (needs at least JDK/JRE 1.6.0_10)
* Made Metal look and feel with Ocean theme the default (used at first start up).
* Added warning message that look and feels other than Metal may cause perfomance and/or functional problems... read more

Changes since 2.6.7:

Delete records progress dialog was being left visible after it was no longer needed in some cases.

Hidden directories are now visible to the file chooser for jdbc driver files.

Import from file to table feature now warns and asks the user to confirm that it is ok to truncate the
existing table data (The import feature doesn't yet support merging new data with existing data).

2119937: Windows EOL chars (CRLF) are converted to Linux EOL (LF).... read more

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse/edit the data in tables, issue SQL commands, etc.

This release can be downloaded here:

http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=29193

This is a bug-fix release and has the following change log:

2.6.7 (9/16/2008)
================ ... read more

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

This release can be downloaded here:

http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=29193

This is a bug-fix release and has the following change log:

2.6.6 (6/13/2008)
================... read more

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

This is a bug-fix release and has the following change log:

2.6.5a (3/8/2008)

Bug-Fixes:

1909015: (Classpath screwed up for 2.6.5). Fixed this issue that was produced when using the Windows launch script (squirrel-sql.bat).... read more

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

This is a bug-fix release and has the following change log:

2.6.5 (3/2/2008)

Bug-Fixes:

1902611: (Oracle) Don't fail on SQL-Plus "SET ..." commands in SQL script; Now, the Oracle plugin skips
over them.... read more

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

This is a bug-fix release and has the following change log:

2.6.4 (1/14/2008)

Changes since 2.6.3:

Bug-Fixes:

DBCopy Plugin: Only attempt to order the tables being copied if there is
more than one table in the copy set.... read more

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

This is a bug-fix release and has the following change log:

2.6.3 (12/24/2007)

Changes since 2.6.2:

Bug-Fixes:

1848924: Sybase object browser contents not displayed.
1541325: Connection doesn't close when ending session - thanks goes to
Alex Pivovarov for the patch that fixed the issue.... read more

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

This is a bug-fix release and has the following change log:

2.6.2 (11/30/2007)

Changes since 2.6.1:

Bug-Fixes:

1820792: Sybase ASE - table not shown in object browser
1821354: Changing default value of a column in Derby does nothing
1820214: 2.5.1 DB aliases do not transfer properly to 2.6.1
1820020: modified tables aren't sorted

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

We released version 2.6.1 which addresses the following two problems:

A critical packaging flaw that prevents launch on some platforms:

http://sourceforge.net/tracker/index.php?func=detail&aid=1818446&group_id=28383&atid=393414 ... read more