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. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/instantrails-users/attachments/20080407/57149302/attachment.html
-----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-----
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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/instantrails-users/attachments/20080407/e10cb4b4/attachment-0001.html
I take it back, it looks like aptiva has a sqite in its directory, So it does exist somewhere. I never configured any tables in it though. 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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/instantrails-users/attachments/20080407/432e1c38/attachment.html
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 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/instantrails-users/attachments/20080407/01ad068f/attachment.html
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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/instantrails-users/attachments/20080407/34b15625/attachment.html
Well, there isn''t much in the way of SQLite management tools, none are included. I have used SQLite and not needed them but have heard SQLiteMan was a good one. If you search around the web you will find one for sure. -Rob 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 >-- Rob Bazinet InfoQ Ruby and .NET Editor http://www.accidentaltechnologist.com -------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/instantrails-users/attachments/20080407/abb0bd3f/attachment-0001.html
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