When you are tired of coding the same kinds of things for your User model (or any other person-like model) with all its typical `first_name`, `full_name`, and other brouhaha, use the Personhood gem to clean up your code by getting rid of those pesky lines and instead focusing on t...

PetriDish - Under the microscope

Say 'ptree'

Import pfrpg modules suitable for herosheets

This gem provides a module that, when included in your ActiveRecord model, provides methods to acquire and release advisory locks for PostgreSQL connections.

Anonymize postgres to use development data

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.

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