what is the best database adapter for rails frame work ?
what is the advancestage and disadvanstage of that ?
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. [email protected]
On 12/28/07, Pokkai D. [email protected] 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/
Greg D. wrote:
On 12/28/07, Pokkai D. [email protected] 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/
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 …
On 1/2/08, Pokkai D. [email protected] 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/