oracle-enhanced-enhanced

While an outstanding offering that enables us to use Oracle as our database (whether we like it or not), the Oracle Enhanced ActiveRecord Adapter (link) has a few behaviours that I find myself overriding in all my Rails projects. Made sense to throw them all into a gem.

How It Works

Add this gem to your project and it will override the following defaults:

sequences will be created with the start_value options: 1 NOCACHE ORDER
cache_columns is set to true, saving loads in terms of data dictionary lookups (but requiring a restart if you change a table)
primary/foreign key columns will be created as NUMBER(12) instead of NUMBER(38)
integer columns will default to NUMBER(12) instead of NUMBER(38)
TEXT fields are stored as VARCHAR2(4000) instead of CLOB

Converting CLOB Columns to VARCHAR2

You can convert existing CLOB columns to VARCHAR2(4000) in a migration using:

class ConvertTextColumns < ActiveRecord::Migration
  def self.up
    convert_clob_to_varchar2 :table_name, :column_name
  end

  def self.down
    convert_varchar2_to_clob :table_name, :column_name
  end
end

You can optionally specify the VARCHAR2 size as a third parameter to convert_clob_to_varchar2.

Other Methods

You can at any time change the text representation by calling set_text_storage_representation. See the rdoc for more details.

There are also helper methods text_is_clob? and text_is_varchar2?, and a new constant VARCHAR2_MAX_LENGTH. Note that these are added to ActiveRecord::ConnectionAdapters::OracleEnhancedAdapter.

Known Issues

None

Contributing