Software Alternatives & Reviews

5 Open-Source SQL IDEs for You to Learn and Explore

SQuirreL SQL HeidiSQL DBeaver TOra omnidb
  1. SQuirreL SQL is an open-source Java SQL Client program for any JDBC compliant database

    #Database Management #Databases #MySQL Tools

  2. HeidiSQL is a powerful and easy client for MySQL, MariaDB, Microsoft SQL Server and PostgreSQL. Open source and entirely free to use.
    Pricing:
    • Open Source
    Just over half the age of Squirrel, HeidiSQL has been my personal favorite for the past three years. It’s more restricted in its range of databases (you only get MySQL/MariaDB, SQL Server and PostgreSQL) but for many, that’s enough. I’ve found it very fast, which is vital for projects such as a 29-million-rows table; a select count (*) SQL command against MariaDB running on my PC takes around two minutes.

    #Database Management #Databases #MySQL Tools 1 user reviews

  3. DBeaver - Universal Database Manager and SQL Client.
    Pricing:
    • Open Source
    One thing to note: DBeaver doesn’t install drivers at the start, but fetches them as you need them (this is very “Eclipse-like”). That’s probably because it’s built on the Eclipse platform, so if you’re used to that, you’ll feel right at home. Certainly I had no problems with it; it felt very snappy. The range of export formats includes CSV, HTML and XML, as well as JSON and Markdown.

    #Databases #Database Management #MySQL Tools 93 social mentions

  4. 4
    tora - TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs.
    As you’d expect, Tora uses Qt for the user interface and is speedy, but it does feel a bit dated, especially when connecting to MySQL. If you’re working with Oracle, and you don’t have commercial software, use Tora; but for MySQL/PostgreSQL, or any of HeidiSQL, Squirrel and DBeaver is probably better.

    #Database Management #Database Tools #MySQL Tools

  5. 5
    NOTE: omnidb has been discontinued.
    An Open Source Web Tool for Database Management and Conversion
    I’m not a fan of web GUIs generally, but this looked great and works very well. HeidiSQL and DBeaver provide better import/export, but OmniDB is open to suggestions for future development. Just like the two Java clients, OmniDB is cross-platform, and has the most modern look and feel.

    #Database Management #Databases #MySQL Tools

Discuss: 5 Open-Source SQL IDEs for You to Learn and Explore

Log in or Post with