Here’s the Deal

HeidiSQL vs pgModeler

437 69

4 0

When comparing HeidiSQL vs pgModeler, the Slant community recommends HeidiSQL for most people. In the question“What are the best relational database design and modelling tools?” HeidiSQL is ranked 4th while pgModeler is ranked 10th. The most important reason people chose HeidiSQL is:

Licensed under GNU GPL.

Specs

Database managementPostgreSQL, MariaDB, MySQL, SQL Server, SQLite

PlatformsWindows

TechnologyDelphi

LicenseGPL-2.0

Database managementPostgreSQL

PlatformsWindows, Linux, Mac

TechnologyC++, Qt

Ranked in these QuestionsQuestion Ranking

Common Questions

What are the best relational database design and modelling tools?

Pros

Pro
Free

Licensed under GNU GPL.

Pro
Portable

Alongside the possibility of downloading the installer and sourcecode, a portable version of the software is available.

Pro
Great UI and ease of use

HeidiSQL has a comprehensive and intuitive interface.

Pro
Syntax completion

Pro
Lightweight

Pro
Great user management

The user manager of HeidiSQL can easily set privileges on a per-database level or give access to only certain commands.

Pro
Data synchronization

HeidiSQL can compare and synchronize your data and structure between local and remote databases.

Pro
SSH tunnel

HeidiSQL allows connecting to your MySQL database via SSH tunnel.

Pro
Connect to servers via command line

You can use command line parameters to automate connections.

Pro
Works fine with Wine under Linux

Pro
Diff scripts

Can generate scripts to synchronize a database.

Pro
Reverse engineering

Can generate diagrams from an existing database.

Pro
Export formats

Can export to SQL script file, PNG, SVG or directly to PostgreSQL.

Ad
Cons

Con
Can be buggy

HeidiSQL is known to have some bugs that results in crashes.

Con
Intellisense is not intelligent

No intellisense for columns unless table name is aliased.

Con
UI design is very bad

Generic windows form

Con
No session backup

You cannot recover your session after close or even worse crash.

Con
Works under Linux only with Wine

It works quite well under Wine with Linux, but you must always take notice if the last version of HeidiSQL has been tested, for it may not run at all. There are some bugs in the Wine version that can be annoying and you have to kill the program and restart it. A native Linux version would be great.