Check that my sqlite database populated

Hello guys,
I've made a very simple application following the footsteps of
http://guides.rubyonrails.org/getting_started.html.
I managed to insert my objects (i checked the existence of inserted
objects through the rails console with a simple Foo.all ) but if I run
sqlite3 from command line and then run .databases I can't see any
database created.
I thought I could see the databases set in my database.yml ( database:
db/development.sqlite3 database: db/test.sqlite3 database: db/
production.sqlite3 ) but the .databases command shows nothing.

sqlite3 --version
3.5.6
rails -v
3.0.5
O.S. Windows 7

Thank you

Federico

You don’t see any of the databases you expected to see. What do you see when you run .databases?

B.

Well, when I run .databases i see something like an empty grid clearly indicating that there is no database.

I think i should see my rails’ databases (the ones resulting populated from rails console as i said before).

This is the first time i use sqlite but i think the command is right.

I don’t think i have 2 different instances of sqlite installed (one used by rails and another one where i use the .databases command). I can’t understand where is my sqlite database populated via rails and how can i verify my tables via sqlite console queries.

Thanks again

Well, when I run .databases i see something like an empty grid clearly indicating that there is no database.
I think i should see my rails' databases (the ones resulting populated from rails console as i said before).
This is the first time i use sqlite but i think the command is right.
I don't think i have 2 different instances of sqlite installed (one used by rails and another one where i use the .databases command). I can't understand where is my sqlite database populated via rails and how can i verify my tables via sqlite console queries.

Thanks again

Try rails dbconsole or script/dbconsole (not sure which for whatever version you are using) for the abstracted view of your Rails database. This also responds to the development (default) production and test keywords to select a specific database. This may also be a clue -- are you looking for the development database but finding production or test?

Walter

Well, when I run .databases i see something like an empty grid clearly indicating that there is no database.

I think i should see my rails’ databases (the ones resulting populated from rails console as i said before).

You misunderstand what .databases does. It lists all attached databases, not all the databases that exist (since a database is just a file anywhere on disk). If you just run sqlite3 there are no attached databases. If you run sqlite3 path/to/something.sqlite3 then it will attempt to load that database, you can also attach extra databases with the attach database command

Fred

That’s right. I did it. Shame on me for not reading carefully the documentation.
Thank you guys.