# Php MyAdmin like Facility for Active Record

**URL:** <https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486>\
**Category:** Rails\
**Created:** [September 2, 2008, 12:30pm UTC](https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486 "2008-09-02T12:30:50Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![rahil](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ebca7d/32.png) [@rahil](https://www.ruby-forum.com/u/rahil)\
**Post date:** [September 2, 2008, 12:30pm UTC](https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486/1 "2008-09-02T12:30:50Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![rahil](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ebca7d/32.png) [@rahil](https://www.ruby-forum.com/u/rahil)\
**Post date:** [September 2, 2008, 2:00pm UTC](https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486/2 "2008-09-02T14:00:20Z")

</div>

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. \<

---

<div class="post-metadata">

**Author:** ![rahil](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ebca7d/32.png) [@rahil](https://www.ruby-forum.com/u/rahil)\
**Post date:** [September 2, 2008, 3:01pm UTC](https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486/3 "2008-09-02T15:01:30Z")

</div>

On Tue, Sep 2, 2008 at 8:46 AM, Rahil K.  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> ## Thanks
> 
> Posted via [http://www.ruby-forum.com/](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

---

<div class="post-metadata">

**Author:** ![rahil](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ebca7d/32.png) [@rahil](https://www.ruby-forum.com/u/rahil)\
**Post date:** [September 2, 2008, 3:39pm UTC](https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486/4 "2008-09-02T15:39:42Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![rahil](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ebca7d/32.png) [@rahil](https://www.ruby-forum.com/u/rahil)\
**Post date:** [September 2, 2008, 3:46pm UTC](https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486/5 "2008-09-02T15:46:40Z")

</div>

On Tue, Sep 2, 2008 at 9:39 AM, Rahil K.  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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

---

<div class="post-metadata">

**Author:** ![rahil](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ebca7d/32.png) [@rahil](https://www.ruby-forum.com/u/rahil)\
**Post date:** [September 2, 2008, 2:46pm UTC](https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486/6 "2008-09-02T14:46:18Z")

</div>

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](http://blog.forumwarz.com/kawaii/kawaii-find-all.png)

Kawaii  
[http://code.google.com/p/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

---

<div class="post-metadata">

**Author:** ![rahil](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ebca7d/32.png) [@rahil](https://www.ruby-forum.com/u/rahil)\
**Post date:** [September 2, 2008, 4:27pm UTC](https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486/7 "2008-09-02T16:27:13Z")

</div>

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/](http://railsdb.org/)

–  
Greg D.

---

<div class="post-metadata">

**Author:** ![rahil](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ebca7d/32.png) [@rahil](https://www.ruby-forum.com/u/rahil)\
**Post date:** [September 3, 2008, 5:58pm UTC](https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486/8 "2008-09-03T17:58:21Z")

</div>

> tail -f log/development.log  
> script/console

F-ing Sweeet!

---

<div class="post-metadata">

**Author:** ![rahil](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/ebca7d/32.png) [@rahil](https://www.ruby-forum.com/u/rahil)\
**Post date:** [September 3, 2008, 5:11pm UTC](https://www.ruby-forum.com/t/php-myadmin-like-facility-for-active-record/147486/9 "2008-09-03T17:11:20Z")

</div>

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](http://github.com/drnic/rails-footnotes/tree/master)  
[2] [http://redmine.milk-it.net/wiki/databrowser/AboutRailsDataBrowser](http://redmine.milk-it.net/wiki/databrowser/AboutRailsDataBrowser)
