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

Gem implements multitable iheritance.

OpenTracing instrumentation to trace queries made using the Postgres Ruby driver

Optimize your Pivotal Tracker and Github workflow

pg_jbuilder is a tool to dump database queries directly to a JSON object or array. It uses PostgreSQL's JSON functions ([array_to_json and row_to_json](http://www.postgresql.org/docs/9.3/static/functions-json.html)) to serialize the JSON completely bypassing ActiveRecord/Arel. This gives a large speed boost compared to serializing the JSON inside of Ruby/Rails. It is perfect for creating JSON APIs with very low response times.

PgJob

A set of classes and micro-DSLs to generate SQL queries special for PostgreSQL backends.

PGlite for Ruby and Rails

This gem allows to monitor and notify about PostgreSQL database locks which meet certain criteria. You can report locks which are held for a certain amount of time, or locks which are held by a certain query.

Convert PostgreSQL notices to Ruby logger messages, in one proc

A tool to set up and manage logical replication for PostgreSQL databases

A ruby library for probabilistic graphical model

pg_meta gem

This game will eat your heart out and make you want to play it again and again. With limitless options decoupled with excellent code, you are going to want to take this baby to the bank as a template for the next World's Greatest Game. Change game options inside studio_game.rb. Poke around.

Process notifies about postgresql notifications.

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