Where is this Rails file stored? db/development.sqlite3

Question

I'm trying to find the sqlite database file that rails creates.

Sorry if this is a dumb question but which folder is this file stored in?

I've looked in all of the folders in my Rails project and can't find it.

My database.yml:

   development:
      adapter: sqlite3
      database: db/development.sqlite3
      pool: 5
      timeout: 5000

Haustorium

Answer 1

It's in RAILS_ROOT/db/development.sqlite3

Piotr

what if u do a capistrano deploy? – Greggrega

Answer 2

You can find your database file after you have give "scaffold" command at following directory If you are in your project folder then then go to "DB" folder then you can see "development.sqlite3" file this is the sqlite database file

Jayejaylene

Answer 3

In latest version of Rails the file will be in storage folder

Elexa

Answer 4

FWIW the file might not exist if you haven't done rake db:create yet.

Northeast

Answer 5

sqlite://db/development.sqlite3

Jawbreaker

What is this telling us? It looks like a URL, but pasting it into my browser (Firefox) does't yield anything useful – just a Google search that brings me back here :-). Is it just shorthand for the first answer? – Remora

This is not correct. – Alek