# What is your suggestion? **URL:** \ **Category:** Rails\ **Created:** [December 29, 2007, 4:48am UTC](https://www.ruby-forum.com/t/what-is-your-suggestion/124493 "2007-12-29T04:48:34Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [December 29, 2007, 4:48am UTC](https://www.ruby-forum.com/t/what-is-your-suggestion/124493/1 "2007-12-29T04:48:34Z")
what is the best database adapter for rails frame work ? what is the advancestage and disadvanstage of that ? ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [December 29, 2007, 9:39pm UTC](https://www.ruby-forum.com/t/what-is-your-suggestion/124493/2 "2007-12-29T21:39:18Z")
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 D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [December 31, 2007, 6:06pm UTC](https://www.ruby-forum.com/t/what-is-your-suggestion/124493/3 "2007-12-31T18:06:38Z")
On 12/28/07, Pokkai D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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 D. [http://destiney.com/](http://destiney.com/) ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [January 2, 2008, 7:38am UTC](https://www.ruby-forum.com/t/what-is-your-suggestion/124493/4 "2008-01-02T07:38:12Z")
Greg D. wrote: > On 12/28/07, Pokkai D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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 D. > [http://destiney.com/](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 … ---
**Author:** ![mokkai](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c2a13f/32.png) [@mokkai](https://www.ruby-forum.com/u/mokkai)\ **Post date:** [January 2, 2008, 6:35pm UTC](https://www.ruby-forum.com/t/what-is-your-suggestion/124493/5 "2008-01-02T18:35:10Z")
On 1/2/08, Pokkai D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > postgresql app) in IDE > Did 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 error What error? Do you have the postgresql driver installed? – Greg D. [http://destiney.com/](http://destiney.com/)