Php MyAdmin like Facility for Active Record

rubyonrails-talk
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

3

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

4

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

5

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.

6

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

7

http://railsdb.org/

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