Utility class for calling functions defined in a PostgreSQL database.

Makes even easier to use postgresql without activerecord

Creates a Histogram fron an ActiveRecord query

pg_index_where will provide unique index with WHERE statement on PostgreSQL with migrate the database on Rails.

pg_jbuilder is a tool to dump database queries directly to a JSON object or array. It uses PostgreSQL's JSON functions ([array_to_json and row_to_json](http://www.postgresql.org/docs/9.3/static/functions-json.html)) to serialize the JSON completely bypassing ActiveRecord/Arel. This gives a large speed boost compared to serializing the JSON inside of Ruby/Rails. It is perfect for creating JSON APIs with very low response times.

PgJob

Simple ActiveJob queue for PostgreSQL using LISTEN/NOTIFY

A set of classes and micro-DSLs to generate SQL queries special for PostgreSQL backends.

A gem to facilitate the use of LIKE ANY and LIKE ALL PostgreSQL operators with Rails ActiveRecord

A tool to set up and manage logical replication for PostgreSQL databases

Use LDAP permissions in PostgreSQL

pg_meta gem

PostgreSQL Metrics

Simple migration tool focused on Postgresql

This tool provides a set of Rake tasks to apply changes on different Postgres environments.

Rake migration tasks which utilities pure SQL files

Connects to PostgreSQL and retrieves few statistics such as index stats and table bloats.

A tool to move postgres databases b/w clusters using bucardo

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.

Process notifies about postgresql notifications.