Hi all, I''ve been reading a ton, doing tutorial, and generally trying to learn Ruby on Rails. I have a question that I haven''t been able to find the answer to. Where is the .db file that sqlite3 creates for Rails projects? I can''t for the life of me figure out how to access the database tables. I even downloaded a few sqlite GUI tools, but when they ask me which db file I''d like to open, I can''t find one anywhere. I even did a full search on my c: for *.db* Thanks for your help, Vince -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Mar 23, 12:50 pm, Vince Gilbert <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Hi all, > > I''ve been reading a ton, doing tutorial, and generally trying to learn > Ruby on Rails. > > I have a question that I haven''t been able to find the answer to. > > Where is the .db file that sqlite3 creates for Rails projects? I can''t > for the life of me figure out how to access the database tables. I even > downloaded a few sqlite GUI tools, but when they ask me which db file > I''d like to open, I can''t find one anywhere. I even did a full search > on my c: for *.db*Normally they''re in your_app/db and have the extension .sqlite3 Fred> > Thanks for your help, > > Vince > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
First look at your config/database.yml. In newly created rails application you''ll find location of your database file for all three environments (development, test and production). But this will not create your database. In order to create it run: rake db:create After that you''ll find your database file in db folder (if you didn''t change database.yml). For complete list of rake tasks run: rake -T On Mar 23, 1:50 pm, Vince Gilbert <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Hi all, > > I''ve been reading a ton, doing tutorial, and generally trying to learn > Ruby on Rails. > > I have a question that I haven''t been able to find the answer to. > > Where is the .db file that sqlite3 creates for Rails projects? I can''t > for the life of me figure out how to access the database tables. I even > downloaded a few sqlite GUI tools, but when they ask me which db file > I''d like to open, I can''t find one anywhere. I even did a full search > on my c: for *.db* > > Thanks for your help, > > Vince > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Bosko Ivanisevic wrote:> First look at your config/database.yml. In newly created rails > application you''ll find location of your database file for all three > environments (development, test and production). But this will not > create your database. In order to create it run: > > rake db:create > > After that you''ll find your database file in db folder (if you didn''t > change database.yml). For complete list of rake tasks run: > > rake -T > > On Mar 23, 1:50?pm, Vince Gilbert <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>Thank you very much for your replies. My application is up and running with data in it. I just couldn''t find the database. I want to go in and and a few columns and some more records. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---