[Locomotive-users] general frustration

[Ryan Raaum]

On 1/25/07, ray palermo <signorray at sbcglobal.net> wrote:
> I have that book and it was frustrating because of the errata and that I was
> confused by what Locomotive was supposed to be doing as opposed to the
> instructions in the book which caused other errors (like something about
> updating the DB schema). Additionally, I tried using the tutuorial on the
> Apple site and that was a whole different failure.I really appreciate the
> help I am getting and apologize for asking such basic questions.
>
> I am trying to use MySQL for the database (if I ever get to that point). I
> have it set up through Locomotive so that I can call it from the command
> line.

Or just use sqlite.  Really.  It's much, much easier.  You don't have
to create the database files or anything if you use sqlite and
migrations.

If you're starting from scratch, there's no difference between
learning rails with a sqlite db or learning rails with a mysql db.  In
fact, the entire design philosophy of rails makes the backend db
largely irrelevant.

There are many mysql feature that may make it a more desirable db than
sqlite down the road for you, but you will have a much better
understanding of rails and databases by the time you actually need to
make that decision.

Change the database.yml file to:

development:
  adaptor: sqlite3
  database: db/dev.db

run your migration (i.e. "rake db:migrate") and you're off!

Best,

-r

(If the tutorial or book you are following uses migrations (and it
really should!), everything will work exactly the same in sqlite as in
mysql as in postgresql as in ...)


>
>
>
>
> On Jan 25, 2007, at 4:54 PM, Lori M Olson wrote:
>
> On 25-Jan-07, at 3:29 PM, ray palermo wrote:
>
>
> Hello,
>
> How do I set that database up? I thought that was the purpose of the migrate
> step? I revised line 29. That seemed to help. Is it necessary to restart the
> application (using Mongrel) every time you revise something? I made a whole
> new application and I am still having the same problems (except for "line
> 29" - I also changed "line 39" to be consistent or it that the wrong thing
> to do?).
>
> Ray
>
>
>
>
> Migrate will "populate" your database with tables.  It will not create the
> database in which the tables are to be stored.  As for how you set it up...
> what database were you planning on using?
>
> I really have to recommend that you look into buying a book, like "Agile Web
> Development with Rails" or something like it.  All this kind of stuff is
> detailed for you, step by step, in books.
>
> http://pragprog.com
>
> Regards, Lori
> _______________________________________________
> Locomotive-users mailing list
> Locomotive-users at lists.raaum.org
> http://lists.raaum.org/mailman/listinfo/locomotive-users
>
> Ray Palermo
> 812.423.5680
> signorray at sbcglobal.net
>
>
>
>
> _______________________________________________
> Locomotive-users mailing list
> Locomotive-users at lists.raaum.org
> http://lists.raaum.org/mailman/listinfo/locomotive-users
>
>
>


-- 
Ryan Raaum
http://raaum.org
http://rails.raaum.org -- Rails docs
http://locomotive.raaum.org -- Self contained Rails for Mac OS X