It is a good replacement for data that may have been stored in flat files, as
it supports most of the SQL-92 standard and would be easy to migrate to a more traditional
DBMS as needs grow.
Microsoft SQL Server
Though Rails grew up in the Linux/Unix world, it has developed great community
support for the Windows platform as well. Not only are Microsoft SQL Server database
connections supported in Rails, there are also provisions for connecting to SQL
Server from a Linux-based systems as well, using the FreeTDS library.??
From a Windows client, the standard approach is to use Ruby-DBI (a Ruby databaseindependent
adapter) with ADO. The configuration looks like this:
development:
adapter: sqlserver
host: server_name
database: my_db
username: user
password: pass
Your configuration may vary, depending on the version of SQL Server and the ADO
libraries you have installed. Once the database configuration is in place, the standard
ActiveRecord API methods can be used to manipulate data.
Oracle
Rails supports Oracle versions 8i, 9i, and 10g through the ruby-oci8 library,??? which
supports the OCI8 API. Windows, Linux, and OS X are supported as clients. The
connection configuration is fairly standard, using oci as the connection adapter name.
* ACID stands for Atomic, Consistent, Isolated, and Durable, which are necessary properties for transactional
integrity within a database.
Pages:
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158