HeidiSQL
   HOME

TheInfoList



OR:

HeidiSQL is a free and open-source administration tool for
MariaDB MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the ori ...
,
MySQL MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database ...
, as well as
Microsoft SQL Server Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which ...
, PostgreSQL and
SQLite SQLite (, ) is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the m ...
. Its
codebase In software development, a codebase (or code base) is a collection of source code used to build a particular software system, application, or software component. Typically, a codebase includes only human-written source code files; thus, a codeb ...
was originally taken from Ansgar Becker's own MySQL-Front 2.5 software. Due to having sold 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 is an anime television series produced by Zuiyo Eizo and is based on the novel '' Heidi's Years of Wandering and Learning'' by Johanna Spyri (1880). It was directed by Isao Takahata and features contributions by numerous other anime fi ...
''. A version written in
Java Java (; id, Jawa, ; jv, ꦗꦮ; su, ) is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea to the north. With a population of 151.6 million people, Java is the world's mos ...
, jHeidi, was designed to work on Mac and Linux computers. It was discontinued in March 2010 in favor of
Wine Wine is an alcoholic drink typically made from fermented grapes. Yeast consumes the sugar in the grapes and converts it to ethanol and carbon dioxide, releasing heat in the process. Different varieties of grapes and strains of yeasts are m ...
support.


History

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 to interface with MySQL servers and contained databases. 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 Cloning is the process of producing individual organisms with identical or virtually identical DNA, either by natural or artificial means. In nature, some organisms produce clones through asexual reproduction. In the field of biotechnology, c ...
the original software. In April 2006, Becker open-sourced the application on
SourceForge SourceForge is a web service that offers software consumers a centralized online location to control and manage open-source software projects and research business software. It provides source code repository hosting, bug tracking, mirroring ...
, 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. Support for
Microsoft SQL Server Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which ...
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 Transifex (previously known as Indifex) is a globalization management system (GMS), which is a proprietary, web-based translation platform. It targets technical projects with frequently updated content, such as softwares, documentations, and we ...
. 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 Microsoft Store (formerly known as Windows Store) is a digital distribution platform operated by Microsoft. It started as an app store for Windows 8 and Windows Server 2012 as the primary means of distributing Universal Windows Platform app ...
.
SQLite SQLite (, ) is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the m ...
support was introduced in March 2020 for the 11.0 release.


Features

HeidiSQL has the following GUI features and capabilities. *Server connection **Multiple saved sessions with connection and credentials stored within **Compressed client/server protocol for compatible servers **Interface with servers via
TCP/IP The Internet protocol suite, commonly known as TCP/IP, is a framework for organizing the set of communication protocols used in the Internet and similar computer networks according to functional criteria. The foundational protocols in the suit ...
, named pipes (sockets) or a
tunneling protocol In computer networks, a tunneling protocol is a communication protocol which allows for the movement of data from one network to another. It involves allowing private network communications to be sent across a public network (such as the Internet ...
(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 also

* Comparison of database administration tools


References


External links

* {{MySQL Database administration tools Windows-only free software MariaDB MySQL Microsoft database software 2006 software Pascal (programming language) software