On Tue, Mar 24, 2009 at 7:48 PM, Robert Walker <[email protected]> wrote:
> I take it you're not developing on a Mac. :-) Yes. He is not alone..... > I don't entirely disagree with you on this point, but the fact remains > that a huge percentage of Rails developers are on the Mac. On the Mac > SQLite is installed and ready to use, along with Rails, and ruby-sqlite. > SQLite is used in several other areas on the Mac; 1: Persistent store > for Core Data, 2: HTML 5 local storage used by WebKit, etc. Actually, it isn't hard to setup on Linux either. I have installed without any problems. > What I'm saying is that from this perspective, on this platform, it does > actually make sense to use SQLite as the default. It's the easy choice > to make it the default, because there's no bickering between whether the > default should be MySQL or PostreSQL for instance. > The other advantage of having SQLite as the default is that there is > zero configuration necessary when creating a new Rails app. This is > great for quick prototypes. > > rails my_proj > cd my_proj > ./script/generate model MyModel name:string > rake db:migrate > ./script/server > > Zero database configuration. No username/password setup, no rake > db:create. It just works. That is one great thing that I like about rails and sqlite. you don't have to mess with the database.yml file. > I don't believe anyone expects SQLite to be use as the production > database, including the Rails core team who chose to use SQLite as the > default. > > It's dead simple to skip the whole SQLite thing: > > rails my_proj --database=mysql > > It makes sense to specify what "other" database server you want when > creating a new project. If you specify it, chances are that you've done > the work to install and configure it for use. I was just going to say that. SQLite is a good choice if you want a quick prototype. It is pretty straight forward. Once you have the test db working, then you can switch to a production RDBMS (be it MySQL, Oracle, Postgresql, etc..) Fidel. --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
