Using InterBase

Use InterBase to benefit from its multi-generational architecture, log-based journaling and disaster recovery features. A small footprint, automatic crash recovery, self-tuning, Unicode, SMP support, SQL 92 compliance, and near zero maintenance makes InterBase 2007 the ideal database for embedded and business-critical small-to-medium enterprise server applications.

Connect to and use InterBase to serve a project using the ibrails_plugin gem.

1. Navigate to the CodeGear Trial and Free Versions website. Select the InterBase Developer version for the desired operating system.
   
2. Provide the required information to activate the software and an email with the license and activation key will be sent to the provided address.
   
3. Install InterBase from the 3rdRail product master installer.
   

   Note:

   At the Select Components prompt remove the default Register option by clicking to remove the check mark from the checkbox. This disables the registration screen that will prompt for a license and activation. The file provided via email nulls this requirement when properly added the License directory as described below.

4. Save the license file to the following path (path may vary depending on OS and install preferences):
   {install directory} Borland InterBase License
   
5. The Rails runtime packaged with 3rdRail includes the database driver for InterBase. Use the runtime provided with 3rdRail or add the driver manually by installing the following gem from the Workspace Commander or OS command line:
   

   gem install ibruby

Create a Rails Project using InterBase:

1. Create a rails project using the Rails Project Wizard, select InterBase as the database type:
   New Rails Project Wizard
   From the workbench select:
   New Rails Project
   
2. Name the project and select Rails Options Database Type InterBase The project in now configured to use InterBase as the database client.
   

Configuration Details

1. From the Rails Explorer navigate to the project configuration file:
   {projectfile} Configuration
   
2. Double-click the database.yml file to open it in the YML Editor.
   Provide the user name and password and the correct database path.
   If the path exists the empty database will be created automatically.
   
3. To create the empty database manually:
   

                           C:\Users\{username}>isql -u sysdba -p masterkey
                           
                           Use CONNECT or CREATE DATABASE to specify a database
                           
                           SQL> create database "c:\home\foo.ib";
                       

Using InterBase on an Existing Project:

1. If the ibruby gem (the InterBase database driver) is not installed use the Workspace Commander or OS command line to install:
   

   gem install ibruby

   Note:

   Use “gem list” to view a list of installed gems.

2. Open the project in the Rails Explorer and install the plug-in From the project's Project Commander enter:
   

            
                           script/plugin install http://ibruby.rubyforge.org/svn/ rails_plugins/trunk/ibrails_plugin
                       

3. Edit the database.yml file to ensure the database name and user name/password are correct.
   

CodeGear brand and product names are service marks, trademarks or registered trademarks of Borland Software Corporation in the United States and other countries.