A driver-adjacent Ruby control-plane over ruby-pg/libpq. It multiplexes independent, session-neutral extended-protocol operations from many fibers onto a small number of PostgreSQL connections while keeping explicit transactions and session-changing work on exclusive pinned connections. Requires ...

A PGPool PCP interface wrapper.

rPGP ruby wrapper

Shows the top queries running on your server using pg_stat_statements

Parses SQL queries using a copy of the PostgreSQL server query parser(This is a fork of https://github.com/lfittl/pg_query. ) This repo includes extra deparser improvements.

Some experimentations with LISTEN/NOTIFY for background jobs

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

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

Safe, cross platform, shell calls

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

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

Production-grade PostgreSQL trigger management for Rails with lifecycle management, safe deploys, versioning, drift detection, and a mountable UI.

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

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

Create PostgreSQL trigger with ActiveRecord Migration

Handy helpers to create PostgreSQL Triggers