[Instantrails-users] Confused Newbie question

Mike mikeickes at gmail.com
Tue Apr 8 11:22:31 EDT 2008


Give this a shot for managing sqlite.

https://addons.mozilla.org/en-US/firefox/search?q=sqlite&cat=all

HTH!
Mike

On Mon, Apr 7, 2008 at 5:19 PM, David Williams <mrdave215 at gmail.com> wrote:
> Thanks alot, this is making some sense. But of course it raises more
> questions.
>
> The database.yml file contains:
>
> # SQLite version 3.x
> #   gem install sqlite3-ruby (not necessary on OS X Leopard)
> development:
>   adapter: sqlite3
>   database: db/development.sqlite3
>   timeout: 5000
>
> So, where are the admin tools for sqlite? Do i have to download them? Can
> someone recommend a good management tool if one isnt included.
>
>
>
>
>
> On Mon, Apr 7, 2008 at 4:34 PM, Robert Bazinet <rbazinet at gmail.com> wrote:
>
> > Rails 2.0, which is what Instant Rails 2.0 uses, uses SQLite by default.
> Instant Rails has always been configured with MySQL and IR 2.0 still has it
> built in for now.  A lighter version is coming without it but for now, both
> MySQL and SQLite are in there.
> >
> > Instant Rails will use the version of MySQL which came with it but by
> default Rails will use SQLite unless specifically told not to.  The
> database.yml file in each of your projects will tell you which DB provider
> you are using.
> >
> > Hope this helps.
> >
> > -Rob Bazinet
> >
> >
> >
> >
> >
> >
> > On Mon, Apr 7, 2008 at 4:21 PM, David Williams <mrdave215 at gmail.com>
> wrote:
> >
> > >
> > > I guess that is possible, there is nother database somewhere. I do not
> have any other database running on my computer or on the network right now.
> Just what came with R -on- R.
> > > The task manager shows mysqld.exe and nothing else with "sql".  Where do
> I find the database/port config?
> > >
> > >
> > >
> > >
> > >
> > > On Mon, Apr 7, 2008 at 2:21 PM, David Morton <mortonda at dgrmm.net> wrote:
> > >
> > > > -----BEGIN PGP SIGNED MESSAGE-----
> > > > Hash: SHA1
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > On Apr 7, 2008, at 8:20 AM, David Williams wrote:
> > > >
> > > > > I have instant rails 2.0 installed and running happily. I unzipped
> > > > > everything into a Ruby folder.
> > > > >
> > > > > I only have one copy of Mysql on my computer. I run the instant
> > > > > rails program then go in and start the mycoookbook application.
> > > > >
> > > > > I got a blank cook book. So i added a couple of catagories and poked
> > > > > around.
> > > > >
> > > > > I then went into mysql admin. This showed the database config, which
> > > > > is fine. When I went into browse the tables, there were recipes in
> > > > > there already. The recipies and catagories I added where not to be
> > > > > found.
> > > > >
> > > > > I looked at my task list and there is only one mysql process.
> > > > >
> > > > > What am I missing here.
> > > >
> > > >
> > > > Rails 2.0 defaults to using sqlite, I think.  Is that packaged with
> > > > Rails now?  It's possible that your changes are in the sqlite
> > > > database, and it's not connecting to mysql.
> > > >
> > > >
> > > > David Morton
> > > > Maia Mailguard http://www.maiamailguard.com
> > > > mortonda at dgrmm.net
> > > >
> > > >
> > > >
> > > > -----BEGIN PGP SIGNATURE-----
> > > > Version: GnuPG v1.4.7 (Darwin)
> > > >
> > > > iD8DBQFH+mY7Uy30ODPkzl0RArZUAKCUubDcrSc39HNZvnEBOu3cgIJXKQCdEMAe
> > > > MrrvpTu7UzyWo4MoWV68Chw=
> > > > =BzDV
> > > > -----END PGP SIGNATURE-----
> > > > _______________________________________________
> > > > Instantrails-users mailing list
> > > > Instantrails-users at rubyforge.org
> > > > http://rubyforge.org/mailman/listinfo/instantrails-users
> > > >
> > >
> > >
> > > _______________________________________________
> > > Instantrails-users mailing list
> > > Instantrails-users at rubyforge.org
> > > http://rubyforge.org/mailman/listinfo/instantrails-users
> > >
> >
> >
> >
> > --
> > Rob Bazinet
> > InfoQ Ruby and .NET Editor
> > http://www.accidentaltechnologist.com
> >
> > _______________________________________________
> > Instantrails-users mailing list
> > Instantrails-users at rubyforge.org
> > http://rubyforge.org/mailman/listinfo/instantrails-users
> >
>
>
> _______________________________________________
>  Instantrails-users mailing list
>  Instantrails-users at rubyforge.org
>  http://rubyforge.org/mailman/listinfo/instantrails-users
>



-- 
Kind Regards,
Mike Ickes


More information about the Instantrails-users mailing list