redshift-on-postgres-adapter
In Rails 5 the PostgreSQL database adapter is built in. This gem tries to use that as a base and modify just enough things to talk to Amazon Redshift.
Examples
class AddNewColumn < ActiveRecord::Migration[5.0]
def change
add_column :my_table, :new_col, :int, null: false, default: 0, encode: :runlength
end
end
Tested
- Table loading
- Adding, removing records
- Drop tables
- Migrations
- Column encoding support.
- DISTKEY and SORTKEY
TODO
- Schema dumping with .rb with correct encoding and key signature.
Changes
0.2.0:
- Support column options of :distkey, :sortkey, and :encode
0.1.1:
- Support auto incrementing primary keys in DB creation
0.1.0:
- Original Version