Description

xpusostomos

opened on Apr 15, 2026

Issue body actions

I have about 30 aliases, so I was surprised to see my SQLAliases23.xml is 608,000 bytes. Since most of these aliases are similar, like only 2 kinds of database, 4 hosts, and half a dozen db names, that's rather bloated. And since I've taken to storing my config files in GIT, that's a bloated file to add to git, and will be relatively painful if I ever have to do a git merge on one. Cant we not store all these driver parameters when they are just default values? I'd like to see just name, url, driver, user, password , if one hasn't customised it. I'd also prefer json to xml, but that's just me.

Activity

1. gerdwagner commented on May 31, 2026

   

   gerdwagner

   on May 31, 2026

   Member

   More actions

   The following was implemented and will be available in future snapshots and versions:

   Excerpt from change log:
   #89
   The SQLAliases23.xml file in SQuirreL's home directory could be unecessarily big (bloated)
   because it contained unnecessary, i.e. unspecified, JDBC driver properties.
   These properties are not saved anymore which, depending on the JDBC drivers being used,
   can reduce the size of SQLAliases23.xml significantly.
   A backup of the SQLAliases23.xml from before the size reduction will be written to
   sqlAliases23Backup/AliasesBeforeUnbloatBackupFile.xml in SQuirreL's home directory.

   Reacted by Stepan

   Reacted by xpusostomos
2. gerdwagner

   added a commit that references this issue on May 31, 2026

   Feature: #89

   ec66600

Issue actions