[SOLVED] MariaDB client for Linux? (excluding TOra, SQLDeveloper, Aqua Data Studio)

Pearlseattle · 05-23-2015, 04:06 PM

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:

TOra
Used it for a couple of months. Versions 2.x and 3.x are buggy.
SQLDeveloper
This is the one that I'm using right now, but it's an Oracle-puppet.
Aqua Data Studio
Too expensive
(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