Automatic documentation for your PostgreSQL database

Add routing hints to the application to enable direct-to-shard transaction routing in ambiguous contexts.

This gem backs up postgres and stores the backup in google drive

Adds support for Postgres (enum)erated types to Active Record

Simple usage of postgreSQL for Rails

EventStore implementation using PostgreSQL

Examine and compare the tables, columns, constraints and other information that makes up the schema of a PG database

Escape each array element inside PG::Connection#exec_params properly

The Rails gem shows the output, in your application logs, of applying "Explain" or "Explain Analyze" to the select queries of your rails application.

CLI for exporting/importing PostgreSQL dumps via FTP/SSH. Can be used for backups or synchronizing databases between production and development environments.

This gem allows you to rapidly generate large amount of json in an activerecord application. By relying on postgres' native functionality, we can skip object instantiation and turn active record queries directly into json.

Relation-aware synchronous full text search index for PostgreSQL using PL/pgSQL triggers described in and generated via ORM-agnostic Ruby.

Utility class for calling functions defined in a PostgreSQL database.

Makes even easier to use postgresql without activerecord

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