HeidiSQL 9.4 Listed on: File size: 4.41 MB Release status: Changes in version: Main sections Community Partners Share free software and game downloads.

1. HeidiSQL is an easy-to-learn and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It lets you browse and edit data, create and edit tables, views, procedures, triggers and scheduled events.
2. DBeaver - Universal Database Manager and SQL Client. DBeaver is free and open source.
3. Download Java for OS X directly from Oracle. Get the latest version If an app or webpage you want to use asks you to install Java software, you can download the current version of Java for OS X directly from Oracle's website.

HeidiSQL is a free and open-source administration tool for MySQL and its forks, as well as Microsoft SQL Server, PostgreSQL and SQLite. Its codebase 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.^[2]

A version written in Java, jHeidi, was designed to work on Mac and Linux computers. It was discontinued in March 2010 in favor of Wine support.

History[edit]

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^[3] 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 the original software.^[4][5]

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.

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.

Features[edit]

HeidiSQL has the following GUI features and capabilities.^[6][7]

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

How To Use Heidisql

See also[edit]

References[edit]

1. ^'Releases - HeidiSQL/HeidiSQL'. github.com. Retrieved 2020-01-13.
2. ^'heidi?'. www.heidisql.com.
3. ^Matthias Fichtner (2011-09-15). 'Client API for MySQL Database Servers'. audio-data.de. Archived from the original on 2002-08-08. Retrieved 2014-12-01.
4. ^'the truth about heidiSQL history in wikipedia'. www.heidisql.com.
5. ^'Zu: Announcement: End of MySQL-Front ? Some words from...'www.heidisql.com.
6. ^'Partial list of major features'. HeidiSQL. Retrieved 2014-12-01.
7. ^'Screenshots of GUI features and descriptions'. HeidiSQL. Retrieved 2014-12-01.

External links[edit]

• Official website

Is your Mac up to date with the latest version of the Mac operating system (macOS or OS X)? Is it using the version required by some other product that you want to use with your Mac? Which versions are earlier (older) or later (newer, more recent)? To find out, learn which version is installed now.

If your macOS isn't up to date, you may be able to update to a later version.

Which macOS version is installed?

From the Apple menu  in the corner of your screen, choose About This Mac. You should see the macOS name, such as macOS Mojave, followed by its version number. If you need to know the build number as well, click the version number to see it.

This example shows macOS Catalina version 10.15 build 19A583.

Which macOS version is the latest?

These are all Mac operating systems, starting with the most recent. When a major new macOS is released, it gets a new name, such as macOS Catalina. As updates that change the macOS version number become available, this article is updated to show the latest version of that macOS.

How To Download MacOS Installers For New & Old Versions

If your Mac is using an earlier version of any Mac operating system, you should install the latest Apple software updates, which can include important security updates and updates for the apps that are installed by macOS, such as Safari, Books, Messages, Mail, Music, Calendar, and Photos.