Skip to content
Tech News
← Back to articles

HeidiSQL – Lightweight MariaDB, MySQL, SQL Server, PostgreSQL and SQLite Manager

read original get HeidiSQL Database Management Tool → more articles
Why This Matters

HeidiSQL offers a versatile, lightweight graphical interface for managing multiple database systems, making database administration more accessible and efficient for both developers and database administrators. Its support for various databases and export options enhances productivity and simplifies complex tasks, benefiting the broader tech industry and end-users alike.

Key Takeaways

HeidiSQL

HeidiSQL is a graphical interface for managing MariaDB or MySQL servers, Microsoft SQL databases, PostgreSQL, SQLite, Interbase or Firebird. "Heidi" lets you browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data, either to SQL file, clipboard or to other servers. Read about features or see some screenshots.

Need help?

Look at the online help page to learn how to use HeidiSQL. The forum is meant to ask questions. The issue tracker is the place to report bugs or request new features.

Building

For compiling on platforms other than Windows, look at the lazarus branch.

Delphi 12.1 is required for building HeidiSQL for Windows. Older Delphi versions will most likely fail; newer Delphi versions may work or fail. Unfortunately, Lazarus or one of the other free compilers cannot currently compile HeidiSQL.

Once Delphi is installed, you need to load the SynEdit project from the components folder. Build both run-time and design-time packages. Install the design-time package. Do the same for the VirtualTree component project.

Second you need install madExcept.

Third compile *.rc files:

... continue reading