HeidiSQL: Difference between revisions

Revision as of 07:54, 29 December 2018

Latest revision as of 14:23, 16 July 2025

(30 intermediate revisions by 24 users not shown)

Line 1:

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

{{refimprove|date=September 2014}}

{{Infobox software

Line 4 ⟶ 5:

| logo = HeidiSQL logo image.png

| screenshot = HeidiSQL main screenshot.png

| 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|2006|04}}

| discontinued =

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

| latest release date = {{startwikidata|qualifier|P348|P577}} date({{Time andago| age{{wikidata|2017qualifier|12raw|19P348|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

| status =

| genre = Database management

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

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

}}

'''HeidiSQL''' is a [[Free and open-source software|free and open-source]] administration tool for [[MySQLMariaDB]] and its, [[Fork (software development)|forksMySQL]], as well as [[Microsoft SQL Server]], [[PostgreSQL]] and [[PostgreSQLSQLite]]. Its [[codebase]] was originally taken from Ansgar Becker's own MySQL-Front 2.5 software. DueAfter to having soldselling 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]]''.<ref>https://www.heidisql.com/forum.php?t=19</ref>

A version written in [[Java (programming language)|Java]], jHeidi, was designed to work on Mac and Linux computers. It was discontinued in March 2010 in favor of [[Wine (software)|Wine]] support.

== History ==

{{Proseline section|date=July 2024}}

Ansgar Becker began development on a MySQL front-end in 1999, naming the project "MySQL-Front" and usedusing 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 containedthe 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, ZeosLib, 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>

In April 2006, Becker 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, which debuted in version 3.0.

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.

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.

AjHeidi—a version written in [[Java (programming language)|Java]], jHeidi, was designed to work on Mac and Linux computers. It wascomputers—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.; Translationstranslations 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 collation, 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 the 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

==See also==

* [[Comparison of database administration tools]]

==References==

Line 91 ⟶ 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]]