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.

Automatic documentation for your PostgreSQL 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

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

Simple usage of postgreSQL for Rails

Provides ephemeral PostgreSQL instances for testing, wrapping the pg-ephemeral project binary

EventStore implementation using PostgreSQL

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

The Rails gem shows the output, in your application logs, of applying "Explain" or "Explain Analyze" to the select queries of your rails application.

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

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.

Makes even easier to use postgresql without activerecord

Creates a Histogram fron an ActiveRecord query

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