Ruby Forum Ruby on Rails > mysql frontend for linux.

Hi list.

I'm using Ubuntu distro. for rails development. Today, to my disappoint,
I've found that there're certainly almost no mysql frontend which runs
very well.

(1) mysql-query-browser: Seems to be very nice. But, it quickly exits
when I press ctrl+enter or modify a table structure. Something strange
is happening here, but I can not figure out what it is.

(2) phpmyadmin: Too slow. It even does not provide AJAX facility which
is painful.

(3) DBEdit: Eclipse plugin. No table modification feature.

What I need is a mysql front end that supports table modification
and table field ordering feature. Both of them were shown in the demo
using some OSX apps built on Cocoa, but I failed to find something
parallel in linux.

Could anybod recommend me a better frontend? It would be
appreciated.

Sincerely,
Minkoo Seo

> I'm using Ubuntu distro. for rails development. Today, to my disappoint,
> I've found that there're certainly almost no mysql frontend which runs
> very well.

theres a lot of half-baked ones out there:

1 mysql-query-browser: unstable/broken/unmaintained?

2 pma: v slow and requires php and often you lose your place on actions 
and have to drill back down..

3 http://sourceforge.net/projects/mysqlnavigator , i found it very 
finicky and clicky and its few features are hidden via epanda-tree 
things or right click and a plethora of tiny windows, by "features" i 
mean a text box with some skeleton SQL pre-populated, if youre lucky. 
plus it requires QT

4 MysqlFront and Navicat both failed to work correctly in WINE, 
navicat-linux was not linked to my 64bit mysql libs, and non-free 
anyways..

5 svn co http://gmysqlcc.thepozer.org/svn/trunk gmysqlcc <- its alive. 
you can't sort columns yet.

6 http://ta.twi.tudelft.nl/ftp/dv/lemmens/gequel-1.11.jpg <- puke?

7 http://www.tksql.org/ after you install a half-dozen 
too-obscure-to-be-in-apt Tk extensions you can be in awe of its awesome 
early-90s looking interface

8 http://mr.jankowski.webpark.pl/QtMyAdmin/ <- havent tried it, maybe 
useful if you have QT

  but none of these are much of an improvement over:

9 ActiveRecord::Base.connection.select_all.each do |row|
  tr do
    row.keys.each do |key|
      td row[key]
    end
  end
end unless "now we're talkin" != true

Minkoo Seo wrote:
> Hi list.
> 
> I'm using Ubuntu distro. for rails development. Today, to my disappoint,
> I've found that there're certainly almost no mysql frontend which runs
> very well.
> 
> (1) mysql-query-browser: Seems to be very nice. But, it quickly exits
> when I press ctrl+enter or modify a table structure. Something strange
> is happening here, but I can not figure out what it is.

That bug is known in mysql-query-browser, use mysql-admin until they get 
some stable packages back into the repository.

Also, learn to use migrations .. much faster that using a GUI tool.

(in GUI tool, you still have to type table/column names, etc.)

1. Use any crappy tool to create an empty schema and manage DB 
privileges

2. Use migrations to create and modify all your tables.

3. Flip over to an Eclipse data perspective when you want to test a 
query or get a quick look at table contents

4. Scratch your head and wonder how you put up with managing schemas 
without graceful incremental revision and rollback

Minkoo Seo wrote:
> Hi list.
> 
> I'm using Ubuntu distro. for rails development. Today, to my disappoint,
> I've found that there're certainly almost no mysql frontend which runs
> very well.
> 
> (1) mysql-query-browser: Seems to be very nice. But, it quickly exits
> when I press ctrl+enter or modify a table structure. Something strange
> is happening here, but I can not figure out what it is.
> 
> (2) phpmyadmin: Too slow. It even does not provide AJAX facility which
> is painful.
> 
> (3) DBEdit: Eclipse plugin. No table modification feature.
> 
> What I need is a mysql front end that supports table modification
> and table field ordering feature. Both of them were shown in the demo
> using some OSX apps built on Cocoa, but I failed to find something
> parallel in linux.
> 
> Could anybod recommend me a better frontend? It would be
> appreciated.
> 
> Sincerely,
> Minkoo Seo

I'm using mysql-query-browser on Dapper and it works okay. But if you're
having problems with it, trying mysql-admin, which  also provides table
editing in a decent interface. I also use mysql-navigator and find it to 
be
suitable.

mysql-admin doesn't work for me either. it won't let me add more than
one column to a table! not very useful!

try db visualizer, its a java app and works on debian just fine.

http://www.minq.se/products/dbvis/

François Montel wrote:
> I'm using mysql-query-browser on Dapper and it works okay. But if you're
> having problems with it, trying mysql-admin, which  also provides table
> editing in a decent interface. I also use mysql-navigator and find it to 
> be
> suitable.

I've always been a fan of phpmyadmin. Since you are using Ubuntu you can
install it right through apt, or if you have apache already installed 
and
running php you can download it your (http://www.phpmyadmin.net). I've
always used this on windows/*nix/os x and it works great.

-Nick

p.s. Not affiliated with phpmyadmin in any way shape or form, just been 
a
user for a few years now.

p.p.s. I have used mysql admin, and it did work for me on kubuntu with 
out
any major issues. Still go back to phpmyadmin though, and the 'free' 
version
of db visualizer is a little crippling for my taste, but its not a bad
product either.

Kexi is the best I have found. It is a KDE app, but I find KDE apps tend 
to be more stable, and functionally than GTK apps anyways

Minkoo Seo wrote:
> (1) mysql-query-browser: Seems to be very nice. But, it quickly exits
> when I press ctrl+enter or modify a table structure. Something strange
> is happening here, but I can not figure out what it is.

Also crashes on Mac OS X a lot (the UB build).  I have to be very gentle 
with it.  I've been using Migrations now and that seems to have taken 
the pain out of it all.