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.

Gem for forcing cycling disconnections for Rails connections to PGBouncer

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

Add tsquery to activerecord column

Stream data from one postgres database to another

Gem pg_conn

A wrapper for PostgreSQL's COPY command

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

Provides abstraction layer between pg_dump utility and ruby. Also adds rake task to easily dump database with or without data.

Simple usage of postgreSQL for Rails

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

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.

Allows simple searching with a variety of options

Utility class for calling functions defined in a PostgreSQL database.

dwpg_graph gem