數據庫管理客戶端,HeidiSQL 9.3 發布

jopen 9年前發布 | 10K 次閱讀 HeidiSQL

HeidiSQL 是一個功能非常強大的數據庫客戶端軟件,采用 Delphi 開發,支持 Windows 操作系統。支持 MySQL、MariaDB、Percona Server 和微軟的 SQL Server。

數據庫管理客戶端,HeidiSQL 9.3 發布

特點:

  • 免費開源

    </li>

  • 可在一個窗口中連接到多個服務器

    </li>

  • 可通過命令行連接到服務器

    </li>

  • 支持 SSH 隧道連接,或者通過 SSL 設置

    </li>

  • 可創建和編輯數據表、視圖、存儲過程、觸發器和調度事件

    </li>

  • 生成格式友好的 SQL 導出

    </li>

  • 可直接從服務器/數據庫導出到另外一個服務器/數據庫

    </li>

  • 支持用戶權限管理

    </li>

  • 可導入文本文件

    </li>

  • 可導出表數據到 CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array

    </li>

  • 友好的表格瀏覽和編輯表數據

    </li>

  • 批量編輯表操作(移動表、更改存儲引擎、collation 等)

    </li>

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

    </li>

  • 支持可定制的語法高亮和代碼自動完成的查詢編輯器

    </li>

  • 很好的格式化 SQL

    </li>

  • 監控并可停止客戶端進程

    </li>

  • 在所有表、所有數據庫中查找特定文本

    </li>

  • 批量優化和修復表

    </li>

  • 使用當前設置啟動并行的 mysql.exe 命令行窗口

    </li>

  • 等等

    </li> </ul> 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
     本文由用戶 jopen 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
     轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
     本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!