HeidiSQL: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 11:11, 1 December 2006 edit 212.101.199.148 (talk) No edit summary ← Previous edit		Latest revision as of 14:23, 16 July 2025 edit undo Citation bot (talk \| contribs) Bots 5,868,551 edits Removed parameters. \| Use this bot. Report bugs. \| #UCB_CommandLine
(188 intermediate revisions by more than 100 users not shown)
Line 1: {{Short description\|Administration tool for relational databases}} ~~{{linkless\|September 2006}}~~ {{refimprove\|date=September 2014}} ~~{{Infobox_Software~~ {{Infobox software ~~\|name = HeidiSQL~~ \|~~logo~~ name = HeidiSQL \| logo = HeidiSQL logo image.png ~~\|caption =~~ \| 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. ~~\|developer = Ansgar Becker~~ \| collapsible = ~~\|latest_release_version = 3.0 RC3~~ \| author = Ansgar Becker ~~\|latest_release_date = [[August 2]], [[2006]]~~ \| developer = ~~\|operating_system = [[Microsoft Windows]]~~ \| released = {{start date and age\|2006\|04}} ~~\|genre = Database management~~ \| discontinued = ~~\|license = [[GNU General Public License]]~~ \| latest release version = {{wikidata\|property\|edit\|reference\|P348}} ~~\|website = [http://www.heidisql.com/ www.heidisql.com]~~ \| 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/}} }} ~~{{portal\|Free software\|Floss draft.png}}~~ ~~'''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.~~ '''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]]''. The releases with version numbers below 3.0 were known as MySQL-Front until 2.5. The name has changed in 2006, as Ansgar Becker took his old sources and put them into a new open-source-project at [[SourceForge]] in April 2006. == History == ~~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.~~ {{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. The team around HeidiSQL currently consists of [http://sourceforge.net/project/memberlist.php?group_id=164593 five moreorless official developers] and one designer. The team-members are working on HeidiSQL in their spare time. 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 == ~~== [http://download.heidisql.com/ Releases] ==~~ * [http://sourceforge.net/project/showfiles.php?group_id=164593&package_id=186427&release_id=410106 3.0 Beta] (released on 2006-04-16) * [http://sourceforge.net/project/showfiles.php?group_id=164593&package_id=186427&release_id=414609 3.0 RC1] (released on 2006-05-03) * [http://sourceforge.net/project/showfiles.php?group_id=164593&package_id=186427&release_id=414924 3.0 RC2] (released on 2006-05-05) * [http://sourceforge.net/project/showfiles.php?group_id=164593&package_id=186427&release_id=436877 3.0 RC3] (released on 2006-08-04) 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> ~~== See also ==~~ * '''Server connection''' [[phpMyAdmin]] * Multiple saved sessions with connection and credentials stored within Compressed client/server protocol for compatible servers Interface with servers via [[TCP/IP]], [[named pipes]] (sockets) or a [[tunneling protocol]] (SSH) 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 ~~External links~~ also== * [[Comparison of database administration tools]] [http://www.heidisql.com/ Official website] [http://www.heidisql.com/forum/ Forum] ==References== [http://sourceforge.net/projects/heidisql/ HeidiSQL project page] on [[SourceForge]] {{Reflist}} [http://bugs.heidisql.com/ Bugtracker] [http://rfe.heidisql.com/ Featuretracker] ==External links== * {{Official website}} {{MySQL}} [[Category:Database administration tools]] [[Category:~~Free~~Windows-only free software]] [[Category:~~Windows-only software~~MariaDB]] [[Category:~~SourceForge projects~~MySQL]] [[Category:Microsoft database software]] [[Category:2006 software]] [[Category:Pascal (programming language) software]]