LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   MariaDB client for Linux? (excluding TOra, SQLDeveloper, Aqua Data Studio) (https://www.linuxquestions.org/questions/linux-software-2/mariadb-client-for-linux-excluding-tora-sqldeveloper-aqua-data-studio-4175543427/)

Pearlseattle 05-23-2015 04:06 PM

MariaDB client for Linux? (excluding TOra, SQLDeveloper, Aqua Data Studio)
 
Hi

I need a GUI to write and execute SQLs for (at least) MariaDB (SQLite, PostgreSQL, DB2, Oracle would be as well welcome).

The base functionality that I need is to be able to run single SQLs that are part of a single long text document (including stopping them while they're executing) and show their execution plans.
The whole thing has to be reactive - web-UIs are excluded.

So far I tried:
  1. TOra
    Used it for a couple of months. Versions 2.x and 3.x are buggy.
  2. SQLDeveloper
    This is the one that I'm using right now, but it's an Oracle-puppet.
  3. Aqua Data Studio
    Too expensive
  4. (old version of TOAD, but of course only on Windows - used to be good before they overloaded it)
Are there any other alternatives?

beachboy2 05-23-2015 04:28 PM

Pearlseattle,

Both are open source.

Valentina Studio Free:
https://www.valentina-db.com/en/stor...lentina-studio

pgAdmin:
http://www.pgadmin.org/

http://www.heatware.net/free-softwar...i-client-tool/

Pearlseattle 05-23-2015 04:41 PM

Thank you!!
Never heard anything about Valentina!
(I knew pgAdmin but it's PostgreSQL-only...)

Pearlseattle 12-31-2015 11:13 AM

I think that I've tried all opensource and ~free SQL editors.

Therefore, after millions of tests, the winner is:
DBeaver

It's not overloaded with features, has good focus on freestyle sql, is fully customizable, good tab-switching, etc..., and so far it seems to be working well.

With the others (MySQL Workbench, Valentina, Tora, SQLDeveloper, Squirrel SQL, ...) I always had some kind of issue with scripts and/or layouts and/or execution plans, etc... .

Cheers


All times are GMT -5. The time now is 06:33 PM.