HeidiSQL

from Wikipedia, the free encyclopedia
HeidiSQL

logo
Screenshot
Main view of a session, with the tree view of the database on the left and right the detailed view. In the foreground the "SQL export" dialog.
Basic data

Current  version 11.0
( May 17, 2020 )
operating system Windows
programming language Object Pascal
category Database management system
License GPL ( Free Software )
German speaking Yes
www.heidisql.com

HeidiSQL (previously known as MySQL-Front) is a free client for the MySQL database system and now other databases, which is being developed by the German programmer Ansgar Becker.

General details

The releases with version numbers prior to 3.0 were known as MySQL-Front (up to 2.5). The name was changed to “HeidiSQL” in 2006 when Ansgar Becker brought his old sources into a new open source project at SourceForge in April 2006 .

There was also a shareware application called "MySQL-Front 3.0" which was developed by another developer from 2004 to 2006 and had a new code base .

HeidiSQL was programmed exclusively by Ansgar Becker, after there were also team members from Denmark and Brazil at times. Other programmers have sent in small snippets of code and thereby partly built in new functions, such as: B. the LaTeX export.

Support for Microsoft SQL Server was added for version 7.0 from March 2011.

Translations of the interface currently exist in around 20 languages, which are managed by Transifex . While the German translation is created by the author himself, from version 8.0 onwards approx. 30 free authors deal with the other languages.

The PostgreSQL -support is available in work and officially since version 9.0 in March, 2014.

Technical details

  • Since version 5.0, communication with the MySQL server has been through a newly developed database connection layer that Becker developed specifically for HeidiSQL. In addition to TCP / IP connections, the newer connection layer also enables connections via named pipes, SSH tunnels (plink.exe) and SSL. The old MySQL front versions up to version 2.5 were based directly on Matthias Fichtner's mysql.pas programming interface. ZeosLib was used for HeidiSQL versions 3.0 to 4.0.
  • The versions are managed with Git .
  • The case handling system (for bug reports and new requests) is hosted on GitHub .
  • Among other things, HeidiSQL allows the creation and editing of databases, tables, table data, views, triggers, stored procedures and the time-controlled events introduced in MySQL 5.1.
  • Virtual columns on MariaDB servers are supported by the table editor.
  • A 64-bit version of HeidiSQL is also available from version 8.2.
  • Since version 10.0, visual styles based on the VCL styles from Embarcadero are supported
  • Supported operating systems are Windows XP, 7, 8 and 10, or with Wine also under Linux and macOS

Publications

  • 3.0 Beta (released April 16, 2006)
  • 3.0 RC1 (released May 3, 2006)
  • 3.0 RC2 (released May 5, 2006)
  • 3.0 RC3 (released August 4, 2006)
  • 3.0 RC4 (released December 23, 2006)
  • 3.0 (released April 3, 2007)
  • 3.1 RC1 (released October 12, 2007)
  • 3.1 (released November 14, 2007)
  • 3.2 (released November 20, 2007)
  • 4.0 RC1 (released October 23, 2008)
  • 4.0 RC3 (released January 13, 2009)
  • 4.0 (released April 30, 2009)
  • 5.0 Beta (released January 30, 2010)
  • 5.0 (released March 26, 2010)
  • 5.1 (released April 15, 2010)
  • 6.0 (released November 20, 2010)
  • 7.0 (released February 12, 2012)
  • 8.0 (released May 19, 2013)
  • 8.1 (released October 3, 2013)
  • 8.2 (released December 17, 2013)
  • 8.3 (released January 25, 2014)
  • 9.0 (released November 10, 2014)
  • 9.1 (released November 11, 2014)
  • 9.2 (released May 2, 2015)
  • 9.3 (released August 8, 2015)
  • 9.4 (released October 20, 2016)
  • 9.5 (released December 19, 2017)
  • 10.0 (released January 23, 2019)
  • 10.1 (released May 20, 2019)
  • 10.2 (released June 15, 2019)
  • 10.3 (released December 11, 2019)
  • 11.0 (released March 17, 2020)

Publications as "MySQL Front"

  • 1.8beta (released September 6, 2000)
  • 1.10 (published September 19, 2000)
  • 1.11 (released September 26, 2000)
  • 1.13beta (released October 26, 2000)
  • 1.14beta (released December 9, 2000)
  • 1.15beta (released December 10, 2000)
  • 1.16beta (released January 7, 2001)
  • 1.17 (released February 17, 2001)
  • 1.19beta (released June 20, 2001)
  • 2.0 (released January 13, 2002)
  • 2.1 (published January 17, 2002)
  • 2.2 (released March 16, 2002)
  • 2.3 (published July 26, 2002)
  • 2.4 (released August 26, 2002)
  • 2.5 (released September 3, 2002)

Web links

Individual evidence

  1. ↑ Release 11.0 . March 17, 2020 (accessed May 29, 2020).
  2. ↑ http://www.heidisql.com/help.php#credits