HeidiSQL

HeidiSQL

Main view of a session, with the database tree on the left and details on the right
Original author(s)	Ansgar Becker
Stable release	9.3 / August 8, 2015 (2015-08-08)
Written in	Object Pascal
Operating system	Windows
Type	Database management
License	GPL
Website	www.heidisql.com

HeidiSQL, previously known as MySQL-Front, is a free and open source client, or frontend for MySQL (and for its 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 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

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^[1] to interface with MySQL servers and contained databases.

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,^[2] 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.

PostgreSQL support was introduced in March 2014 for the 9.0 release.

Features

HeidiSQL has the following GUI features and capabilities.^[3]^[4]

Server connection
- 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 coallation, drop (delete) databases
Tables, views, procedures, triggers and events
- View all objects within 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

jHeidi

jHeidi
Written in	Java
Type	Database management
Website	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/

References

↑ Matthias Fichtner (2011-09-15). mysql.pas "Client API for MySQL Database Servers" Check |url= value (help). audio-data.de. Retrieved 2014-12-01.
↑ "ZeosLib - Delphi database components for MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle and SQLite". Sourceforge. 2014-10-21. Retrieved 2014-12-01.
↑ "Partial list of major features". HeidiSQL. Retrieved 2014-12-01.
↑ "Screenshots of GUI features and descriptions". HeidiSQL. Retrieved 2014-12-01.

External links

MySQL

Editions	MySQL MySQL Enterprise MySQL Cluster

MySQL tools	MySQL Workbench SQLyog phpMyAdmin HeidiSQL Navicat Database Workbench

Storage engines	MyISAM Falcon InnoDB XtraDB MySQL Federated MySQL Archive Aria TokuDB

Forks and Branches	Drizzle MariaDB Percona Server WebScaleSQL

This article is issued from Wikipedia - version of the Wednesday, February 24, 2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.