I''m running my rails environment in cygwin. I have the older 1.2.6 rails. I installed sqlite3 with their online installer (sqlite 3.5.1) when I create a db with the command: sqlite3 test.db I do no get a db, I just goes to the sqlite command prompt. Am I creating the db wrong? I''m on version sqlite3 3.5.1 or is my sqlite3 not installed correctly. What is the optimal sqlite3 version? -- 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 -~----------~----~----~----~------~----~------~--~---
It should automatically create the DB for you in your rails app. On Jan 15, 2008 6:04 PM, Feng Tien <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > I''m running my rails environment in cygwin. > > I have the older 1.2.6 rails. > > I installed sqlite3 with their online installer (sqlite 3.5.1) > > when I create a db with the command: sqlite3 test.db > > I do no get a db, I just goes to the sqlite command prompt. > > Am I creating the db wrong? I''m on version sqlite3 3.5.1 or is my > sqlite3 not installed correctly. > > What is the optimal sqlite3 version? > -- > Posted via http://www.ruby-forum.com/. > > > >-- Ryan Bigg http://www.frozenplague.net Feel free to add me to MSN and/or GTalk as this email. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
So I do not need to manually create the db? It will autogen for me when I set it in my yaml? -- 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 -~----------~----~----~----~------~----~------~--~---
No, when you rake db:migrate DaveP On Jan 15, 5:56 pm, Feng Tien <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> So I do not need to manually create the db? It will autogen for > me when I set it in my yaml? > -- > 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Exactly. Nicolai --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Nicolai Reuschling wrote:> Exactly. > > Nicolaiwhere exactly are the databases saved at when you migrate? -- 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 -~----------~----~----~----~------~----~------~--~---
in /db, I believe. On Jan 16, 9:11 pm, Feng Tien <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Nicolai Reuschling wrote: > > Exactly. > > > Nicolai > > where exactly are the databases saved at when you migrate? > -- > 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 -~----------~----~----~----~------~----~------~--~---
You are correct. It takes a second to wrap your mind around exactly what SQLite is doing, but I''ve been happy to use it for all of my development stuff so far. On Jan 16, 8:37 pm, DVG <devry...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> in /db, I believe. > > On Jan 16, 9:11 pm, Feng Tien <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> > wrote: > > > Nicolai Reuschling wrote: > > > Exactly. > > > > Nicolai > > > where exactly are the databases saved at when you migrate? > > -- > > 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
did u try creating your app like ruby <name_of_application> --database=sqlite3 also check your database.yml file in the config directory for correct adapters. Cheers On Jan 17, 2008 8:12 AM, Bobnation <boblmartens-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > You are correct. > > It takes a second to wrap your mind around exactly what SQLite is > doing, but I''ve been happy to use it for all of my development stuff > so far. > > On Jan 16, 8:37 pm, DVG <devry...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > in /db, I believe. > > > > On Jan 16, 9:11 pm, Feng Tien <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> > > wrote: > > > > > Nicolai Reuschling wrote: > > > > Exactly. > > > > > > Nicolai > > > > > where exactly are the databases saved at when you migrate? > > > -- > > > Posted viahttp://www.ruby-forum.com/. > > >-- Cheers, Vaibhav Helping Laymen become Technology Enthusiasts at http://technofriends.wordpress.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 Thu, 17 Jan 2008 09:17:24 +0530, Vaibhav Pandey wrote:> did u try creating your app like ruby <name_of_application> > --database=sqlite3 > also check your database.yml file in the config directory for correct > adapters.Ditto. rails foo --database=sqlite3 the above command will create a rails project *and* db in one go. If it doesn''t, then there''s something wrong with the setup. (The db file is, IIRC, named foo_development.db or similar.) -Thufir --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---