Specifically I'm looking for a native Linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential.

link|improve this question
3  
phpmyadmin? (phpmyadmin.net) – knittl Mar 25 '10 at 20:01
I think he's looking for a desktop app rather than a web based one – gacrux Mar 25 '10 at 20:03
yea..I'd like an alternative to phpmyadmin..definitely a desktop app. Something similar to the apps I mentioned – jim Mar 25 '10 at 20:06
feedback

migrated from stackoverflow.com Mar 27 '10 at 2:34

This question came from our site for professional and enthusiast programmers.

9 Answers

squirrelsql my favourite although I am a netbeans user. You only need the jdbc driver jar. See the screenshots. There are a lot of very useful plugins where you can copy the entire database, view the relations graphically etc. (independent of the db, of course)

Also take a look at this and that question.

link|improve this answer
Big +1, also my favorite tool. – Pascal Thivent Mar 25 '10 at 20:41
feedback

MySql Workbench for MySql DBs

link|improve this answer
Thanks for the suggestion. I do use Workbench for visually modeling my database relations. However, I found that it is terrible at data management (editing data, viewing rows etc.) – jim Mar 25 '10 at 20:08
feedback

I like Squirel SQL, the universal SQL client. Not pretty, but does the job.

link|improve this answer
Come on, it's not that bad... it's even reasonably pretty for an SQL client. – sleske Dec 29 '10 at 0:03
feedback

CrunchyFrog. Cross-database, cross-platform, and decently powerful.

link|improve this answer
feedback

pgAdmin for PostgreSQL database

link|improve this answer
too bad its not for mySql as well... – jim Mar 25 '10 at 20:12
feedback

Never needed such tool, but I have noticed that NetBeans IDE which I'm using for code editing seems to have pretty decent UI for basic database operations.

http://db.netbeans.org/

And I strongly suspect Eclipse community has similar plugin.

link|improve this answer
feedback

http://www.dbvis.com/ DBVisualizer the free version is awesome

link|improve this answer
feedback

I wrote an database design application dbwrench. Although it is not a native Linux app it will run on Linux. It isn't free either, but I think it is reasonably priced.

link|improve this answer
feedback

Though I already upvoted a SquirrelSQL answer, if you use Eclipse you may also like SQL Explorer (http://eclipsesql.sourceforge.net/)

link|improve this answer
feedback

Your Answer

 
or
required, but never shown