GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — GitHub - acquaintable/activerecord-postgres-array: Postgres array support for Active Record

BranchesTags
Open more actions menu
 
 

Latest commit

 

History

32 Commits
32 Commits

Folders and files

NameName
Last commit message
Last commit date
lib
lib
 
 
spec
spec
 
 
.gitignore
.gitignore
 
 
.rspec
.rspec
 
 
Gemfile
Gemfile
 
 
LICENSE
LICENSE
 
 
README.textile
README.textile
 
 
Rakefile
Rakefile
 
 
activerecord-postgres-array.gemspec
activerecord-postgres-array.gemspec
 
 

Repository files navigation

Postgres array support for activerecord

Add basic support for postgres arrays to activerecord, with special attention to getting rails migrations / schema dumps working nicely.

Installation

gem install activerecord-postgres-array

or if you use bundler

gem 'activerecord-postgres-array'

Usage

  • In your migrations you can define postgres array fields such as:
    create_table :people do |t|
      ...
      t.string_array :real_energy
      t.decimal_array :real_energy, :precision => 18, :scale => 6
      ...
    end
    
  • When queried, the postgres arrays will be returned as ruby arrays, and vice versa.

Compatibility with activerecord-postgres-hstore

activerecord-postgres-hstore and activerecord-postgres-array both monkeypatch ActiveRecord::Base#arel_attributes_values, which leads to problems if these gems are used together. This gem is aware of activerecord-postgres-hstore and incorporates it in the monkeypatch. However, it is important that activerecord-postgres-array is loaded after activerecord-postgres-hstore for this to work.

Current limitations

  • Parsing of multi-dimensional postgres array strings is currently not implemented.
  • String, Decimal and Integer arrays have been tested, but other array types have not been. Type casting will need to be implemented for booleans, dates, etc

Future enhancements

  • Arel like querying of values within arrays
  • Arel like aggregate functions

About

Postgres array support for Active Record

Resources

Readme
ISC license
Activity
Custom properties

Stars

0 stars

Watchers

5 watching

Forks

0 forks
Report repository

Releases

Packages

Contributors

Languages

You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.