Seamless PostgreSQL date partitioning for your Rails models.

A gem providing support for table partitioning in ActiveRecord. Support is available for postgres and AWS RedShift databases. Other features include child table management (creation and deletion) and bulk data creating and updating.

Runtime maintenance for PostgreSQL declarative partitions — archive / current / future zones, heat-driven splits, mandatory default drain, hot-switch migrations, and strategy templates.

core gem of partybook.

pcrd migrates PostgreSQL tables to a new cluster using logical replication, with support for column type changes, renames, additions, drops, and column reordering with padding optimization. Designed for large tables where ALTER TABLE would cause unacceptable downtime.

Introduces ActiveRecord to PostgreSQL, adding support for PostgreSQL specific features.

PeekDB is a command line utility that builds a simple force-directed ER diagram for a database. The output can be .png or .dot formats.

The peoplefinder provides searchable staff profiles for your organisation. Since it's a rails engine, you can re-skin it for your organisation.

Process multiple enqueued Sidekiq jobs in a single bulk job execution. Useful for migrating jobs with high write load to utilize bulk inserts.

Runs jobs at specified intervals.

Perilune is a Rails Engine that allows you to define Task classes for procesing files and handles their processing on the background for you.

Provide a database-backed enumeration between indices and symbolic values. This allows us to have a valid foreign key which behaves like a enumeration. Values are cached at startup, and cannot be changed.

Handy place to stick small bits of persistent data. Like redis if you don't want to install redis.

Gem that integrates PostgreSQL native enums with ActiveRecord enums.

A simple pg handler. Translates Structs into PG and back.

This gem provides a module that, when included in your ActiveRecord model, provides methods to acquire and release advisory locks for PostgreSQL connections.

Manage PostgreSQL aggregate functions in your Rails application with versioned migrations and schema handling. This cuts the need for keeping a structure.sql

Provides Rails-native integration with TimescaleDB's pgai extension, making AI-powered vectorization and semantic search simple and intuitive in Rails applications.

pg_any_where patches Arel so that `where(column: array)` emits `column = ANY($1::type[])` instead of `column IN ($1, $2, …)`. This yields a stable prepared-statement shape (one bind parameter regardless of array size), better PostgreSQL plan cache utilisation, and cleaner pg_stat_statements outp...

This gem stamps an identification mark on the postgres database connection using the postgres connection variable 'application_name'. Such a stamp can be viewed in pg_stat_activity.