HeidiSQL explained

HeidiSQL
Author:Ansgar Becker
Latest Release Date:
Programming Language:Delphi
Operating System:Windows
Repo:https://github.com/HeidiSQL/HeidiSQL
Genre:Database management
License:GPLv2

HeidiSQL is a free and open-source administration tool for MariaDB, MySQL, as well as Microsoft SQL Server, PostgreSQL and SQLite. Its codebase was originally taken from Ansgar Becker's own MySQL-Front 2.5 software. After selling the MySQL-Front branding to an unrelated party, Becker chose "HeidiSQL" as a replacement. The name was suggested by a friend as a tribute to Heidi Klum, and was further reinforced by Becker's own nostalgia for Heidi, Girl of the Alps.

History

Ansgar Becker began development on a MySQL front-end in 1999, naming the project "MySQL-Front" and using a direct API layer written by Matthias Fichtner[1] to interface with MySQL servers and the databases contained on them. Private development continued until 2003 with version 2.5.In 2004, during a period of inactivity, Becker sold the MySQL-Front branding to Nils Hoyer, who continued development by cloning the original software.[2] [3] In April 2006, Becker open-sourced the application on SourceForge, renaming the project "HeidiSQL" due to having sold the MySQL-Front branding. HeidiSQL was re-engineered to use ZeosLib, a newer and more popular database-interface layer, which debuted in version 3.0.The name was suggested by a friend as a tribute to Heidi Klum, and was further reinforced by Becker's own nostalgia for Heidi, Girl of the Alps.[4]

The database layer was again replaced by a single-unit approach in October 2009 by Becker. Later, this was again extended for supporting other database servers.jHeidi—a version written in Java was designed to work on Mac and Linux computers—was discontinued in March 2010 in favor of Wine support.Support for Microsoft SQL Server was added in March 2011 for the 7.0 release.Since the 8.0 release, HeidiSQL offers its GUI in about 22 languages other than English; translations are contributed by users from various countries via Transifex.PostgreSQL support was introduced in March 2014 for the 9.0 release.In early 2018, a slightly extended v9.5 release was published on the Microsoft Store.SQLite support was introduced in March 2020 for the 11.0 release.[5]

Features

HeidiSQL has the following GUI features and capabilities:[6] [7]

See also

Notes and References

  1. Web site: Client API for MySQL Database Servers . audio-data.de . Matthias Fichtner . 2014-12-01 . 2011-09-15 . http://webarchive.loc.gov/all/20020808163649/http://www.fichtner.net/delphi/mysql.delphi.phtml . 2002-08-08 . dead .
  2. Web site: the truth about heidiSQL history in wikipedia. www.heidisql.com. 2017-05-22. 2016-02-19. https://web.archive.org/web/20160219031506/http://www.heidisql.com/forum.php?t=20155. live.
  3. Web site: Zu: Announcement: End of MySQL-Front ? Some words from.... www.heidisql.com. 2018-11-13. 2018-11-13. https://web.archive.org/web/20181113170202/https://www.heidisql.com/forum.php?t=23. live.
  4. Web site: heidi? . live . https://web.archive.org/web/20190331104119/https://www.heidisql.com/forum.php?t=19 . 2019-03-31 . 2017-05-22 . www.heidisql.com.
  5. Web site: HeidiSQL 11.0 with SQLite support. heidisql.com. 2023-05-15. 2023-05-15. https://web.archive.org/web/20230515200549/https://www.heidisql.com/forum.php?t=35807. live.
  6. Web site: HeidiSQL. Partial list of major features. 2014-12-01. 2017-04-15. https://web.archive.org/web/20170415011243/https://www.heidisql.com/. live.
  7. Web site: HeidiSQL. Screenshots of GUI features and descriptions. 2014-12-01. 2017-04-06. https://web.archive.org/web/20170406125110/https://www.heidisql.com/screenshots.php. live.