Mostly seamless management of functions, triggers, views, and materialized views, similar to schema.rb/structure.sql

A completely transparent audit logging component for your application using a stored procedure and triggers. Comes with specs for your project and a rake task to generate the reverse SQL to undo changes logged.

Create, restore, download and upload postgres dumps locally and on remote servers using capistrano. Really!

Extends Rails migrations to support setting column and table comments. Pulls out comments into schema.rb

Displays number of connections opened in the 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

Simple usage of postgreSQL for Rails

Rails plugin for postgres

This gem offers base function for all gems like pghub-xxx

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

PgInsights provides a plug-and-play insights dashboard for analyzing PostgreSQL performance and query data inside any Rails application.

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 ...

Simple ActiveJob queue for PostgreSQL using LISTEN/NOTIFY

ActiveRecord extensions for PostgreSQL. Provides useful tools for schema, foreign_key, index, comment and extensios manipulations in migrations.

pg_query_optimizer is a gem that improving the performance of complex queries specifically desingned for postgress database. This query significantly improves query execution times for large datasets.

Web interface for pgq gem. Inspect pgq and londiste queues

Rails goodies.

REST API for remote PostgreSQL database migrations.

Scaffolding for rails.