ActiveRecordPostgisArrays

Adds support for missing PostgreSQL data types to ActiveRecord.

Looking for help?

If it is a bug please open an issue on Github. If you need help using the gem please ask the question on Stack Overflow. Be sure to tag the question with DockYard so we can find it.

Installation

Add this line to your application's Gemfile:

gem 'activerecord-postgis-array'

And then execute:

$ bundle

Or install it yourself as:

$ gem install activerecord-postgis-array

Usage

Just require 'activerecord-postgis-array' and use ActiveRecord as you normally would! postgres_ext extends ActiveRecord's data type handling.

• Migration/Schema.rb support
• Type Casting support
• Querying PostgreSQL datatypes
• Indexes

Usage Notes

Avoid the use of in place operators (ie Array#<<). These changes are not tracked by Rails (this issue) explains why). In place modifications also modify the default object.

Assuming we have the following model:

create_table :items do |t|
  t.string :names, :array => true, :default => []
end

class Item < ActiveRecord::Base
end

The following will modify the default value of the names attribute.

a = Item.new
a.names << 'foo'

b = Item.new
puts b.names
# => ['foo']

The supported way of modifying a.names:

a = Item.new
a.names += ['foo']

b = Item.new
puts b.names
# => []

As a result, in place operators are discouraged and will not be supported in postgres_ext at this time.

Authors

Dan McClain twitter github