A modern Ruby gem that provides PostgreSQL schema-based multitenancy with automatic tenant resolution and schema switching. Compatible with Rails 7+ and Ruby 3.0+, focusing on security, performance, and developer experience. Perfect for modern SaaS applications requiring secure tenant isolation.

Simple manager for PostgreSQL objects like triggers and functions

ActiveRecord::Migration utility for creating partitions in PostgreSQL.

Disable load balancing by Pgpool-II for Rails apps.

Easily use randomized keys instead of sequential values for your record surrogate ids.

ActiveRecord PostgreSQL auto-reconnection, works with 2.3 and 3.2 rails.

Console utility for gracefully rebuild indexes/pkeys for PostgreSQL, with minimal locking in semi-auto mode.

Simple ActiveRecord PostgreSQL full text backed by Arel

serializes rails models from postgres (9.5+)

pg_space_cadet is a simple hack for postgreSQL and ActiveRecord which provides a uuids table of distributable identities of space cadets -- ActiveRecord::Base instances which use the SpaceCadetWrapper. Each space cadet has a default ActiveRecord id unique in the set of all local space cadets; a space cadet's id is derived from its uuid - UUID's are by design universally distributable.

Postgresql Sql Caller for ActiveRecord.

A gem that makes working with tags stored in a Postgresql column easy. Support for array of string, integer and jsonb values.

Retries database transaction on deadlock and transaction serialization errors.

Trigram similarity, guaranteed equivalent to postgres's. Oh yeah.

Manage PostgreSQL custom types (composite types, enums, domains) in your Rails application with versioned migrations and schema handling. This cuts the need for keeping a structure.sql while still maintaining proper type definitions in your Rails application.

PostgreSQL notifications with persistence.

Active Record (>=3.0) plugin which allows you to hide and restore records without actually deleting them. Check its GitHub page for more in-depth information.

Read a dynamic database.yml file and allow you to drop/create the database on demand.

Phil_columns adapter for activerecord. See README for more details.

Gem for easy log rotation and S3 upload