Olivier Db wrote:
> Hello,
> 
> I am running Mac OS X 10.6.4 and have installed the following:
> 
> ruby-1.9.1-p429 (64 bits, I believe!)
> RubyGems 1.3.7
> Rails 2.3.8
> MySQL 5.1.49 (64 bits)
> 
> I am now getting an error because sqlite3 is not installed

SQLite comes with Mac OS.  The OS uses it internally.  No installation 
should be necessary, though you will probably have to install the 
sqlite3 gem.

> and I've read
> that there are issues installing ruby-sqlite3!

Not to my knowledge.

> SO I'm not sure if I
> should (or how to) install sqlite3.
> 
> A developer suggested I use sqlite3 for testing and mysql for
> production, but wouldn't that mean having to convert my sqlite database
> to mysql for production?

No.  You have separate databases.  You've also got migrations.  No 
conversion is required.

> I might just as well always use mysql, no?

It depends.  On the one hand, it's extremely convenient and fast to use 
SQLite for testing and development.  On the other hand, you may find 
that you would rather have the same DB in development as production. 
I've done it both ways.  Both are fine.

(And I would say you might as well *never* use MySQL.  PostgreSQL is a 
much, much better DB.)

> 
> Which leads me to the following question: how do I configure rails to
> always default to using mysql database instead of sqlite3?

-d mysql

> 
> Thank you for your help.
> 
> Best regards,
> 
> Olivier

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
mar...@marnen.org
-- 
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-t...@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.

Reply via email to