based on pg_dump and pg_restore

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

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

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

Handle Postgres failover events gracefully using your favourite ORM.

Normalize SQL query module for QueryTrack and PostgreSQL

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.

dwpg_graph gem

A data fetching library build on top of PostgreSQL inspired by Facebook's GraphQL

Makes even easier to use postgresql without activerecord

Creates a Histogram fron an ActiveRecord query

This gem automatically assigns and request review members when your pull request open.

This gem posts issue title when you comment including "ref issue's URL" to your github

This gem posts random lgtm image when you comment some text including "LGTM" to your github

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

Gem implements multitable iheritance.

Optimize your Pivotal Tracker and Github workflow

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.