pg_query extension

Easily use randomized keys instead of sequential values for your record surrogate ids.

ActiveRecord PostgreSQL auto-reconnection, works with 2.3 and 3.2 rails.

Console utility for gracefully rebuild indexes/pkeys for PostgreSQL, with minimal locking in semi-auto mode.

Simple tool to dump postgresql database to an S3 bucket.

Simple ActiveRecord PostgreSQL full text backed by Arel

serializes rails models from postgres (9.5+)

pg_shrink makes it simple to shrink and sanitize a PosrgreSQL database

A collection of Postgres data definition SQL builders

This is not the official PostgreSQL library that was originally written by Guy Decoux. As the project wasn't maintained a long time after Guy's decease, I decided to create my own project.

Restricts SQL queries to single-statement DML with whitelisted tables, views, and functions.

Stream data from postgres or Redshift

A gem that makes working with tags stored in a Postgresql column easy. Support for array of string, integer and jsonb values.

Test postgresql scripts and run queries against a temporary postgresql instance

Store translations in your PG database as HSTORE, JSON or JSONB.

Trigram similarity, guaranteed equivalent to postgres's. Oh yeah.

Create PostgreSQL trigger with ActiveRecord Migration

Handy helpers to create PostgreSQL Triggers

Creates unlogged tables for testing.

Postgres connection string builder gem with construction through a prompt or Ruby method.