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

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.

Sets the application name for a postgres connection

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

Adds methods to ActiveRecord::Migration to create and manage database functions in Rails

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.

Postgres-specific ORM for Ruby

collection_cache_key replacement for system which uses PG as DB, uses PG aggregation functions

A simple ruby script to manage postgresql databases and users

Add tsquery to activerecord column

Makes a query

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

Stream data from one postgres database to another

Gem pg_conn

Simple stocker general log for pg gem.

A wrapper for PostgreSQL's COPY command

A simple command line tool to copy tables from one Postgres database to another

Postgres table partitioning with a Ruby API built on top of https://github.com/ankane/pgslice

Compares two PostgreSQL databases and generates the SQL statements needed to make their structure the same.