开源通用 SQL 客户端 SQuirrel SQL Client 4.8.0 中文多语免费版

开源通用 SQL 客户端 SQuirrel SQL Client 中文版由分享网发布。可以通过多种方式来检查数据库环境，特别是考虑到最近在有关 DBMS 的数字环境中的进步。除了实际的数据库管理系统，用户还可以求助于数据库可视化工具，虽然缺乏更高级的功能，但通过简单性带来的效率弥补了这一点。也许没有那么简单，但 SQuirrel SQL Client 旨在为那些可视化 JDBC 兼容数据库的人提供一种方便的方式。

开源通用 SQL 客户端 SQuirrel SQL Client 中文版

什么是 SQuirreL SQL？

SQuirreL SQL 客户端是一个开源的图形化 Java 数据库管理工具，允许您查看 JDBC 兼容数据库的结构、浏览表中的数据并发出 SQL 命令。

在本文中，我们将讨论 SQuirreL SQL 客户端是什么、它的一些特性、支持的数据库类型以及如何安装客户端。

SQuirreL SQL 客户端使用 JDBC（Java 数据库连接）让用户通过 JDBC 驱动程序探索多种数据库类型并与之交互。它提供了一个功能编辑器，允许代码完成以及标准 SQL 的语法突出显示。它还利用插件框架，允许插件编写者修改其大量行为，以提供跨多种数据库类型的增强的数据库特定功能。

因为该软件完全用 Java 编写（使用 Swing UI 组件），所以它应该在任何使用 JVM（Java 虚拟机）的平台上运行。它确实需要 Java 1.3 版，但首选 Java 1.4。

SQuirreL SQL 功能特色

对象树视图允许浏览不同的数据库对象，如目录、表、触发器和多个其他对象。
SQL 编辑器可以打开、创建、保存和执行包含 SQL 语句的文件，并提供语法高亮显示。
SQuirreL 还支持使用不同数据库的多个会话。这使得比较数据和在数据库之间共享各种 SQL 语句变得更加容易。
SQuirreL 可以在任何安装了 Java 虚拟机的系统上运行。
插件框架允许特定于供应商的数据库扩展。
用户界面存在多种翻译。
SQuirreL 可以生成图表和图形，显示表格和其他功能之间的关系。
SQuirreL 书签 – SQuirreL 带有用户定义的模板以及用于许多最常见的 DDL 和 SQL 语句的预定义示例书签。

SQuirreL SQL 支持的数据库

SQuirreL 适用于多种数据库类型和不同的环境。
Axion Java RDBMS
Apache Derby
Firebird 与 JayBird JCA/JDBC 驱动程序
H2 (数据库管理系统)
适用于 Linux、OS/400 和 Windows 的 IBM DB2
Informix
Ingres（和 OpenIngres）
带有 JDBC/ODBC 桥的 Microsoft Access
微软 SQL 服务器
MySQL
Oracle 数据库 8i、9i、10g、11g
PostgreSQL 7.1.3 及更高版本
SAPDB
Sybase
Teradata 仓库
Vertica 分析数据库
和更多…

SQuirreL SQL 安装

SQuirreL SQL 客户端可使用 IzPack Java 安装程序进行安装。要安装，请下载适用于 Linux 或 Windows 的 squirrel-sql–install.jar 文件并使用以下命令执行它：

1	[root@host ~]# java -jar squirrel-sql–install.jar

如果文件只是简单的下载，保存文件然后在Windows平台上安装软件，我们需要运行squirrel-sql.bat文件。

在 Unix 上，安装文件是 squirrel-sql.sh。

我们还可以从其 Git 存储库中克隆或签出 SQuirreL；我们可以使用 git 命令将软件克隆到本地文件夹：

1
2
3

[root@host ~]# git clone git://git.code.sf.net/p/squirrel-sql/git squirrel-sql-git
或
[root@host ~]# git clone http://git.code.sf.net/p/squirrel-sql/git squirrel-sql-git

此应用程序可以为需要使用符合 JDBC 的数据库以及需要功能强大的数据库结构及其后续组件的可视化工具的用户提供可靠的性能。

SQuirreL SQL Client 中文问题

界面的乱码：在 File – Global Preferences – Fonts 选项卡里面，选择相应的中文字体就可以了。

