On 20 Apr 2011, at 20:17, Federico Rota <federico.rot...@gmail.com> wrote:
> 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 > 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 > > Il giorno 20/apr/2011, alle ore 16:09, Bryan Crossland > <bacrossl...@gmail.com> ha scritto: > >> On Tue, Apr 19, 2011 at 4:27 PM, Federico <federico.rot...@gmail.com> wrote: >> 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 >> >> >> You don't see any of the databases you expected to see. What do you see when >> you run .databases? >> >> B. >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby on Rails: Talk" group. >> To post to this group, send email to rubyonrails-talk@googlegroups.com. >> To unsubscribe from this group, send email to >> rubyonrails-talk+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/rubyonrails-talk?hl=en. > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.