数据库管理客户端，HeidiSQL 9.3 发布

jopen 9年前

HeidiSQL 是一个功能非常强大的数据库客户端软件，采用 Delphi 开发，支持 Windows 操作系统。支持 MySQL、MariaDB、Percona Server 和微软的 SQL Server。

数据库管理客户端，HeidiSQL 9.3 发布

特点：

  • 免费开源

  • 可在一个窗口中连接到多个服务器

  • 可通过命令行连接到服务器

  • 支持 SSH 隧道连接，或者通过 SSL 设置

  • 可创建和编辑数据表、视图、存储过程、触发器和调度事件

  • 生成格式友好的 SQL 导出

  • 可直接从服务器/数据库导出到另外一个服务器/数据库

  • 支持用户权限管理

  • 可导入文本文件

  • 可导出表数据到 CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array

  • 友好的表格浏览和编辑表数据

  • 批量编辑表操作（移动表、更改存储引擎、collation 等）

  • 批量插入ASCII和二进制文件到表中

  • 支持可定制的语法高亮和代码自动完成的查询编辑器

  • 很好的格式化 SQL

  • 监控并可停止客户端进程

  • 在所有表、所有数据库中查找特定文本

  • 批量优化和修复表

  • 使用当前设置启动并行的 mysql.exe 命令行窗口

  • 等等

HeidiSQL 9.3 发布，此版是一个维护版，修复了大量的bug。
下载地址： http://www.heidisql.com/download.php?download=installer
Changelog:
Bugfix: Crash in foreign key dropdown editor
Bugfix: Crash when killing processes on very long running servers
Bugfix: SQL error when accessing UUID and JSON columns in PostgreSQL via SUBSTR
Bugfix: MSSQL: Prefer "schema.table" quoting over "schema"."table" when renaming a table
Bugfix: Fix column type converted to locale string format by String.ToUpper in TDBConnection.GetCreateCode - prefer String.ToUpperInvariant instead, to avoid funny characters in data types
Bugfix: MSSQL: Do not pass "Database=xyz" to connection string if database(s) setting contains more than one database
Bugfix: MSSQL: Try to use some universal date/time format, by injecting a "T" between the date and the time portion
Bugfix: Fix wrong detection of BIT default values
Bugfix: Use "SET search_path TO db" instead of "SET SCHEMA db" for changing a database in PostgreSQL, for downward compatibility reasons
Bugfix: Prepend 'E' to escaped PostgreSQL strings
Bugfix: Use updated URL for MariaDB Explain analyzer, and encode semicolon in URL parameter
Bugfix: User manager: Select "authentication_string" instead of "password" column on MySQL 5.7.6+
Bugfix: Fix various selection bugs in column selection panel
Bugfix: Fix SQL error in "Copy table" dialog, in PostgreSQL mode. Use lowercase table and column names in IS.TABLES, so PG can find them
Bugfix: CSV import: Disable features supported in MySQL only, if active connection is not MySQL
Bugfix: PostgreSQL: Always keep public schema in search path, so one can use procedures from it without prefixing
Bugfix: Text import: Use very last value from last row, even if it's not followed by a field or line terminator
Bugfix: PostgreSQL: Fix wrong ALTER TABLE query for modifying table comment
Bugfix: Update VirtualTree component code to v6.1.0, to fix graphical issues in Windows 8 + 10

Enhancement: Show error when SSH port is already in use
Enhancement: Add support for PostgreSQL's data types uuid, cidr, inet and macaddr
Enhancement: Strip folder path from various file settings, including plink.exe location, if it's the application directory
Enhancement: Try higher ports, up to the 20 next ones, as SSH local port, when the configured one is in use
Enhancement: Display session name in caption of all message dialogs
Enhancement: Add a custom icon for confirmation dialogs, with a question mark on it, so we don't have to use the "i" icon.
Enhancement: Use server time for data grid > "Insert value" menu items
Enhancement: Show line breaks other than Windows style as normal line breaks in text editor

New feature: Introduce option for setting the line break style in text cells without breaks
* New feature: Session manager: Add support for SSL cipher, and add various texthints