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. | |
Original author(s) | Ansgar Becker |
---|---|
Initial release | April 2006; 14 years ago |
Stable release | |
Repository | https://github.com/HeidiSQL/HeidiSQL |
Written in | Object Pascal |
Operating system | Windows |
Type | Database management |
License | GPLv2 |
Website | www.heidisql.com |
Ansgar, Mac OS still support Wine, but doesn't support 32 bit. However, you provide 64 bit portable version so it should work. Unfortunately, it doesn't:(Bug report and log from Wine's console in attachment. Download FileZilla Client for Mac OS X. The latest stable version of FileZilla Client is 3.51.0. Please select the file appropriate for your platform below.
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.
How To Use Heidisql
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
See also[edit]
References[edit]
- ^'Releases - HeidiSQL/HeidiSQL'. github.com. Retrieved 2020-01-13.
- ^'heidi?'. www.heidisql.com.
- ^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.
- ^'the truth about heidiSQL history in wikipedia'. www.heidisql.com.
- ^'Zu: Announcement: End of MySQL-Front ? Some words from...'www.heidisql.com.
- ^'Partial list of major features'. HeidiSQL. Retrieved 2014-12-01.
- ^'Screenshots of GUI features and descriptions'. HeidiSQL. Retrieved 2014-12-01.
External links[edit]
- Official website
Retrieved from 'https://en.wikipedia.org/w/index.php?title=HeidiSQL&oldid=985435698'
Check compatibility
You can upgrade to OS X El Capitan from OS X Snow Leopard or later on any of the following Mac models. Your Mac also needs at least 2GB of memory and 8.8GB of available storage space.
MacBook introduced in 2009 or later, plus MacBook (13-inch, Aluminum, Late 2008)
MacBook Air introduced in late 2008 or later
MacBook Pro introduced in mid 2007 or later
Mac mini introduced in early 2009 or later
iMac introduced in mid 2007 or later
Mac Pro introduced in early 2008 or later
Xserve models introduced in early 2009
MacBook Air introduced in late 2008 or later
MacBook Pro introduced in mid 2007 or later
Mac mini introduced in early 2009 or later
iMac introduced in mid 2007 or later
Mac Pro introduced in early 2008 or later
Xserve models introduced in early 2009
To find your Mac model, memory, storage space, and macOS version, choose About This Mac from the Apple menu . If your Mac isn't compatible with OS X El Capitan, the installer will let you know.
Make a backup
Before installing any upgrade, it’s a good idea to back up your Mac. Time Machine makes it simple, and other backup methods are also available. Learn how to back up your Mac.
Get connected
It takes time to download and install OS X, so make sure that you have a reliable Internet connection. If you're using a Mac notebook computer, plug it into AC power.
Download OS X El Capitan
For the strongest security and latest features, find out whether you can upgrade to macOS Catalina, the latest version of macOS.
If you still need OS X El Capitan, use this link: Download OS X El Capitan. A file named InstallMacOSX.dmg will download to your Mac.
Install the macOS installer
Double-click the downloaded file to open a window showing its contents. Then double-click the file within, named InstallMacOSX.pkg.
Follow the onscreen instructions, which will guide you through the steps necessary to install.
Heidisql Tutorial
Begin installation
After installation of the installer is complete, open the Applications folder on your Mac, then double-click the file named Install OS X El Capitan.
Click Continue and follow the onscreen instructions. You might find it easiest to begin installation in the evening so that it can complete overnight, if needed.
Allow installation to complete
Please allow installation to complete without putting your Mac to sleep or closing its lid. Your Mac might restart, show a progress bar, or show a blank screen several times as it installs both OS X and related updates to your Mac firmware.
Learn more
- OS X El Capitan won't install on top of a later version of macOS, but you can erase your disk first or install on another disk.
- You can use macOS Recovery to reinstall macOS.