REST API for remote PostgreSQL database migrations.

Simple schema migrations for PostgreSQL, which runs pure SQL.

serializes rails models from postgres (9.5+)

pg_shrink makes it simple to shrink and sanitize a PosrgreSQL database

Construct composable, structured, PostgreSQL queries in plain Ruby.

A collection of Postgres data definition SQL builders

pg_space_cadet is a simple hack for postgreSQL and ActiveRecord which provides a uuids table of distributable identities of space cadets -- ActiveRecord::Base instances which use the SpaceCadetWrapper. Each space cadet has a default ActiveRecord id unique in the set of all local space cadets; a space cadet's id is derived from its uuid - UUID's are by design universally distributable.

Helper class for setting up and easily tearing down PostgreSQL database objects within a testing environment

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.

PostgreSQL Tasks and Functions for Ruby on Rails

Test postgresql scripts and run queries against a temporary postgresql instance

This small Ruby gem helps you integrate PostgreSQL with your Ruby web app, through Liquibase. It also adds a simple connection pool and query processor, to make SQL manipulation simpler.

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

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

Handy helpers to create PostgreSQL Triggers

Extensions to pg gem supporting typecasting.

Manage PostgreSQL custom types (composite types, enums, domains) in your Rails application with versioned migrations and schema handling. This cuts the need for keeping a structure.sql while still maintaining proper type definitions in your Rails application.

PostgreSQL notifications with persistence.

A pure ruby "thin" extension of pg that provides logging, transaction retrying, and database reconnecting functionality.