# GeorgeKaraszi/ActiveRecordExtended

Adds additional postgres functionality to an ActiveRecord / Rails application

Repository: https://github.com/GeorgeKaraszi/ActiveRecordExtended
Canonical: https://ross.abutalabs.com/products/activerecordextended
Language: Ruby
License: MIT
License Family: permissive
Topics: postgres, activerecord, rails
Last push: 2026-06-23T20:50:52+00:00

## Health v2 (maintenance only)
Score: 80/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 89, release rhythm 56, longevity 100
- inputs: {"age_days": 3048, "days_push": 71, "days_rel": 83, "gap_med": 246, "n_releases_24m": 2}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1466, forks 51 (observed 2026-08-28T04:04:48.656034+00:00)

## What it is
A Ruby gem that extends ActiveRecord with additional PostgreSQL-specific query capabilities such as array predicates, inet/IP matching, CTEs, JSON/JSONB builders, unions, and window functions. It is the maintained successor to the postgres_ext gem, targeting modern Rails/ActiveRecord versions.

## Use cases
- query postgres b columns from rails activerecord
- write common table expressions in activerecord
- use postgres array any/all/contains operators in rails queries
- perform union and intersect queries with activerecord
- use postgres window functions in rails
- match ip addresses against inet columns in activerecord
- combine scopes with any_of/none_of conditions

## When to choose
- you use Rails with PostgreSQL and need advanced SQL features ActiveRecord lacks
- you want CTEs, unions, or window functions without writing raw SQL strings
- you need b query helpers in your ORM layer

## When to avoid
- your application does not use PostgreSQL
- you are on an old Rails version unsupported by the gem
- you prefer writing raw SQL or use a non-ActiveRecord ORM

## Facets
- artifact type: library
- maturity: active
- function: database, orm, database-driver
- domain: databases, web-development, backend, developer-tools
- platform: ruby, jvm
- tags: postgres, activerecord, rails, gem, sql, cte, b, window-functions, union-queries

## Member repositories
- GeorgeKaraszi/ActiveRecordExtended (main) score 80

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:48.656034+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:35:02.289364+00:00, confidence not recorded.
  - readme: https://github.com/GeorgeKaraszi/ActiveRecordExtended (fetched 2026-08-28T04:04:48.656034+00:00, sha 77cf0a5a4f00)
- Data as of 2026-08-30T08:39:29.467469+00:00.