MySql Best Opensource Database for Ruby on Rails

RoR is being highly discussed phrase in the realm of web development. Thinking why is it so? Ruby on Rails can be defined as a full stack framework which means that this framework covers everything which is needed to build a web application. It is an open source web application framework that can help you building web applications with an out of the box architecture. It is written in Ruby which is an object oriented language with clean syntax that can make programming enjoyable. Moreover Rails could help you creating a web application almost ten times faster than you do with regular java framework and that too without compromising with the quality. As it uses the MVC architecture pattern, it organizes the application programming that provides flexibility and simplicity. RoR is a great framework for them who have high timeliness and budget constraint.

While SQLite3 is extremely convenient for development and testing databases, and PostgreSQL has powerful Generalized Search Tree indexes and is very close to being enterprise-ready, MySQL is the choice for many Web sites thanks to its excellent read performance, transparent support for large text and binary objects, and incredibly easy administration. Stored procedures, functions, triggers, and updateable views were added to MySQL in version 5, overcoming the largest technical objections to its deployment at many sites. MySQL also has a large, helpful user base, and some poster-child deployments including eBay, Yahoo, and Craigslist.

You can download MySql module for ruby on rails from link given below.

Download Ruby MySQL modules

There are two modules for connecting to a MySQL database server from Ruby:

• MySQL/Ruby is built on top of the MySQL C API, and provides the same functions for Ruby programs that the MySQL C API provides for C programs.
• Ruby/MySQL is written in pure Ruby, and implements (mostly) the same interface as MySQL/Ruby. (This module is also included in the Ruby on Rails distribution.)

MySQL/Ruby and Ruby/MySQL are both written and maintained by Tomita "tommy" Masahiro.

Ruby DBI is a database-independent API for Ruby that uses the above modules to work with MySQL.

You can install MySQL/Ruby using the Ruby Gems packaging manager:

$ sudo gem install mysql