显示数据库里面的内容乱码。以MySQL为例，只需要在设置 Alias 的时候，这样设置:

URL:jdbc:mysql://server1/test?useUnicode=true&characterEncoding=EUC_CN

字体大小调整：会话，会话属性，SQL，字体，可调整字体大小。

SQuirreL SQL 许可证

LGPL

官方主页

What’s new in SQuirrel SQL Client 4.8.0
Sep 2, 2024
Enhancements:
Hibernate Plugin: Generating SQL from HQL now uses the SQL-Extractor of the hypersistence-utils library,
see https://github.com/vladmihalcea/hypersistence-utils.
To generate SQL from HQL execute a HQL and use the SQL button on the upper right of the HQL result tab.
To use this feature the hypersistence-utils library must included in the Hibernate Plugin’s configuration.
https://github.com/squirrel-sql-client/squirrel-sql-code/issues/34
SQL result table:
– Option to display cell details on the left of the table, see new toggle button with flip chart icon.
– Option to view contents of cell detail or cell data popup as image.
Additional SQL tabs can be renamed.
See SQuirreL’s main toolbar –> Button switchable between “New SQL Worksheet” and “New SQL Tab”.
The tab names are stored with Saved Sessions and Saved Session groups.
Updated the JDBC driver websites of several predefined drivers,
see Drivers panel –> right mouse menu “Show Driver Website”.
Thanks to zcattacz for the pull request.
Added description for single character and multiple character SQL statement separators.
See menu Files –> New Session Properties –> tab SQL –> lower part of panel.
Introduced Java 22 compatibility.
SQL result: The rows and columns display now offers several copy functions.
Dialog to rename Session tabs is now resizable, see right mouse menu of Session tabs.
Saved Session groups: New toolbar and Session menu “Save/manage group of saved Session” allows to save
multiple Sessions and their SQL editors.
– To reopen a group use the “Open Saved Session or groups” toolbar button or Session menu.
– Note: The “Save/manage group of saved Session” dialog offers an optimization
which allows to save all open Sessions by using the ctrl+alt+shift+m shortcut to open the dialog
and then hitting enter to save or GIT commit.
SQL editor’s right mouse menu offers to execute SQLs.
Bug fixes:
SQL result: Resize mouse cursor didn’t show between column headers
Side effect of implementation of https://github.com/squirrel-sql-client/squirrel-sql-code/issues/34
Code completion: When a completion entry was selected by mouse click to SQL editor lost focus.
SQL result: Display of current row and column, selection count and summing didn’t work after tables was made editable.
SQL result: Fixed tooltips of mark duplicates buttons and menu items.
File import: Fixed NullPointer when file import was started.
File import: If Ok was clicked immediately after a fixed value was edited the edited value wasn’t used.
File import: Avoided non cancelable progress dialog.
File import: Fixed values were not written to the database when a column was of numeric type.
SQL result search function: Moving search results to an own table window didn’t work when the result table was sorted.
Copying from table cell data popup was not added to paste history (ctrl+shift+v or ctrl+shift+insert).
Tools popup (ctrl+t) was broken by too long description.
Saved Session groups, several bug fixes:
When group members were moved to a standalone Saved Session their internally saved SQL files were lost.
When group members were moved to a standalone Saved Session SQuirreL’s title bar wasn’t updated.
When group members were moved to a standalone Saved Session a wrong Saved Session exist warning was shown.
Extended several tool tips concerning Saved Sessions and groups.
#1528 When users changed a Session tab’s name and switched to another catalog the changes were lost.
Look and feel plugin: When SQuirreL was installed into an empty directory
loading the FlatLaf Look and Feel raised a ClassNotFoundException. In consequence SQuirreL’s dark theme did not work.
Additionally FlatLaf was upgraded to version 3.4.1.
Saved Sessions and groups: The “Open / manage …” dialog’s list did not repaint when a Session or group was renamed.
Saved Session groups: Deleting Sessions from groups did not work.
It now works the same way as when a Saved Session of an open Session is deleted. I.e. all internal files are detached.
Editable cell data popup: When updating data fails with a “No rows updated” message box
the message box was poorly positioned.
When new users with fresh installations close SQuirreL with an open Session
they are shown the Session-close confirmation message box.
If then they check the confirmation message box to be not shown again
and close the message box by the No-button, SQuirreL lost their “not shown again” choice.