Is There a "Phpmyadmin" for Ruby on Rails

Is there a phpmyadmin for Ruby on Rails?

finally, I hope, I can help you. This is my last project, because it was something what I missed for longer time.

https://github.com/robinbortlik/db_explorer

It is called DB explorer, it is application like phpMyAdmin, but written in Ruby on Rails. It is not exactly like, phpMyAdmin, because it not allow you so many configuration options. It is simple solution for browsing your DB, searching and editing data. You can connect many databases and different types like MySQL, PostgeSQL and Sqlite3.

Lets, try it, and let me know if there is something wrong, or something what would be great to have implemented.

Here are some screenshots

Ruby on Rails & Remote MySQL

It is possible, of course.

Basically, you have two ways of doing this.

The import/export way and the programmer's way.

Programmer's way (not recommended, in my humble opinion):

Assuming you build your application in a way that can access the data in your remote db, you should do two things:

I. Make your remote DB accessible from the server you're working on. There are many posts available on how to do that, either by a)using PHPMyadmin or b)directly, commandline, from your remote server.

For instance, respectively:

a) Select your DB in PHPMyAdmin, go to privileges and add an entry for your remote access.

b) GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD'; and then restart your dbserver

II. In your rails app, assuming you already work with another db, you should probably do something like this:

http://apidock.com/rails/ActiveRecord/Base/establish_connection/class

Import/Export

Anyhow, I would go to export/import... And I would chose the CSV way.... RoR is magically simple for importing csv data. It is easy to import CSV data, apply some transforms to make it compatible to your model and save to your new DB.

This railscast shows how to import data from csv files.

http://railscasts.com/episodes/396-importing-csv-and-excel

Is there a go-to GUI or visual interface that can be used with the PostgreSQL database in Ruby on Rails?

Table Plus is great. Far better than Sequel Pro IMHO.

If you're looking for a Rails Admin alternative, I would check out Active Admin

can't run both phpmyadmin and rails server on cloud9

phpMyAdmin is just another PHP application, so it doesn't listen on a port. You should instead check your webserver configuration to see what port it is on. Most webservers tend to default to port 80, though, so it might be some other process.

You can use netstat -tulpn | grep 8080 to find what's using that port and modify either your Rails configuration or the other process to use a different port.

---

Related Topics