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.

PgSqlCaller is a small, focused wrapper for running raw SQL against PostgreSQL through ActiveRecord. It exposes a stable, documented API on an ActiveRecord-backed class you name, covering the queries the query builder makes awkward: single-scalar and single-column SELECTs, raw rows, ActiveRecord::Result reads, and type-cast (serialized) variants that decode PostgreSQL arrays and custom column types into Ruby objects. Every ? placeholder is bound and escaped through the ActiveRecord sanitizer, so statements stay injection-safe with no manual quoting. On top of that it adds PostgreSQL-specific helpers — non-consuming sequence peeking, table and relation sizes, EXPLAIN ANALYZE, NOTICE capture, and quoting/sanitizing utilities — plus a fast, injection-safe bulk update that partially updates many existing rows in a single UPDATE ... FROM unnest(...) statement and round-trip. The reader API is extensible via define_sql_method, and the gem runs on Ruby 3.2+ with Rails 7.1 through 8.1.

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

Phobos DB Checkpoint is a plugin to Phobos and is meant as a drop in replacement to Phobos::Handler

Encapsulates the composed of pattern for phone numbers into any easy to use library.

Phonofy is a Ruby gem that simplifies phone number formatting in Ruby applications using the Phonelib library. It integrates seamlessly with Rails applications but can also be used in non-Rails environments. With Phonofy, you can easily parse and format phone number data according to international standards, ensuring that your phone number data is consistent and valid across your application.

JavaScript gallery