LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-23-2015, 05:06 PM   #1
Pearlseattle
Member
 
Registered: Aug 2007
Location: Zurich, Switzerland
Distribution: Gentoo
Posts: 995

Rep: Reputation: 128Reputation: 128
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?
 
Old 05-23-2015, 05:28 PM   #2
beachboy2
Senior Member
 
Registered: Jan 2007
Location: Wild West Wales, UK
Distribution: Linux Mint 19.2 MATE, MX-19, Manjaro
Posts: 2,735
Blog Entries: 14

Rep: Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996Reputation: 996
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/
 
1 members found this post helpful.
Old 05-23-2015, 05:41 PM   #3
Pearlseattle
Member
 
Registered: Aug 2007
Location: Zurich, Switzerland
Distribution: Gentoo
Posts: 995

Original Poster
Rep: Reputation: 128Reputation: 128
Thank you!!
Never heard anything about Valentina!
(I knew pgAdmin but it's PostgreSQL-only...)
 
Old 12-31-2015, 12:13 PM   #4
Pearlseattle
Member
 
Registered: Aug 2007
Location: Zurich, Switzerland
Distribution: Gentoo
Posts: 995

Original Poster
Rep: Reputation: 128Reputation: 128
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
i need ns2 codes for DHAC,TEEN,TORA AND E-TORA AamirSohail Linux - Newbie 1 03-19-2014 03:45 AM
[SOLVED] Video - Studio 13.37 vs KXStudio, AV Linux, Dream Studio, and Ubuntu Studio l0wt3ch Studio 13.37 1 12-05-2012 08:45 PM
LXer: Aqua Data Studio 4.7 ships with Oracle DBA Tools LXer Syndicated Linux News 0 05-21-2006 07:54 PM
MySQL Access problem from Aqua Data Studio stedo Linux - Software 0 10-03-2003 03:57 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:23 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration