HeidiSQL: Difference between revisions

Revision as of 09:43, 6 November 2007

Latest revision as of 14:23, 16 July 2025

(162 intermediate revisions by 93 users not shown)

Line 1:

{{Short description|Administration tool for relational databases}}

{{Infobox_Software

{{refimprove|date=September 2014}}

|name = HeidiSQL

{{Infobox software

|logo = [[Image:Heidisql logo.png|100px|HeidiSQL logo]]

| name = HeidiSQL

|screenshot = [[Image:Heidisql screenshot2.jpg|200px|HeidiSQL screenshot]]

| logo = HeidiSQL logo image.png

|caption =

| screenshot = HeidiSQL main screenshot.png

|developer = Ansgar Becker

| caption = Main view of a session, dark theme selected, with the database tree on the left and details on the right. "SQL Export" dialog in the foreground.

|latest_release_version = 3.1 RC1

| collapsible =

|latest_release_date = [[October 12]], [[2007]]

| author = Ansgar Becker

|operating_system = [[Microsoft Windows]]

| developer =

|genre = Database management

| released = {{start date and age|2006|04}}

|license = [[GNU General Public License]]

| discontinued =

|website = [http://www.heidisql.com www.heidisql.com]

| latest release version = {{wikidata|property|edit|reference|P348}}

| latest release date = {{wikidata|qualifier|P348|P577}} ({{Time ago| {{wikidata|qualifier|raw|P348|P577}} }})

| latest preview version =

| latest preview date = <!-- {{start date and age|YYYY|MM|DD}} -->

| programming language = [[Delphi (programming language)|Delphi]] and [[Object Pascal]]/[[Lazarus (software)|Lazarus]]

| operating system = [[Microsoft Windows|Windows]] and [[Linux]]

| platform =

| size =

| language =

| repo = https://github.com/HeidiSQL/HeidiSQL

| genre = Database management

| license = [[GNU General Public License|GPLv2]]

| website = {{url|http://www.heidisql.com/}}

}}

'''HeidiSQL''' is a [[Free and open-source software|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]]''.

'''HeidiSQL''' (previously known as MySQL-Front) is a [[Free software|free]], [[open source]] client for [[MySQL]] developed by German programmer Ansgar Becker who goes by the pseudonym Anse (http://www.anse.de).

== General detailsHistory ==

{{Proseline section|date=July 2024}}

The releases with version numbers below 3.0 were known as MySQL-Front until 2.5. The name has been switched in 2006 to HeidiSQL, as Ansgar Becker took his old sources and put them into a new open-source-project at [[SourceForge]] in April 2006.

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<ref>{{cite web |url = http://www.fichtner.net/delphi/mysql.delphi.phtml |title = Client API for MySQL Database Servers |publisher = audio-data.de |author = Matthias Fichtner |accessdate = 2014-12-01 |date = 2011-09-15 |archive-url = http://webarchive.loc.gov/all/20020808163649/http://www.fichtner.net/delphi/mysql.delphi.phtml |archive-date = 2002-08-08 |url-status = dead }}</ref> 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 [[clone (computing)|cloning]] the original software.<ref>{{cite web|url=https://www.heidisql.com/forum.php?t=20155|title=the truth about heidiSQL history in wikipedia|website=www.heidisql.com|access-date=2017-05-22|archive-date=2016-02-19|archive-url=https://web.archive.org/web/20160219031506/http://www.heidisql.com/forum.php?t=20155|url-status=live}}</ref><ref>{{cite web|url=https://www.heidisql.com/forum.php?t=23|title=Zu: Announcement: End of MySQL-Front ? Some words from...|website=www.heidisql.com|access-date=2018-11-13|archive-date=2018-11-13|archive-url=https://web.archive.org/web/20181113170202/https://www.heidisql.com/forum.php?t=23|url-status=live}}</ref>

In April 2006, Becker [[Open-source software|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]]''.<ref>{{cite web |title=heidi? |url=https://www.heidisql.com/forum.php?t=19 |url-status=live |archive-url=https://web.archive.org/web/20190331104119/https://www.heidisql.com/forum.php?t=19 |archive-date=2019-03-31 |access-date=2017-05-22 |website=www.heidisql.com}}</ref>

The database layer was again replaced by a single-unit approach{{Clarify|date=July 2024|reason="Single-unit" is not used elsewhere, so it's unclear what it means to return to this approach.}} in October 2009 by Becker. Later, this was again extended for supporting other database servers.

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

jHeidi—a version written in [[Java (programming language)|Java]] was designed to work on Mac and Linux computers—was discontinued in March 2010 in favor of [[Wine (software)|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.<ref>{{cite web|url=https://www.heidisql.com/forum.php?t=35807|title=HeidiSQL 11.0 with SQLite support|website=heidisql.com|access-date=2023-05-15|archive-date=2023-05-15|archive-url=https://web.archive.org/web/20230515200549/https://www.heidisql.com/forum.php?t=35807|url-status=live}}</ref>

In May 2025, a first native Linux version was released,<ref>{{cite web |title=12.10.1.133 Linux pre-release |url=https://www.heidisql.com/forum.php?t=44068 |website=www.heidisql.com}}</ref> for which Becker converted the current Delphi sources to a [[Lazarus (software)|Lazarus]] compatible project structure.

== Features ==

The team around HeidiSQL currently consists of [http://sourceforge.net/project/memberlist.php?group_id=164593 3 developers]. The team-members are working on HeidiSQL in their spare time. The members are spread over different countries: Germany, Denmark and Brazil.

HeidiSQL has the following GUI features and capabilities:<ref>{{cite web|publisher=HeidiSQL|url=http://www.heidisql.com/|title=Partial list of major features|accessdate=2014-12-01|archive-date=2017-04-15|archive-url=https://web.archive.org/web/20170415011243/https://www.heidisql.com/|url-status=live}}</ref><ref>{{cite web|publisher=HeidiSQL|url=http://www.heidisql.com/screenshots.php|title=Screenshots of GUI features and descriptions|accessdate=2014-12-01|archive-date=2017-04-06|archive-url=https://web.archive.org/web/20170406125110/https://www.heidisql.com/screenshots.php|url-status=live}}</ref>

== Some technical details ==

* '''Server connection'''

* HeidiSQL is completely developed in [[Borland Delphi|Delphi]]

** Multiple saved sessions with connection and credentials stored within

* The communication layer to the [[MySQL]]-server is implemented by the use of the popular [[ZeosLib]], whereas the old MySQL-Front 2.5 used the more direct API-layer [http://www.fichtner.net/delphi/mysql.delphi.phtml mysql.pas by Matthias Fichtner]

** Compressed client/server protocol for compatible servers

* The source-management is done by using a [https://svn.sourceforge.net/svnroot/heidisql SVN repository]

** Interface with servers via [[TCP/IP]], [[named pipes]] (sockets) or a [[tunneling protocol]] (SSH)

* New developers should take care of some details gathered in the [http://www.heidisql.com/svn/readme.html readme-file]

** Multiple parallelly running sessions in one window

** Manage users on the server: add, remove and edit users, and their credentials

** Manage user privileges globally and per database

** Export databases to SQL files or to other servers

** Multiple query tabs, with each one having multiple subtabs for batch results

* '''Server host'''

** View and filter all server variables, such as system_time_zone

** Edit all server variables, either for this session or with global scope

** View server statistical variables, and average values per hour & second

** Currently running processes to analyze executed SQL and to kill bad processes

** View command-statistics with percentage indicator bars per SQL command

* '''Databases'''

** View all databases on the server, connect to a single database to work with its tables and data

** View connected databases' total and table size in KB/MB/GB within the database/table tree structure

** Create new, alter existing databases' name, character set and collation, drop (delete) databases

* '''Tables, views, procedures, triggers and events'''

** View all objects within the selected database, empty, rename and drop (delete) objects

** Edit table columns, indexes, and foreign keys. Virtual columns on MariaDB servers are supported.

** Edit view query and settings

** Edit procedure SQL body and parameters

** Edit trigger SQL body and settings

** Edit scheduled event SQL body time settings

==See also==

== [http://www.heidisql.com/download.php Releases] ==

* [[Comparison of database administration tools]]

* [http://prdownloads.sourceforge.net/heidisql/HeidiSQL_3.0BETA_Setup.exe?download 3.0 Beta] (released on 2006-04-16)

* [http://prdownloads.sourceforge.net/heidisql/HeidiSQL_3.0RC1_Setup.exe?download 3.0 RC1] (released on 2006-05-03)

* [http://prdownloads.sourceforge.net/heidisql/HeidiSQL_3.0RC2_Setup.exe?download 3.0 RC2] (released on 2006-05-05)

* [http://prdownloads.sourceforge.net/heidisql/HeidiSQL_3.0RC3_Setup.exe?download 3.0 RC3] (released on 2006-08-04)

* [http://prdownloads.sourceforge.net/heidisql/HeidiSQL_3.0RC4_Setup.exe?download 3.0 RC4] (released on 2006-12-23)

* [http://prdownloads.sourceforge.net/heidisql/HeidiSQL_3.0_Setup.exe?download 3.0 Final] (released on 2007-04-03)

* [http://prdownloads.sourceforge.net/heidisql/HeidiSQL_3.1RC1_Setup.exe?download 3.1 RC1] (released on 2007-10-12)

== See also References==

{{Reflist}}

{{portal|Free software|Free Software Portal Logo.svg}}

==External links==

*[[phpMyAdmin]]

* {{Official website}}

{{MySQL}}

== External links ==

*[http://www.heidisql.com Official website]

**[http://www.heidisql.com/forum/ Forum]

*[http://sourceforge.net/projects/heidisql/ HeidiSQL project page] on [[SourceForge]]

**[http://bugs.heidisql.com Bugtracker]

**[http://rfe.heidisql.com Featuretracker]

<!-- Categories -->

[[Category:Database administration tools]]

[[Category:Windows-only free software]]

[[Category:SourceForge projectsMariaDB]]

[[Category:MySQL]]

[[Category:Microsoft database software]]

<!-- Interlang -->

[[Category:2006 software]]

[[de:HeidiSQL]]

[[Category:Pascal (programming language) software]]

[[pt:HeidiSQL]]