Php MyAdmin like Facility for Active Record

Rails
1

Hi,

We have a perfect Database Management Tool for MySql, Called Php
MyAdmin, which checks and shows the results of MySql querries

I am looking for such a tool, where i can check my querries with Active
Record and it shows me the results, based on my querries. Currently i
check all my querries in rails Console, but not to happy with it.

I am looking for a Php MyAdmin type solution. Is any one working with
such tools than pl. guide me.

Thanks in Advance.

2

Hi, what specific information are you needing because one of the
underlying
database engine for ActiveRecord is MySQL? You can check what MySQL
queries
are being invoked when you execute an ActiveRecord method by using of
the
following:
a) In the root of your rails application, you can invoke each of the
following in its own shell

 tail -f log/development.log

 script/console

b) In the root of your rails application, you can invoke the following
in a
shell:

 script/server

Please provide more information in regards to your question if the above
doesn’t answer your question.

Good luck,

-Conrad

On Tue, Sep 2, 2008 at 3:30 AM, Rahil K. <

3

On Tue, Sep 2, 2008 at 8:46 AM, Rahil K.
[email protected] wrote:

Thanks

Posted via http://www.ruby-forum.com/.

Frankly, Conrad’s right, we need more information. Phpmyadmin is
nothing but a web-based MySQL introspection and management tool that
happens to be written in PHP. It has nothing to do with how your
application accesses the database, so anything you can do now with
phpmyadmin you can do with any application that uses mysql, no matter
how it accesses the database (whether jdbc, php mysql drivers, or
ActiveRecord).

Jason

4

Jason R. wrote:

Frankly, Conrad’s right, we need more information. Phpmyadmin is
nothing but a web-based MySQL introspection and management tool that
happens to be written in PHP.

O.K. I repeat your words in my way.

I need a web-based RUBY management tool, in which i can write the
queries for active record and get instant views below.

Pl. see the link in my earlier thread to understand it better.

5

On Tue, Sep 2, 2008 at 9:39 AM, Rahil K.
[email protected] wrote:

O.K. I repeat your words in my way.

Well then, the only one I know of is Kawaii, thanks to your links.
You’re not going to find a “popular and used by many” tool like Kawaii
because, frankly, they don’t exist. Any such tool is still new and has
a long way to go, but that’s the beauty of open source. If you need
this tool, try it out and help develop it. Otherwise, if you really
need something and don’t want to try whats out there because it’s not
“popular”, then you need to write your own.

Jason

6

Sorry Conrad T.

Unfortunately your solution does not answer my question.

Pl. have a look here…
http://blog.forumwarz.com/kawaii/kawaii-find-all.png

Kawaii
http://code.google.com/p/kawaii/

This is a tool called Kawaii, and its created like Php Myadmin for
Active Records
only. The link above has few images too.

I am looking for such silution, which is popular and used by many, so
that i can get more help. Unfortnately Kawaii, being a new tool is not
that popular.

I hope i am clear by now…

Thanks

7

On 2008-09-02 02:46, Rahil K. wrote:

I am looking for such silution, which is popular and used by many, so
that i can get more help. Unfortnately Kawaii, being a new tool is not
that popular.

http://railsdb.org/

–
Greg D.

8

tail -f log/development.log
script/console

F-ing Sweeet!

9

I use two Rails plugins for monitoring what’s happening in the db:

Rails Footnotes [1] - To see the queries (and other stuff) in my app
(only in development, off course)
Rails Databrowser [2] - To see the tables and its contents

[1] http://github.com/drnic/rails-footnotes/tree/master
[2] http://redmine.milk-it.net/wiki/databrowser/AboutRailsDataBrowser