HeidiSQL: Difference between revisions

Revision as of 19:53, 3 February 2017

Latest revision as of 14:23, 16 July 2025

(43 intermediate revisions by 34 users not shown)

Line 1:

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

{{refimprove|date=September 2014}}

{{Infobox software

| name = HeidiSQL

| logo = [[File:HeidiSQL logo image.png|100px|Logo]]

| screenshot = [[File:HeidiSQL main screenshot.png|300px|Screenshot]]

| 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.

| collapsible =

| author = Ansgar Becker

| developer =

| released = <!-- {{start date and age|YYYY2006|MM|DD04}} -->

| discontinued =

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

| latest release date = {{releasewikidata|qualifier|P348|P577}} date({{Time andago| age{{wikidata|2016qualifier|10raw|20P348|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]]

| frequently updated =

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

| programming language = Object Pascal

| platform =

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

| size =

| platform =

| language =

| size =

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

| language =

| genre = Database management

| status =

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

| genre = Database management

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

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

| website = [http://www.heidisql.com/ 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]] and [[open source]] client, or [[MySQL#Management_and_graphical_frontends|frontend]] for [[MySQL]] (and for its [[Fork (software development)|forks]] like [[MariaDB]] and [[Percona Server]]), as well as [[Microsoft SQL Server]] and [[PostgreSQL]]. MySQL-Front was implemented by the German developer Nils Hoyer, who stopped mysql-front after MysqLab infringement issue about the use of name MySQL. Mysql-Front reappeared under the name HeidiSQL developed by German programmer Ansgar Becker and a few other contributors in [[Borland Delphi|Delphi]]. To manage databases with HeidiSQL, users must log in to a local or remote MySQL server with acceptable credentials, creating a session. Within this session users may manage MySQL databases within the connected MySQL server, disconnecting from the server when done. Its feature set is sufficient for most common and advanced database, table and data record operations, but it remains in active development to move towards the full functionality expected in a SQL database frontend.

== History ==

{{Proseline section|date=July 2024}}

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.

Ansgar Becker began development on a MySQL front-end in 1999 naming the project ''"MySQL-Front"'' and used a direct API layer written by Matthias Fichtner<ref>{{cite web|url=http://www.fichtner.net/delphi/mysql.delphi.phtml mysql.pas|title=Client API for MySQL Database Servers|publisher=audio-data.de|author=Matthias Fichtner|accessdate=2014-12-01|date=2011-09-15}}</ref> to interface with MySQL servers and contained databases.

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.

Private development continued up to version 2.5, until in April 2006, Ansgar open-sourced the application on [[SourceForge]], renaming the project ''"HeidiSQL"''. HeidiSQL was re-engineered to use a newer and more popular database-interface layer, ZeosLib,<ref>{{cite web||publisher=Sourceforge|url=http://sourceforge.net/projects/zeoslib/|title=ZeosLib - Delphi database components for MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle and SQLite|accessdate=2014-12-01|date=2014-10-21}}</ref> which debuted in the version 3.0 major release in April 2006.

Due to shortcomings in SourceForge project hosting and other advantages (such as performance, features), Ansgar shifted HeidiSQL's code repository and bug/feature tracker hosting to [[Google Code]] in May 2008. HeidiSQL was then rewritten to use a custom database-interface implementation rather than existing libraries.

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]].

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 ==

HeidiSQL has the following GUI features and capabilities.:<ref>{{citewebcite 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>{{citewebcite 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>

* '''Server connection'''

** Multiple saved sessions with connection and credentials stored within

*'''Server connection'''

** Compressed client/server protocol for compatible servers

**Multiple saved sessions with connection and credentials stored within

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

**Compressed client/server protocol for compatible servers

** Multiple parallelly running sessions in one window

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

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

**Multiple parallelly running sessions in one window

** Manage user privileges globally and per database

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

** Export databases to SQL files or to other servers

**Manage user privileges globally and per database

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

**Export databases to SQL files or to other servers

* '''Server host'''

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

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

*'''Server host'''

**View and filterEdit all server variables, sucheither for this session or with asglobal system_time_zonescope

**Edit allView server statistical variables, either forand thisaverage sessionvalues orper withhour global& scopesecond

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

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

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

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

* '''Databases'''

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

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

*'''Databases'''

** View allconnected databases' ontotal theand server,table connectsize toin aKB/MB/GB singlewithin the database/table to work with its tables andtree datastructure

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

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

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

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

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

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

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

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

** Edit view query and settings

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

** Edit viewprocedure SQL querybody and settingsparameters

** Edit proceduretrigger SQL body and parameterssettings

** Edit triggerscheduled event SQL body andtime settings

**Edit scheduled event SQL body time settings

==jHeidi==

{{Infobox software

| name = jHeidi

| logo = <!-- [[File: ]] -->

| screenshot = <!-- [[File: ]] -->

| caption =

| collapsible =

| author =

| developer =

| released = <!-- {{start date|YYYY|MM|DD}} -->

| discontinued =

| latest release version =

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

| latest preview version =

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

| frequently updated =

| programming language = [[Java (programming language)|Java]]

| operating system =

| platform =

| size =

| language =

| status =

| genre = Database management

| license =

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

}}

A version written in Java, which is designed to work on Mac and Linux computers, also exists. The jHeidi project has been discontinued since March 2010. http://www.heidisql.com/jheidi/

== See also ==

* [[Comparison of database administration tools]]

{{Portal|Free software}}

* [[DBeaver]]

* [[MySQL]]

* [[SQLyog]]

* [[MySQL Workbench]]

* [[phpMyAdmin]]

==References==

Line 113 ⟶ 81:

==External links==

* {{Official website}}

*[http://code.google.com/p/heidisql/ HeidiSQL project page] on [[Google Code]]

{{MySQL}}

Line 120 ⟶ 87:

[[Category:Database administration tools]]

[[Category:Windows-only free software]]

[[Category:MariaDB]]

[[Category:MySQL]]

[[Category:Microsoft database software]]

[[Category:2006 software]]

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