Database in Rails application

Question

I cannot find where the database in my Rails application is located. I looked in folders like /db, /db/migrate, and /app/models, but cannot find the actual database that I can open to examine the data. Where is it located?

What do you have defined as your database in config/database.yml? — Jeremy Rodi
– Jeremy Rodi, Commented Oct 15, 2012 at 18:39

Jason Swett · Accepted Answer · 2012-10-15 18:40:20Z

2

Try running rails dbconsole from the command line while you're inside your project directory.

answered Oct 15, 2012 at 18:40

Jason Swett

45.4k70 gold badges231 silver badges360 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jason Swett Over a year ago

And before THAT, if you haven't already, fill in config/database.yml with the appropriate stuff.

Paul S. Over a year ago

Looks like it's already been configured by my host... thanks anyway!

Yogzzz · Accepted Answer · 2012-10-16 09:34:33Z

0

If you're running a SQLite Db (which rails runs by default), you can download SQLite DB Browser (http://sqlitebrowser.sourceforge.net/), and open your db/sqlite3 file to view the actual data, or if you're using mysql, check out: http://www.sequelpro.com/

answered Oct 16, 2012 at 9:34

Yogzzz

2,7955 gold badges39 silver badges56 bronze badges

Collectives™ on Stack Overflow

Database in Rails application

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related