what is the best database adapter for rails frame work ? what is the advancestage and disadvanstage of that ? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
These are impossible questions to answer. The only viable answer is "it depends." The types of questions you should be asking yourself are: What are my storage requirements? - How many tables will there be? - How many records in each table? - Do I need to be fully ACID compliant? - Do I need full transaction support? - Do I care about foreign key constraint support? What are the requirements of my business? - Am I willing to pay for a commercial database? - Are there any constrains on using open source software in my business? - What is my budgetary requirements in choosing a database? What options are available from my hosting service? If you have already chosen a hosting service for your application, and that hosting service offers MySQL only, for example, then the answer to your original question has already been chosen for you. The best database adaptor in that scenario would obviously be the MySQL adaptor. I think you get my point. It matters very little about the adaptor, unless it''s completely broken. What matters is choosing the database that fit your particular needs. In most cases I choose to use SQLite for my development and test databases. This reduces the time spend setting up and configuring my database during the development stage to zero. I then normally choose MySQL for my production database. At the place I work they use Oracle for nearly everything so there is no choice to be made in that situation. The production database must be Oracle due to purely business constraints. Now it''s pretty obvious that I wouldn''t choose Oracle for my own personal projects due to the cost of Oracle and it would be overkill in most situations anyway. What I think is really important is to make every effort to design your Rails application to be database agnostic. That way you are completely free to choose whatever database makes the most sense for your deployment needs. On Dec 28, 10:48 pm, Pokkai Dokkai <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> what is the best database adapter for rails frame work ? > what is the advancestage and disadvanstage of that ? > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 12/28/07, Pokkai Dokkai <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > what is the best database adapter for rails frame work ?It seems to me that MySQL is the most popular choice. And the postgres driver works really well for me too. I have some issues when using others such as ruby-oci8. -- Greg Donald http://destiney.com/ --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Greg Donald wrote:> On 12/28/07, Pokkai Dokkai <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote: >> >> what is the best database adapter for rails frame work ? > > It seems to me that MySQL is the most popular choice. And the > postgres driver works really well for me too. I have some issues when > using others such as ruby-oci8. > > > -- > Greg Donald > http://destiney.com/actually i don''t have much knowledge about Databases why i am asking , rails 2.0.1 default support is mysql. and rails 2.0.2 default support is sqlite3. when i was working with rails 2.0.2 in IDE (RadRails i am using) the default database is sqlite .so whatever i create new project it default setting with sqlite.... and i don''t know how to specify database adapter name ( rails -d postgresql app) in IDE if i directly change to postgresql(by opening database.yml) ,then it show error after that i opened rails gem file and change the default database to postgresql then i am working now.... so i asked this ..... -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 1/2/08, Pokkai Dokkai <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> actually i don''t have much knowledge about Databases > > why i am asking , > rails 2.0.1 default support is mysql. and rails 2.0.2 default support is > sqlite3. > > when i was working with rails 2.0.2 in IDE (RadRails i am using) the > default database is sqlite .so whatever i create new project it default > setting with sqlite.... > and i don''t know how to specify database adapter name ( rails -d > postgresql app) in IDEDid you contact the authors of your ide? Perhaps there is an undocumented way. There''s always the command line.> if i directly change to postgresql(by opening database.yml) ,then it > show errorWhat error? Do you have the postgresql driver installed? -- Greg Donald http://destiney.com/ --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---