Php MyAdmin like Facility for Active Record

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.

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

Sorry Conrad Taylor

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

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

Jason Roelofs 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.

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

http://railsdb.org/

tail -f log/development.log
script/console

F-ing Sweeet!

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