Hello, I have to code a small application for a car repair shop running under Windows (98 SE but may be my client could upgrade to 2000) and using RoR is my definite choise ! The app will be powered by WebRick (which is enough powerfull for a small app used by only ONE user at a time) My questions are targeted to the best database to use... I had a look to SQLite and Firebird but support for both of them is not yet complete under RoR Which of these one is the best choice under RoR ? Is there another choice for an embeddable database ? I would prefer to avoid MySQL in that case... Thanks -- Posted via http://www.ruby-forum.com/.
I use sqlite3 in a small production site and I''ve not had any problems. I haven''t run into any areas where Rails support of sqlite was "incomplete." My deployment environment is FreeBSD. YMMV on Windows. -TJ On 7/6/06, nuno <nomail@novalidatall991.com> wrote:> Hello, > > I have to code a small application for a car repair shop running under > Windows (98 SE but may be my client could upgrade to 2000) and using RoR > is my definite choise ! > > The app will be powered by WebRick (which is enough powerfull for a > small app used by only ONE user at a time) > > > My questions are targeted to the best database to use... I had a look to > SQLite and Firebird but support for both of them is not yet complete > under RoR > > Which of these one is the best choice under RoR ? Is there another > choice for an embeddable database ? I would prefer to avoid MySQL in > that case... > > > Thanks > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
It seems (http://www.sqlite.org/omitted.html) that sqlite doesn''t support the DROP COLUMN statement... Was it a problem for you (in migration file or even in development process if not using Rails migrations) ? -- Posted via http://www.ruby-forum.com/.
I didn''t hit that in the particular application I was referencing. I only recently updated it to 1.0 from 0.12. Since the schema was already defined, my only migration file is 001_. But thanks for the heads up; I will look into that. On 7/6/06, nuno <nomail@novalidatall991.com> wrote:> > It seems (http://www.sqlite.org/omitted.html) that sqlite doesn''t > support the DROP COLUMN statement... Was it a problem for you (in > migration file or even in development process if not using Rails > migrations) ? > > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >
BTW have you tried a remove_column migration with sqlite3? If so, what were your results? This ticket from long ago indicates remove_column works with sqlite. http://dev.rubyonrails.org/ticket/1771 I will try it later. -TJ On 7/6/06, TJ Stankus <tj@stank.us> wrote:> I didn''t hit that in the particular application I was referencing. I > only recently updated it to 1.0 from 0.12. Since the schema was > already defined, my only migration file is 001_. But thanks for the > heads up; I will look into that. > > On 7/6/06, nuno <nomail@novalidatall991.com> wrote: > > > > It seems (http://www.sqlite.org/omitted.html) that sqlite doesn''t > > support the DROP COLUMN statement... Was it a problem for you (in > > migration file or even in development process if not using Rails > > migrations) ? > > > > > > -- > > Posted via http://www.ruby-forum.com/. > > _______________________________________________ > > Rails mailing list > > Rails@lists.rubyonrails.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > >
SQLite3 works fine for my project. Use RubyScript2Exe and Tar2Ruby and you can build a nice installable, self-contained application for your users. On 7/6/06, TJ Stankus <tj@stank.us> wrote:> > BTW have you tried a remove_column migration with sqlite3? If so, what > were your results? This ticket from long ago indicates remove_column > works with sqlite. > > http://dev.rubyonrails.org/ticket/1771 > > I will try it later. > > -TJ > > On 7/6/06, TJ Stankus <tj@stank.us> wrote: > > I didn''t hit that in the particular application I was referencing. I > > only recently updated it to 1.0 from 0.12. Since the schema was > > already defined, my only migration file is 001_. But thanks for the > > heads up; I will look into that. > > > > On 7/6/06, nuno <nomail@novalidatall991.com> wrote: > > > > > > It seems (http://www.sqlite.org/omitted.html) that sqlite doesn''t > > > support the DROP COLUMN statement... Was it a problem for you (in > > > migration file or even in development process if not using Rails > > > migrations) ? > > > > > > > > > -- > > > Posted via http://www.ruby-forum.com/. > > > _______________________________________________ > > > Rails mailing list > > > Rails@lists.rubyonrails.org > > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > > > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060706/47e73ddc/attachment.html